trying to set a text value in if function
in cell G4 and G8, the value is less than the value set in cell J4 but it shows Fail, yet in cell J8 with same value it shows Pass. The only variation is in cell G4 it is text value for f f set in C4 and E4 cells. What the output in column J should be 80% of the value in column H. It should show Pass in cell J4
Last edited by wykoems; 10-05-2017 at 06:42 PM.
Does the value have to be a text value? If not, remove the quotes around the number and it will be a number value then the formula should work as expected.
1N73LL1G3NC3 15 7H3 4B1L17Y 70 4D4P7 70 CH4NG3 - 573PH3N H4WK1NG
You don't have to add Rep if I have helped you out (but it would be nice), but please mark the thread as SOLVED if your issue is resolved.
Tom
G4 is not a number it's text, unlike G8 which is a number. You can test this with =ISNUMBER(G4)
In general though don't enter text 'numbers' in formulae if you want real numbers.
So instead of
Formula:
=IF(C4="n/a","n/a",IF(E4="n/a","n/a",IF(C4="f f","0.10",IF(E4="f f","0.10",SUM(SUM(C4-E4))))))
use
Formula:=IF(C4="n/a","n/a",IF(E4="n/a","n/a",IF(C4="f f",.1,IF(E4="f f",.1,SUM(SUM(C4-E4))))))
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
Thanks all for solving and supporting my query, again thank you.
You're welcome.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks