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

Hi,

Am Fri, 27 May 2016 16:34:17 +0100 schrieb b_nuruddin:

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")

try in row 1:
=IF(OR(AND(LEFT(H1,4)="Hard",O1<=10),AND(LEFT(H1,4 )="Soft",O1<=5)),"Met","Not Met")
ans copy down.


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional

Hi Claus B.

Solution worked like a charm.
Thanks for the speedy reply.

Regards,
Nuruddin