Sumif???

K

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 ???
 
K

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.......
 
Top