display negative values as a blank cell in Excel
 

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

Try something like:

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

Replace "A1+A2" with your formula
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"pherozeb" wrote in message
...
Could someone please tell me how to display negative values calculated
from a
formula as a blank cell in Excel

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



pherozeb wrote:

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

--

Dave Peterson

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.



--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"pherozeb" wrote in message
...
Could someone please tell me how to display negative values calculated
from a
formula as a blank cell in Excel