I don't think it needs to be that complex, as long as A2 and A3 MUST contain
either "Yes" or "No". If A2="Yes" it doesn't matter what's in A3.

"JulieD" wrote:

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!