![]() |
|
#1
|
|||
|
|||
![]()
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 |
#2
|
|||
|
|||
![]()
Maybe as follows:
=IF(((I2>=30)+(I2>=25)*(J2>=55)+(I2>=5)*(J2>=60)), "Yes","") |
![]() |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
Lkh1004 | Excel | 3 | 12-16-2015 02:47 PM |
![]() |
cangelis | Excel | 2 | 04-08-2015 05:55 PM |
![]() |
teza2k06 | Excel | 1 | 03-11-2015 12:44 AM |
![]() |
Tony Singh | Excel | 6 | 03-04-2015 12:52 PM |
![]() |
limpbizkit | Excel | 4 | 02-24-2011 09:16 PM |