ExcelBanter - Making a Cell Blank

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Making a Cell Blank (https://www.excelbanter.com/excel-discussion-misc-queries/234215-making-cell-blank.html)

Bob[_17_]

Making a Cell Blank

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

Dave Peterson

Making a Cell Blank

Maybe...

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

Notice the new comparison in that second if portion.

Bob wrote:

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

--

Dave Peterson

All times are GMT +1. The time now is 03:39 AM.