Percent Formula - The Change of X

[BMD]

Less say I have a $1000.00 in cell A1 and in cell A2 is $1200.00 this will be the starting and ending balance. Now I have $110.00 in cell A3 and $90.00 in cell A4. In A5 I would like 0.0% based on the formula =SUM((A2-(A3+A4))/A1) . Think of it like this you start with X and you add Y, you now have X+Y, you remove Y, the change in X was %0.0.

Yes, this is tax related. Yes, I live in NY State. Yes, NY State is the highest taxed state in the union. Yes, I’m overtaxed.
Thanks,
BMD

 

[rallcorn]

Not following why you would want to do it this way, but you'll never get 0% with your formula because you're dividing 1000 by 1000. The amt of change from 1000 TO 1,000 is ZERO so to get % of change you have to divide zero by 1000.

To get zero % you'd have to do this (though, again, don't know why you'd want/need to - I must be missing something)
(A1-(A2-SUM(A3:A4)))/A1

If you want to see the % of increase of going from 1000 to 1200 (200 increase)
=(A2-A1)/A1 would be 20%

 

[BMD]

The formula works but the percent should be 30% not -30%
C5 E5 F5 G5 H5
$1,000.00 $1,500.00 $110.00 $90.00 -30%
=(C5-(E5-sum(F5:G5)))/C5
removing F5:G5 the value increased from 1000.00 to 1300.00.
Any pointers.
Thanks,
BMD

 

[rallcorn]

Explain what each of the cells represents & which cells (if any) have formulas (& what the formulas are).

From your initial post it sounded like you were going from $1,000 beginning number to $1,300 ending number by adding $110 + $90 TO $1,000 beginning number.

From your latest example that doesn't appear to be correct since 1,000 + $110 + $90 doesn't = $1,500.

 

[BMD]

Sorry for the confusion, but I excel in that area.

Think of it like this, you start with $1000.00(C5) you now have $1500.00(E5), but you added $110.00(F5) and $90.00(G5) so the only formula is in (H5) that is =(C5-(E5-sum(F5:G5)))/C5. It returns -30% but the unaccounted $300.00 is a positive 30% not negative.

 

[rallcorn]

=(C5-(E5-sum(F5:G5)))/-C5