formula to get rid of #value sign
Posted by Lars on January 10, 2002 9:26 AM
Here is my formula
=IF(I4=(RIGHT(I5,3)&"/"&LEFT(I5,3)),J4+J5,IF(I4<>(RIGHT(I3,3)&"/"&LEFT(I3,3)),J4,""))
I'm trying to add if(Iserror to get rid of the #value but it doesn't work.
Help please
Thanks
Posted by bob Umlas on January 10, 2002 10:03 AM
It seems like wither J4 or J5 is text which you're adding together, or perhaps J4 already contains #VALUE!.
Try replacing J4+J5 with SUM(J4,J5).
If that doesn't work, you can format the cell to hide a #VALUE! error:
Make the font white (actually match the background), and give the cell a number format which includes [black] (including the brackets), like:
[black]#,##0_)(#,##0)
for example. The [black] numberformat overrides the white font, unless it's an error, which you then won't see.
HTH
