S
saraua
I have 2 if statements that I am trying to combine into one formula. What is
the correct sequence for these to work?
the correct sequence for these to work?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
Dave
Hi,
Post your 2 if statements. It'll make it easier for us to help you.
Dave.
Post your 2 if statements. It'll make it easier for us to help you.
Dave.
S
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.
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.
D
Dave
Hi Skeletor,
You seem to have the 2 IF statements working ok. What was it you actually
wanted?
Dave.
You seem to have the 2 IF statements working ok. What was it you actually
wanted?
Dave.
D
Dave
Oops - sorry. Thought I was replying to to originator.
Dave.
Dave.