CODEWITHSUNDEEP
excelexcel-formula
Orcan Fikirdanis
Orcan Fikirdanis

Reputation: 3

Excel - leave blank if reference cell is blank

I have a table that uses following formula to calculate +357 to display "NO" or "YES"

=IF(AND(TODAY()<M3+357),"NO","YES")

My problem is; I want this cell to display nothing when the reference "M3" cell is blank.

Help would be greatly appreciated.

Upvotes: 0

Views: 9376

Answers (1)

Emmanuel P
Emmanuel P

Reputation: 36

You can nest another IF:

This should do what you are looking for:

=IF(ISBLANK(M3),"",IF(AND(TODAY()<M3+357),"NO","YES")

Upvotes: 1

Related Questions