Thread
:
More than 2 IF options
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
David Biddulph[_2_]
external usenet poster
Posts: 8,651
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.
Reply With Quote
David Biddulph[_2_]
View Public Profile
Find all posts by David Biddulph[_2_]