More than 2 IF options
 

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 C14. How do I create that formula???

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

More than 2 IF options
 

=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.]
--
David Biddulph

"Kim L" <Kim wrote in message
...
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 C14. How do I create that formula???

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

More than 2 IF options
 

=IF(C1=4,"ON TIME",IF(C1<4,"SLOW","LATE"))
--
Gary''s Student - gsnu200763

More than 2 IF options
 

=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)



"Kim L" <Kim wrote in message
...
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 C14. How do I create that formula???

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

More than 2 IF options
 

For an alternate approach...

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

Rick


"Kim L" <Kim wrote in message
...
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 C14. How do I create that formula???

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