Cell empty if value is 0?????

[hoyos]

I have the following formula in cell "F160"
=IF($C160,C160,0)

If I wish cell "F160" to be empty if cell "C160" = 0
How do add to the formula

 

[Tom Hutchins]

Try this in F160:

=IF(C160=0,"",C160)

Hope this helps,

Hutch

 

[PhilosophersSage]

Try:
If($C160="0","",C160)

 

[Stefi]

If you have a formula in F160 then it can't be empty (=ISBLANK(F160) returns
FALSE).

=IF(C160=0;"";C160) in F160 will display nothing.

Regards,
Stefi

„hoyos†ezt írta:

 

[Eduardo]

Hi,
=if($c160=0,"",$c160)

 

[Luke M]

=IF($C160,C160,"")

 

[hoyos]

Thank you all for replying. PhilosophersSage worked the best.

 

[Dave Peterson]

F160 can never be empty (since it contains the formula). But you can make it
look blank.

=if($c160=0,"",c160)

or maybe...

=if($c160="","",c160)

Is there a reason you used that $ in one portion, but not the other???

 

[Dave Peterson]

I'd keep an eye out on that formula.

Thank you all for replying. PhilosophersSage worked the best.

 

[David Biddulph]

PhilosophersSage's formula will work if you are testing for the text string
"0".
Most other contributors to the thread assumed that by 0 you meant the number
0.