I have 3 cells

Let's say A1, A2, and A3

where I will enter numbers that will add up to a number between 0 and
500. Whatever that number is I need to subtract it from 500 and take
that and add it to another cell that is currently valued at 1500.

Let's say that cell is C1.

Then in another cell:

=C1+500-A1-A2-A3

or

=C1+500-SUM(A1,A2,A3)

HTH,
Bernie
MS Excel MVP


"patd7260" wrote in message
...

I think that I want to use Sum If, but here is my goal. I have 3 cells
where I will enter numbers that will add up to a number between 0 and
500. Whatever that number is I need to subtract it from 500 and take
that and add it to another cell that is currently valued at 1500.

Example. I enter 0's in the first 3 cells, I need the final cell to
show 2000.

Please help!!
Thanks,
pat


--
patd7260
------------------------------------------------------------------------
patd7260's Profile: http://www.excelforum.com/member.php...o&userid=22625
View this thread: http://www.excelforum.com/showthread...hreadid=385230