#VALUE! error

[AnDy]

I have this formula that is drving me nuts, =IF(D13=0,"",
(D13*100)) keeps returning a #value! error.

Cell D13 has a value of 0 but this keeps returning a
error, When I take out *100 in the formula it works fine,
can anyone help me?

Thanks

 

[Michael]

Hi AnDy
Remove the inner set of brackets.
=IF(D13=0,"",D13*100)

Regards
Michael

 

[hgrove]

AnDy wrote...

I have this formula that is drving me nuts,
=IF(D13=0,"",(D13*100)) keeps returning a #value! error.

Cell D13 has a value of 0 but this keeps returning a error, When
I take out *100 in the formula it works fine, can anyone help
me?

If the formula =ISNUMBER(-D13) returns FALSE, your D13 cell may appea
to contain 0, but it would in fact contain text very likely includin
nonbreaking spaces following the 0. That would cause this error. If so
you need to clean up the entry in cell D13

 

[AnDy]

Sorry I posted the wrong formula.

The formula that I'm having trouble with is as follows: =IF
(B14=0,"",1-(C14/B14))*100

When cell B14 =0 I keep getting a #VALUE! error, what's
weird is that when I remove the *100 the error goes away
and the formula works with NULL returning.

Any ideas?

Thanks

 

[javaeboy]

=IF(B14=0,"",1-((C14/B14)*100))

Seems to work. What are you trying to accomplish with the *100? Give
me an example of what numbers would appear in C14 & C15 and what you
want to get as a result and I'll try to help.