=IF(N18=TODAY(),1,IF(N18<TODAY(),0,IF(N18>TODAY(),2,IF(Q18=complete(),2))))

I've set up icons to be displayed based upon dates. Green (tomorrow and beyond), yellow
(today), red (date is old). I want to be able to change the red icon to green icon only if the cell
is Q18 is marked complete (selected from a drop down list (Complete, Late, On Track,
Complete / Late).  This is the part of the formula not working.
nzdekeAsked:
Who is Participating?
 
barry houdiniConnect With a Mentor Commented:
Sorry, missed closing quotes - should be

=IF(Q18="Complete",2,IF(N18=TODAY(),1,IF(N18<TODAY(),0,IF(N18>TODAY(),2))))

regards, barry
0
 
nzdekeAuthor Commented:
Look at formula in R18. 0ExcelQuestion.xlsx
0
 
barry houdiniCommented:
Change the order to check for "Complete" first, i.e.

=IF(Q18="Complete,2,IF(N18=TODAY(),1,IF(N18<TODAY(),0,IF(N18>TODAY(),2))))

regards, barry
0
 
nzdekeAuthor Commented:
Barry - Thank you!!!
0
 
nzdekeAuthor Commented:
I worked for 3 days on this and made a stupid mistake. Barry was quick and efficient!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.