#Value!

[CAM]

Hello,

How do I get rid of this error message from my cell -#Value!. I have a cell
C1 which has a number for example 500 and C2 I have XXX in the cell and C3 I
used this formula =C1-C2, but I get the #Value! error message. What is
funny about this is on one worksheet cell C3 returns the number 500, but on
another worksheet I get the error message. Why? and how do get the value?
Any tips will be appreciated. Thank you in advance.

Cheers

 

[T. Valko]

The problem is that you're attempting to subtract a TEXT value from a
numeric value.

What do you want to happen when C2 contains a TEXT entry?

Maybe something like this:

=C1-IF(ISNUMBER(C2),C2,0)