Want to keep the cell blank if reference values are blank

Joyjenz

Hi, I have this formula below, it works well, though when the reference cells are blank I want it to return blank. But, instead it returns "red" symbol if blank reference and "Yellow" if wording is mentioned other than a check mark.

=IFERROR(IF(Done@row = 1, "Green", IF([Due date calculator]@row <= -1, "Red", IF([Due date calculator]@row <= 3, "Yellow", "Blue"))), "")

Kerry St. Thomas

It appears that the calculations might be including blank/s as part of the numerical calculations. Consider adding an explicit clause at the beginning of the formula, instead of ISERROR? Something along these lines:

=IF(ISBLANK([Due date calculator]@row),"",IF(Done@row=1………..

Good luck!