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
|