Simple Math ?
 

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

Simple Math ?
 

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

On Jan 7, 4:55*pm, Steve B wrote:
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

Simple Math ?
 

=((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)
--
Gary''s Student - gsnu200824


"Steve B" wrote:

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

Simple Math ?
 

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

"Steve B" wrote:

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

Simple Math ?
 

Hi.

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

or...

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

HTH
Dana DeLouis



Steve B wrote:
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

Simple Math ?
 

Oops! That was totally backwards.

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

or..

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

Dana DeLouis


Dana DeLouis wrote:
Hi.

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

or...

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

HTH
Dana DeLouis



Steve B wrote:
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

Simple Math ?
 

Hi,

Try this

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

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire

"Steve B" wrote in message
...
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