| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Join two functions
I have two if(and(or statements that work separately but cant figure out how to join them together into one. Is there a way to join or re-write the following to statements as one?
Statement 1 =IF(AND(OR($H:$H="Hard Advanced",$H:$H="Hard Standard"),$O:$O<= 10),"Met","Not Met") Statement 2 =IF(AND(OR($H:$H="Soft Advanced",$H:$H="Soft Standard"),$O:$O<= 5),"Met","Not Met") Please help. Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Join two functions to one column | Excel Programming | |||
| Join tables like inner join in Access | Excel Discussion (Misc queries) | |||
| SQL + INNER JOIN + ADO | Excel Programming | |||
| How to join two functions in a formula? | Excel Worksheet Functions | |||
Threaded Mode
