Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.

How to add a percentage increase to single cells in Excel?

I have an excel table with number values in each cell. When I type in another number i want that cell to automatically add 46% to the number i typed in. How could i do this?

3 Answers

Relevance
  • Amy
    Lv 7
    9 months ago

    You can't get it to change the number you've typed in. Just create another column that multiplies the original column by 1.46

  • 9 months ago

    You may be able to do it with a Macro.

    I have used Excel for 25 years but I have never used Macros.

    I can build Macros in Access but not Excel.

    https://www.youtube.com/watch?v=33Ej8DPsdvA

  • 9 months ago

    What ever you're multiplying times 1.46

Still have questions? Get your answers by asking now.