Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Combining functions: Subtraction and IF
I am trying to combine 2 functions. I need the formula to first calculate this:
=C3-K3. Based on the value returned i need to combine it with the formula below. =IF((E3< 0),"On Time") I want it to return "On Time" if the value of the first subtraction yields 0. if the returned vale is 0, I need it to return the diff of the original subtraction. Thanks |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Combining functions: Subtraction and IF
If the values you're dealing with are *always* positive then the only way to
get 0 when subtracting C3-K3 is if both cells are equal. If that's the case: =IF(C3=K3,"On Time",C3-K3) Here's a generic version that accounts for not having defined what to do if C3-K3 <0: =IF(C3-K3=0,"On Time",IF(C3-K30,C3-K3,"")) Neither formula accounts for having empty cells. -- Biff Microsoft Excel MVP "Jeguth1s" wrote in message ... I am trying to combine 2 functions. I need the formula to first calculate this: =C3-K3. Based on the value returned i need to combine it with the formula below. =IF((E3< 0),"On Time") I want it to return "On Time" if the value of the first subtraction yields 0. if the returned vale is 0, I need it to return the diff of the original subtraction. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Combining IF & AND functions | Excel Discussion (Misc queries) | |||
Combining functions AND and OR | Excel Worksheet Functions | |||
Combining IF and OR Functions | Excel Discussion (Misc queries) | |||
Combining IF OR and AND functions | Excel Worksheet Functions | |||
Combining functions | Excel Worksheet Functions |