IF formula has error..but I can't see why

  • Thread starter Thread starter DannyJ
  • Start date Start date
D

DannyJ

Hi folks,

This formula is giving me an #value error but I do not know why.

Any help much appreciated

=IF(I27-0.3125>=0,I27-0.3125,"")

The formula appears in merged columns K & J.

Thanks in advance,

Danny
 
Hi DannyJ,

I guess the only possible cause is that [I27] has text and not a value.

Regards,
KL
 
Hi Danny,
You can check if I27 is a number using
=ISNUMBER(I27)
alternatively you can check if I27 is text using
=ISTEXT(I27)

Changing the format from number to text or from text to number
does not actually occur until you reenter number or string.

You might try the TRIMALL macro
http://www.mvps.org/dmcritchie/excel/join.htm#trimall
and you can read more about determining what you actually have
in the way of data. If you extracted information from the web,
you are likely to have CHAR(160) or nonbreaking space( )
also known as a required blank. The TrimALL macro will take care of them.



KL said:
Hi DannyJ,

I guess the only possible cause is that [I27] has text and not a value.

Regards,
KL


DannyJ said:
Hi folks,

This formula is giving me an #value error but I do not know why.

Any help much appreciated

=IF(I27-0.3125>=0,I27-0.3125,"")

The formula appears in merged columns K & J.

Thanks in advance,

Danny
Click to expand...
Click to expand...
 
Hi Danny, I just copied this formula straight into a blank worksheet in cell
J27 and it works fine. You may want to check your relative references if
you've copied the formula over from J27 to K27. That returns a #VALUE!
error.
 
Back
Top