display negative values as a blank cell in Excel

P

pherozeb

Could someone please tell me how to display negative values calculated from a
formula as a blank cell in Excel
 
D

Dave Peterson

=if(yourformula<0,"",yourformula)


Could someone please tell me how to display negative values calculated from a
formula as a blank cell in Excel
Click to expand...
 
E

Earl Kiosterud

zeb,

If you only want it displayed as blank, retaining the value in the cell,
format the cell (Format - Cells - Number - Custom):

General;;General

Change the first General to any format code you want for positive numbers
(0.00, etc), and the other General for how you want zero values displayed.
 
Top