Formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi

=IF(ISNUMBER('input sheet'!K29),'input sheet'!K29,"")

This formula works BUT I need the cell to display as totally empty. At the moment if K29 has 0.00, then 0.00 is displayed.

Can anyone advies me what I need to put on the formula to achieve this. (ie if it's possible)
 
Try:

=IF(AND(ISNUMBER('input sheet'!K29),'input sheet'!
K29>0),'input sheet'!K29,"")

--
Rgds
Max
xl 97
---
Please respond in thread
xdemechanik <at>yahoo<dot>com
----

pjd said:
=IF(ISNUMBER('input sheet'!K29),'input sheet'!K29,"")

This formula works BUT I need the cell to display as
Click to expand...
totally empty. At the moment if K29 has 0.00, then 0.00
is displayed.
Can anyone advies me what I need to put on the formula to
Click to expand...
achieve this. (ie if it's possible)
 
Your a legend! Thanks
--
All help much appreciated.

Thanks


Max said:
Try:

=IF(AND(ISNUMBER('input sheet'!K29),'input sheet'!
K29>0),'input sheet'!K29,"")

--
Rgds
Max
xl 97
---
Please respond in thread
xdemechanik <at>yahoo<dot>com
----

pjd said:
=IF(ISNUMBER('input sheet'!K29),'input sheet'!K29,"")

This formula works BUT I need the cell to display as
Click to expand...
totally empty. At the moment if K29 has 0.00, then 0.00
is displayed.
Can anyone advies me what I need to put on the formula to
Click to expand...
achieve this. (ie if it's possible)
Click to expand...
 
Back
Top