Simple Math ?

[Steve B]

Hello,

Okay this should be simple but it's not working so any insight will help.

Want to add (G2 + G3), Subtract from that the total of (F2+F3) and divide
the result by the sum of (G2+G3) (Basically getting the percent change of the
two sums)

I can't get the divide part correct.

Thanks In Advance.. Sorry for what should be simple

 

[Pete_UK]

If you want it all in one formula:

=(G2+G3-F2-F3)/(G2+G3)

You might prefer to see it like this:

=((G2+G3)-(F2+F3)) / (G2+G3)

Hope this helps.

Pete

 

[Gary''s Student]

=((G2+G3)-(F2+F3))/(G2+G3)

So if F2 thru G3 contain:

0.1 1
0.2 2

then the formula displays 0.9 or 90% (formatted as percentage)

 

[Sheeloo]

Try
=((G2+G3) - (F2+F3))/(G2+G3)

 

[Dana DeLouis]

Hi.

((F2 + F3) - (G2 + G3))/(G2 + G3)

or...

(F2 + F3)/(G2 + G3) - 1

HTH
Dana DeLouis

 

[Dana DeLouis]

Oops! That was totally backwards.

((G2 + G3) - (F2 + F3))/(G2 + G3);

or..

(-F2 - F3)/(G2 + G3) + 1

Dana DeLouis

 

[Shane Devenshire]

Hi,

Try this

=1-(F2+F3)/(G2+G3)