Scaling a set of numbers

[ExcelRaceRatings]

Hi there,

I have a set of three numbers:

Cell AJ43 - 32
Cell AJ44 - 22
Cell AJ45 - 18
Total 72

I want to be able to scale these numbers so they add to 100.

Thanking you in advance for your advice!

Cheers

 

[igold]

How about, starting with AJ43 and copied down in whatever cell you want:

=AJ43*100/(SUM($AJ$43:$AJ$45))


igold

 

[ExcelRaceRatings]

Great work igold!

 

[igold]

Glad it worked for you! Thanks for the feedback!