More than 2 IF options

  • Thread starter Thread starter Kim L
  • Start date Start date
K

Kim L

Hello,

I am trying to create a formula that will give three possible results for a
result in another cell. The answer in cell C1 may be 4. Then in cell D1 I
want it to give me a readout of "ON TIME" if C1<4, "SLOW" if C1=4, and "LATE"
if C1>4. How do I create that formula???

I tried =IF(AND(C1<4, C1=4, C1>4), "ON TIME", "SLOW", "LATE"), but it didn't
work. It stated that I entered too many arguments for this function.
 
=IF(C1<4, "ON TIME", IF(C1=4, "SLOW", "LATE"))

[Note that if you type the word IF or AND into Excel help, it will tell you
the syntax of the function, explain the functionality, and give examples.]
 
=IF(C4<4,"ON TIME",IF(C4=4,"SLOW","LATE"))

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
For an alternate approach...

=CHOOSE(SIGN(C1-4)+2,"ON TIME","SLOW","LATE")

Rick
 
Back
Top