| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Some Positive, Some Negative | Excel Worksheet Functions | |||
| How to add all positive and negative numbers? | Excel Worksheet Functions | |||
| IF positive/If negative???? | Excel Worksheet Functions | |||
| Formula to make Negative Values Positive & Positive Values Negative? | Excel Discussion (Misc queries) | |||
| Highlighting positive and negative changes | Excel Discussion (Misc queries) | |||
Threaded Mode
