Sumif???

[KellyMcG03]

Okay I know now to take to quotes out for the TRUE catagory, but

=IF(D22>0,(SUM(EDATE(B22,12))+J22),"N/A")

the cell d22 is blank and I am still get the TRUE answer

Why isn't excel reading a blank cell as a 0 ???

 

[Ken]

Kelly, you might want to "Post Reply" instead of a "New
Post" each time. It will keep everything in the same
thread. Anyway, how about this?

=IF(OR(D22>0,D22=""),(SUM.......

 

[Frank Kabel]

Hi
try:
=IF(N(D22)>0,EDATE(B22,12)+J22,"N/A")