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

Please Login or Register  to view this content.

)

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.

Please Login or Register  to view this content.

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

Please Login or Register  to view this content.

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.

Please Login or Register  to view this content.

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

Have not figured out how to Post in this form.

Got it...Thanks