Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
how do I add more toolbar options to my right click options | Excel Discussion (Misc queries) | |||
Options | Excel Discussion (Misc queries) | |||
Web Options? | Excel Discussion (Misc queries) | |||
FTP options | Excel Discussion (Misc queries) | |||
what are my options? | Excel Discussion (Misc queries) |