Home |
Search |
Today's Posts |
#1
|
|||
|
|||
The "IF" Statement
i am trying to get a formula to change negative numbers into positive numbers
if they are negative and only on certain documents; these documents have a # 2 or 3 indicating the document types in Column D; The figures that i want to change into negative if positive and positive if currently negative are in column G; H; I; & J; The formula that i had typed out is wrong and it goes a little something like this: =IF($D7=2, ($G7=$G7*-1; $H7=$H7*-1; $I7=$I7*-1; $J7=$J7*-1),IF($D7=3,($G7=$G7*-1; $H7=$H7*-1; $I7=$I7*-1; $J7=$J7*-1), $D7="Null")) if someone could please point out to me the problem with this? and maybe suggest a formula to fix this? Please? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Long IF Statement | Excel Discussion (Misc queries) | |||
If statement | Excel Discussion (Misc queries) | |||
Do I need a sumif or sum of a vlookup formula? | Excel Worksheet Functions | |||
IF Statement nightmare | Excel Discussion (Misc queries) | |||
How to calculate a sum as one outcome of an IF statement | Excel Worksheet Functions |