Thread: getting IF and OR to work for 3 IF statements
View Single Post
 
Old 09-10-2014, 09:30 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Windows 7 64bit Office 2010 64bit
Expert
  
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,943
Pecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond repute
Default
=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
Reply With Quote