D D Mar 30, 2008 #1 How can I make a positive number in cell say B12 turn to a negative number in cell B18? thanks
N Niek Otten Mar 30, 2008 #2 In B18: =-B12 -- Kind regards, Niek Otten Microsoft MVP - Excel | How can I make a positive number in cell say B12 turn to a negative number | in cell B18? | | thanks |
In B18: =-B12 -- Kind regards, Niek Otten Microsoft MVP - Excel | How can I make a positive number in cell say B12 turn to a negative number | in cell B18? | | thanks |
S Stan Brown Mar 30, 2008 #3 Sun said: How can I make a positive number in cell say B12 turn to a negative number in cell B18? Click to expand... In cell B18 put =-B12 If B12 is negative that will make B18 positive. If you want B18 to be negative whether B12 is positive or negative, put this in B18: =-ABS(B12)
Sun said: How can I make a positive number in cell say B12 turn to a negative number in cell B18? Click to expand... In cell B18 put =-B12 If B12 is negative that will make B18 positive. If you want B18 to be negative whether B12 is positive or negative, put this in B18: =-ABS(B12)
