Join two functions
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
|