Decrease numbers in data range to equal specific number

I have a data range in a row which sum = 229.  I need to decrease the number to sum = 184.  The data range of numbers is different in each I have 23, 45, 33, 44..ect. ..How would I be able to decrease each cell by percentage so that the end result would produce 184
Who is Participating?
barry houdiniCommented:
You can multiply every number by 184/229

If the sum is variable make that


You could calculate that number in any cell, copy that cell, then choose data range and then right-click, choose "Paste Special" option and use "Multiply" option > OK > ESC

regards, barry
regards, barry
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.