Hi

Into D1 enter the formula
=IF(AND(A10,B1="x"),C1,IF(AND(A10,B1="y"),E1,"") )

Arvi Laanemets


"svenk" wrote in message
...

Hi,
could you help me figure out how to combine OR and AND in an IF
function:

Basically I want to say:

IF cell A0 and cell B="x" assign the number from cell C to Cell D
IF cell A0 and cell B="y" assign the number from cell E to Cell D

Can I do this in one command?

Thanks for your input!!
S.


--
svenk
------------------------------------------------------------------------
svenk's Profile:
http://www.excelforum.com/member.php...o&userid=31444
View this thread: http://www.excelforum.com/showthread...hreadid=511335