Excel 2007 : IF and OR

need to know how to use the functions IF and OR when used together
I have a survey and that have two possible answers - if a Yes then I want one message, if a No answer than I want a different message.

A typical formula would be

=IF(OR(A1=1,B1=1,....),"Message 1","Message 2"

)

But to be able to help you we need more information on the cells and values

If you are looking to have 3 options (yes, no and other) then the below formula will work. Replace the Message One and Message Two text with the appropriate message.

C3=IF(B3="Yes","Message One",IF(B3="No","Message Two",""))

If you are just doing Yes and No then you could use the shorter formula below with one IF statement

C3=IF(B3="Yes","Message One","Message Two")

Let me know if this is what you were looking for!

Thanks!

A1 will be Yes or No...and I want to get a text mesage from another cell based on the Yes/No response

If and or will not help you.

With A1 as the only variable the a double IF will be your answer.

=IF(A1="YES",B1,IF(A1="NO",C1,"")

Where B1 and C1 is the cells with message to fetch and that will be displayed in A1

Got it...Thanks

Have not figured out how to Post in this form.