Nested function?

B

Basic93

New member
Joined
Jun 14, 2018
Messages
1
Reaction score
0
Points
0
Excel Version(s)
2010
Hi all, I would like to ask you regarding with the excel conditional function. For example, I have multiple arguments for the date reminder as below for manual entry date in B column.
=IF(OR(ISBLANK(B2)),"",IF(B2-TODAY()<7,"Alert", IF(B2-TODAY()<14,"Coming Soon","")))
However, I want to add one more argument from different column, which has conflict to one of the IF conditionals. If the date in D column is the same or before the dates that entered in B column, then I wanna have as a "complete". Thank you.
 
Do you mean?

=IF(ISBLANK(B2),"",IF(D2<=B2,"Complete",IF(B2-TODAY()<7,"Alert",IF(B2-TODAY()<14,"Coming Soon",""))))
 
Another approach, which allows to you change/add extra conditions easily:
=IF(ISBLANK(B2),"",IF(D2<=B2,"Complete",INDEX({"Overdue","Alert","Coming Soon",""},MATCH(B2-TODAY(),{-9000000,0,7,14}))))
 
You must log in or register to reply here.
Back
Top