Excel IF Function

  • Thread starter Thread starter WombatMan99
  • Start date Start date
W

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
 
=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)
 
Bob Phillips, I just tried your suggestion and guess what IT WORKED!!!.
Thanks for replying
 
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)
 
ry,

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


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