IF NEGATIVE VALUE REPLACE WITH POSITIVE
 

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

IF NEGATIVE VALUE REPLACE WITH POSITIVE
 

Your first question: Is one of the numbers actually text?
Second question: Change the formula to ABS(thiscell-thatcell). HTH Otto
"veena" wrote in message
...
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

IF NEGATIVE VALUE REPLACE WITH POSITIVE
 

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

"veena" wrote:

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