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