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? |
#2
|
|||
|
|||
The "IF" Statement
On Tue, 18 Oct 2005 11:45:03 -0700, "JeremyH1982"
wrote: 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? A function can only return a value; it cannot change something in some other cell. You could have functions in some kind of mirror column or you could use a VBA macro to accomplish your task; and then run it or have it run depending on a worksheet or workbook change event. For the functions you could make your entries in G7:J7 as you have; but then for display or future computations have your numbers showing in, let us say AG7:AJ7. You would then put the formula: AG7: =IF(OR($D7={2,3}),ABS(G7),G7) and copy/drag that across to AJ7 For writing a VBA macro, it would be important to know whether the values in columns G:J are put there by direct entry, or as the result of a formula. --ron |
Reply |
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 |