Thread: Simple Math ?
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
Dana DeLouis[_3_] Dana DeLouis[_3_] is offline
external usenet poster
 
Posts: 690
Default 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