display negative values as a blank cell in Excel

[Guest]

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

 

[Max]

Try something like:

=IF(A1+A2<0,"",A1+A2)

Replace "A1+A2" with your formula

 

[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

 

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