View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
 
Posts: 8,651
Default 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.