| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can you formulate a cell to add and subtract in the same cell?
I have a subtotal and the next cell could be either an addition or a
subtraction from the subtotal. Can you do this with a formula? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Can you formulate a cell to add and subtract in the same cell?
Yes, with an IF function call, but there needs to be some identifiable
"trigger" that chooses one over the other. For example, if your "trigger" could be cell B1 contains a 0 to select addition and any other value to select subtraction. Assuming your SubTotal is in A1000, and the value you want to either add or subtract is in B1000, and the trigger value is in B1 (0 for addition, anything else for subtraction), then this is the formula you would use is this... =IF(B1=0,A1000+B1000,A1000-B1000) Rick "jmuncy" wrote in message ... I have a subtotal and the next cell could be either an addition or a subtraction from the subtotal. Can you do this with a formula? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| formulate all in one cell | Excel Worksheet Functions | |||
| Formulate a cell to change color when above/below an amount? | Excel Worksheet Functions | |||
| How do I formulate colored cell from master sheet? | Excel Programming | |||
| HOW DO I FORMULATE A CELL TO ROUND $5.82 TO $5.85 | Excel Discussion (Misc queries) | |||
| Excel: how to formulate conditional cell references | Excel Worksheet Functions | |||
Linear Mode
