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