Formula

P

pjd

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)
 
M

Max

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)
 
P

pjd

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Include varying cell references in formulas based on changing crit 1
Autonumber field in Excel that behaves the same as Access 0
Copy addition formula of non-consecutive horizontal cells 2
Display weeks from a Milestone 0
Assistance in modifying a formula 0
Help with formula 2
More Archiving Problems 0
Visio: copy text of a master shape to User-define Cells (Variable) 0

Top