#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
Maybe as follows:
=IF(((I2>=30)+(I2>=25)*(J2>=55)+(I2>=5)*(J2>=60)), "Yes","") |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
IF Statement | Lkh1004 | Excel | 3 | 12-16-2015 02:47 PM |
Need a little help with an if statement | cangelis | Excel | 2 | 04-08-2015 05:55 PM |
IF Statement | teza2k06 | Excel | 1 | 03-11-2015 12:44 AM |
If statement, may be? | Tony Singh | Excel | 6 | 03-04-2015 12:52 PM |
Help with IF Statement | limpbizkit | Excel | 4 | 02-24-2011 09:16 PM |