![]() |
#1
|
|||
|
|||
![]() I cannot get this formula to work and have tried everything I can think of, please help =IF(J4<=H4,"PASS")OR(J4>H4,"FAIL")OR(J4=0,"N/A") |
#2
|
||||
|
||||
![]()
=IF(J4<=H4,"PASS",if(J4>H4,"FAIL",if(J4=0,"N/A")))
BUT these conditions are not correct. For exampls if J4=0 can it be <H4 ? If yes you will get" PASS" not "N/A". If H4<0 and J4=0youill get " FAIL" not "N/A". You need to review your condtions in the light of possible values. Perhaps Code:
=IF(J4=0,"N/A",IF(J4<=H4,"PaSS","FAIL"))
__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#3
|
|||
|
|||
![]()
Thanks for your corrected formula, it worked fine!
|
#4
|
||||
|
||||
![]()
Thx for the reputation
__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
![]() |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
Jamal NUMAN | Excel | 16 | 11-15-2022 11:59 PM |
![]() |
Alaska1 | Excel | 1 | 05-14-2014 08:21 AM |
If Statements in a form | Sammie0Sue | Word VBA | 4 | 03-12-2014 01:16 AM |
Multiple If statements | bremen22 | Excel | 2 | 10-15-2013 06:37 AM |
IF statements that shifts to right. | kent | Excel | 0 | 01-19-2006 02:23 PM |