Cell empty if value is 0?????
 

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

Cell empty if value is 0?????
 

Try this in F160:

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

Hope this helps,

Hutch

"hoyos" wrote:

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

Cell empty if value is 0?????
 

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

"hoyos" wrote:

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

Cell empty if value is 0?????
 

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:

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

Cell empty if value is 0?????
 

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

"hoyos" wrote:

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

Cell empty if value is 0?????
 

=IF($C160,C160,"")

--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"hoyos" wrote:

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

Cell empty if value is 0?????
 

Thank you all for replying. PhilosophersSage worked the best.

"Luke M" wrote:

=IF($C160,C160,"")

--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"hoyos" wrote:

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

Cell empty if value is 0?????
 

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

hoyos wrote:

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

--

Dave Peterson

Cell empty if value is 0?????
 

I'd keep an eye out on that formula.


hoyos wrote:

Thank you all for replying. PhilosophersSage worked the best.

"Luke M" wrote:

=IF($C160,C160,"")

--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"hoyos" wrote:

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

--

Dave Peterson

Cell empty if value is 0?????
 

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.