Yes you need to combine IF and AND statements

=if(and(a10,b10),c1,if(and(a20,b20),c2,c3))

in the above example
if a1 0 and b10 return c1
else if a20 and b20 return c2
otherwise return c3

Regards

Dav


--
Dav
------------------------------------------------------------------------
Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107
View this thread: http://www.excelforum.com/showthread...hreadid=552223