Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 09-06-2016, 06:19 AM
mrry475 mrry475 is offline IF statement Windows XP IF statement Office 2013
Novice
IF statement
 
Join Date: Sep 2016
Posts: 1
mrry475 is on a distinguished road
Default IF statement

I am trying to create an IF statement with the information listed below.



If I2 is greater than or egual to 30, then YES

OR

If I2 is greater than or equal to 25 AND J2 is greater than or equal to 55, then YES

OR

If I2 is greater than or equal to 5 AND J2 is greater than or equal to 60, then YES
Reply With Quote
  #2  
Old 09-06-2016, 09:30 AM
xor xor is offline IF statement Windows 10 IF statement Office 2016
Expert
 
Join Date: Oct 2015
Posts: 1,097
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default

Maybe as follows:

=IF(((I2>=30)+(I2>=25)*(J2>=55)+(I2>=5)*(J2>=60)), "Yes","")
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
IF statement IF Statement Lkh1004 Excel 3 12-16-2015 02:47 PM
IF statement Need a little help with an if statement cangelis Excel 2 04-08-2015 05:55 PM
IF statement IF Statement teza2k06 Excel 1 03-11-2015 12:44 AM
IF statement If statement, may be? Tony Singh Excel 6 03-04-2015 12:52 PM
IF statement Help with IF Statement limpbizkit Excel 4 02-24-2011 09:16 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:49 AM.


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