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?