excel - Excel : Distribute Percentage evenly for a range of numbers

Question

I have a range of numbers from 1, all the way to 1172. I would like to evenly distribute percentage from 1% to 100% for 1 to 1172. Number 1172 must be 100%. Number 1 must be 1%. The percentage does not have to decimal places, whole numbers is fine. 1% to 99% to be distributed from 1 to 1171 number range. Any ideas on how to accomplish this on Excel? Any help would be greatly appreciated.

标签： excelexcel-formulanumbersrangepercentage

Answer 1

让第一个数字为 0.01，最后一个数字为 11.72。如快照所示，以 0.0008455 的增量填充系列。乘以 100 得到百分比。如果需要，使用INT函数获取完整的数字，如 1、2 3 等。