Can you formulate a cell to add and subtract in the same cell?

  • Thread starter Thread starter jmuncy
  • Start date Start date
J

jmuncy

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?
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to subtract a number from a Mergefield? 0
I need to add multiple cells then subtract them from one cell c4+c6+c7+c9+c10+c11 and subtract them 1
Creating a formula in VBA with quoted strings 1
cell subtraction problem 1
macro copy and paste criteria 1
How to implement subtraction from a range 1
Subtracting 37 hours from a cell containing format [h]:mm 2
loop through every other and 3rd cell in range 2

Back
Top