View Single Post
  #1   Report Post  
b_nuruddin b_nuruddin is offline
Junior Member
 
Posts: 4
Default 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