Help - combine OR and AND in IF function
 

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

Help - combine OR and AND in IF function
 

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

Help - combine OR and AND in IF function
 

Try this in D1

=IF(A10,IF(B1="x",C1,IF(B1="y",E1,"")),"")


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

Help - combine OR and AND in IF function
 

Daddylonglegs - thank you so much. Works great.
S.


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