Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 09-10-2014, 06:48 AM
nero6014 nero6014 is offline getting IF and OR to work for 3 IF statements Windows 8 getting IF and OR to work for 3 IF statements Office 2010 64bit
Novice
getting IF and OR to work for 3 IF statements
 
Join Date: Sep 2014
Posts: 2
nero6014 is on a distinguished road
Default getting IF and OR to work for 3 IF statements


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")
Reply With Quote
  #2  
Old 09-10-2014, 09:30 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline getting IF and OR to work for 3 IF statements Windows 7 64bit getting IF and OR to work for 3 IF statements Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,919
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
  #3  
Old 09-10-2014, 10:25 AM
nero6014 nero6014 is offline getting IF and OR to work for 3 IF statements Windows 8 getting IF and OR to work for 3 IF statements Office 2010 64bit
Novice
getting IF and OR to work for 3 IF statements
 
Join Date: Sep 2014
Posts: 2
nero6014 is on a distinguished road
Default Worked great

Thanks for your corrected formula, it worked fine!
Reply With Quote
  #4  
Old 09-16-2014, 07:28 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline getting IF and OR to work for 3 IF statements Windows 7 64bit getting IF and OR to work for 3 IF statements Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,919
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

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
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
getting IF and OR to work for 3 IF statements Multiple If statements, Jamal NUMAN Excel 16 11-15-2022 11:59 PM
getting IF and OR to work for 3 IF statements count if statements 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

Other Forums: Access Forums

All times are GMT -7. The time now is 09:49 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft