Making a Cell Blank

B

Bob

How can I change this formula: "=IF(J34="","",IF(L34-J34-Q34=0,"",L34-
J34-Q34))" so the cell will be blank if it is 0 or less than 0?

Thanks
 
D

Dave Peterson

Maybe...

=IF(J34="","",IF(L34-J34-Q34<=0,"",L34-J34-Q34))

Notice the new comparison in that second if portion.
 
Top