Originally Posted by Claus Busch

Hi,

=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")[/i][/color]

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

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