Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF Function with equation and text
I am trying to set up an if function. I need the function to display if
acutual transit time is greater than estimated transit time. I need it to say how days late a shipment is if it is late. I can set it up were it will give me the number of days or for it to show "Late" but i can't it to say for example: "3 days late". Can someone please explain to me how to do this. Thanks! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF Function with equation and text
If the dates are in A1 and B1, then:
=IF(A1<B1,B1-A1 & " days late","") -- Gary's Student "DJC0402" wrote: I am trying to set up an if function. I need the function to display if acutual transit time is greater than estimated transit time. I need it to say how days late a shipment is if it is late. I can set it up were it will give me the number of days or for it to show "Late" but i can't it to say for example: "3 days late". Can someone please explain to me how to do this. Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I use Excel to solve an equation? | Excel Worksheet Functions | |||
VBA function for "Mean" using Array as argument | Excel Worksheet Functions | |||
memory? Excel Equation Function / Cond. Formatting Dropout | Excel Discussion (Misc queries) | |||
Equation in text string? | Excel Discussion (Misc queries) | |||
Complex if and mid function. | Excel Worksheet Functions |