View Single Post
  #2   Report Post  
Max
 
Posts: n/a
Default

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