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


"jmuncy" <(E-Mail Removed)> wrote in message
news:14487C74-0867-4531-A4C3-(E-Mail Removed)...
>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?