Formula - Average

[aryea]

Hi guys,

I have a problem on formulating an equation on the following data.

JAN 15000
FEB 17987
MAR 19908
APR 35812

AVERAGE 22176.75

Now I want to increase the AVERAGE to 25000, and changes from JAN to APR has to be made according to the ratios before.

(i.e. JAN 16.9%, FEB 20.3%, MAR 22.4%, APR 40.4%)

How could I possibly do that? Thanks in advance!

 

[asking]

Divide 2500 by 22176.75
Copy that answer and then select the 4 cells with values that are averaged and then paste special, values, multiply.

cheers

 

[aryea]

awesome. thanks!

 

[asking]

I made a typo

Should have been
Divide 25000 by 22176.75 not Divide 2500 by 22176.75