View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
svenk
 
Posts: n/a
Default 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