Excel IF Function

[WombatMan99]

I am using the =IF function in Excel 2000. I want to write a cod
something like this =IF(A=B) AND (C=D) THEN OPTION 1 ELSE OPTION 2.
Every time I try to write it I get an Invalid message. Please help

 

[Bob Phillips]

=IF(AND(A=B,C=D),OPTION1,OPTION2)

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[WombatMan99]

Bob Phillips, I just tried your suggestion and guess what IT WORKED!!!.
Thanks for replying

 

[Bob Phillips]

Had me worried for a bit there<g>

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Soo Cheon Jheong]

ry,

=IF((A=B)*(C=D),OPTION1,OPTION2)


--
Regards,
Soo Cheon Jheong
_ _
^ ^
v