multiple if statements in one formula

[saraua]

I have 2 if statements that I am trying to combine into one formula. What is
the correct sequence for these to work?

 

[Dave]

Hi,
Post your 2 if statements. It'll make it easier for us to help you.
Dave.

 

[Skeletor]

=IF(C5>2,"Good Answer",IF(C5<2,"Another Good Answer","Wrong Answer"))

The second IF statement goes where the "False" Statement would normally be
and the "False" statement comes after. If you type = into a cell and use the
Functions drop down list to create your IF statement, then all you need to do
is click the IF function again, after clicking in the "Value if False" window.

 

[Dave]

Hi Skeletor,
You seem to have the 2 IF statements working ok. What was it you actually
wanted?
Dave.

 

[Dave]

Oops - sorry. Thought I was replying to to originator.
Dave.