Share via

INCREASING VALUES IN A TABLE

Anonymous
2016-08-10T22:21:15+00:00

I have a table with multiple numeric values.  If I want to increase all the values by a percentage, is there one formula that will do that with out doing each cell

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2016-08-11T17:48:24+00:00

    I want to change all at the same time.   Let's say I want to change all values  and decrease those values by 20%

    Miles 1-2 Feet 3-4 Feet 5-8 Ft. 9-10 Ft. 11-12 ft. 13-16 ft. 17-18 ft. 19-20 ft. 21-24 ft. 25-28 ft. 29-32 ft. 33-36 ft.
    1-100 413.578 413.578 631.598 631.895 737.451 804.474 871.519 986.194 1108.25 1204.918 1467.8037 1532.553
    101-200 412.687 551.221 647.856 742.368 869.792 949.432 1023.495 1111.913 1216.292 1337.743 1529.396 1685.31
    201-300 450.89 586.201 751.674 853.413 949.927 1057.76 1171.126 1243.363 1335.07 1447.226 1647.624 1813.108
    301-400 477.488 617.375 786.291 944.801 1043.306 1139.05 1244.485 1336.335 1456.565 1616.67 1794.254 2073.313
    401-500 502.293 649.297 830.368 1007.248 1105.742 1222.287 1308.318 1446.698 1570.613 1728.606 2004.717 2286.57
    501-600 536.668 689.535 939.29 1087.702 1173.733 1320.473 1463.704 1593.075 1747.35 2022.108 2273.37 2608.001
    601-700 567.556 699.248 985.193 1139.05 1227.831 1502.545 1638.494 1764.664 2028.653 2276.032 2573.912 2850.606
    701-800 596.651 733.931 1162.645 1245.882 1377.673 1649.593 1778.645 2041.138 2298.252 2582.019 2876.797 3229.831
    801-900 622.908 771.386 1344.376 1349.92 1498.376 1795.288 2038.531 2311.804 2606.087 2894.683 3178.659 3624.654
    901-1000 670.219 826.881 1517.813 1531.684 1767.766 2023.12 2316.974 2597.573 2871.638 3250.929 3635.434 3873.331

    Was this answer helpful?

    0 comments
  2. Anonymous
    2016-08-11T02:42:34+00:00

    Hello,

    Please provide us more information:

    1. Are you using a pivot table?
    2. Do you want to increase the values in the table separately or at the same time?

    You may refer to the following article and check if it helps in resolving your query:

    https://support.office.com/en-us/article/Calculate-percentages-6B5506E9-125A-4ABA-A638-D6B40E603981?ui=en-US&rs=en-US&ad=US&fromAR=1

    Please post to us if you need any further assistance and we will assist you.

    Thank you.

    Was this answer helpful?

    0 comments