Making a Cell Blank

  • Thread starter Thread starter Bob
  • Start date Start date
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
 
Maybe...

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

Notice the new comparison in that second if portion.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

=I34*H34 without N/A 9
NEED HELP 3
Help with Control Array Sum Formula 12
Macro Problems 2
sumif? 3
Sum Formula Showing Instead of Value :( 3
Colorising cells from code 4
rounding down another cell with a formula 3

Back
Top