0

I'm subtracting 2 dates. If the dates are <=5 then the answer is Y, if not then the answer is N. How do I ignore blank cells so I don't automatically get a Y? This is the formula I'm using.

=IF(G2-C2<=5,"Y","N")

1 Answers1

1

One way among many others is to use ISBLANK, OR, and nested IFs:

=IF(OR(ISBLANK(C2),ISBLANK(G2)),"",IF(G2-C2<=5,"Y","N"))
mpez0
  • 2,842
Wicket
  • 715
  • 3
  • 16