IF NEGATIVE VALUE REPLACE WITH POSITIVE

[veena]

Hi, I have a 3 columns A shows the total on hand and B shows whats in the
warehouse and Column C is suppose to give me the quantity in the stores. i
have 2 questions why is it when i have the formula like C3 the formula gives
me the message of #value why doesnt it just show as -7000? 2nd question I
need a formula in column C that will subtract A and C and if its negative to
make it a positive. please advise thanks
A B C
1)4000 500 =A1-B1
2)2000 100 =A2-B2
3)7000 0 =A3-B3

 

[Otto Moehrbach]

Your first question: Is one of the numbers actually text?
Second question: Change the formula to ABS(thiscell-thatcell). HTH Otto

 

[JasonP CCTM LV]

To make the negative show as positive use =if((a1-b1)<0,(-(a1-b1)),(a1-b1))

Hi, I have a 3 columns A shows the total on hand and B shows whats in the
warehouse and Column C is suppose to give me the quantity in the stores. i
have 2 questions why is it when i have the formula like C3 the formula gives
me the message of #value why doesnt it just show as -7000?

2nd question I need a formula in column C that will subtract A and C and if
its negative to make it a positive. please advise thanks

 

[John C]

To make a negative show as a positive, you can do this:
=ABS(A1-B1)