Microsoft Office Forums

Go Back   Microsoft Office Forums > >
Reload this Page getting IF and OR to work for 3 IF statements
Register FAQ

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

« Previous Thread | Next Thread »


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.

Contact Us - Privacy Statement - Top

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