Hi Julie,

The not sure condition can never be met as stated by OP, you just need

=IF(OR(A2=A3,AND(A2="Yes",A3="No")),"okay","proble m")

--

HTH

RP
(remove nothere from the email address if mailing direct)


"JulieD" wrote in message
...
Hi Darin


=IF(OR(A2=A3,AND(A2="Yes",A3="No")),"okay",IF(AND( A2="No",A3="Yes"),"problem
","not
sure"))

Cheers
JulieD


"Darin Kramer" wrote in message
...


Howdie

Spreadsheet 1 columns and 2 rows.
In A2, either a yes or no
In A3 either a yes or no
I need to put in A4 formulae that will tell me:
If a2 = a3 are equal,put "okay".
If a2 = No, and a3 = yes, Put "problem"
If a2 = Yes and a3 = No, put "okay"

Thanks so much

D



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!