If formula
Posted by Lars on January 10, 2002 3:16 PM
Hers is my formula I need it bring back a blank if it can't find a value, it brings back a #value right now
=IF(I4=(RIGHT(I5,3)&"/"&LEFT(I5,3)),J4+J5,IF(I4<>(RIGHT(I3,3)&"/"&LEFT(I3,3)),J4,""))
I tried =if(Iserror - not working
Thanks
Posted by Mark W. on January 10, 2002 3:52 PM
I think Bob Ulmas already responded; see 14444.html (nt)
Posted by Scott on January 10, 2002 3:56 PM
By using the "&" in the formula, it is concatenating text. The formula can see if it's equal to I4, but it does not know if its Greater than or Less than I4, because you're comparing text to it.
Posted by Scott on January 10, 2002 4:04 PM
Change of thought....
Posted by Scott on January 10, 2002 4:06 PM
Re: Change of thought....
After trying your formula, it worked ok for me. However, when I changed J4 or J5 to a word (text), I got #value for a result. Everything else came back OK. Take a look at these two cells and make sure they contain numbers.
