Help with Excel formula: percent increase to 'x times as much'
May 2, 2023 7:26 AM Subscribe
I need to write an Excel formula that converts percentages to an 'x times as much' figure. It is breaking my brain.
Since it'll be easier to see this way, I placed some example data in this editable Google Sheet.
I need to take the percentage figure (represents percent performance over a baseline figure) in Column A and convert that to 'x times as much' and place that in Column C. Column B contains examples that my colleague calculated in her head and then rounded to the nearest whole number.
Using what's there, can anyone help write a formula that is able to replicate the examples in Column B (assuming her examples are correct...)?
Thanks!
Since it'll be easier to see this way, I placed some example data in this editable Google Sheet.
I need to take the percentage figure (represents percent performance over a baseline figure) in Column A and convert that to 'x times as much' and place that in Column C. Column B contains examples that my colleague calculated in her head and then rounded to the nearest whole number.
Using what's there, can anyone help write a formula that is able to replicate the examples in Column B (assuming her examples are correct...)?
Thanks!
Oh and if you want to round =round(1+A1)
posted by CleverClover at 7:43 AM on May 2, 2023
posted by CleverClover at 7:43 AM on May 2, 2023
I don't think you need any formula, just select the column in excel, format cells, number, decimal and set to 0 decimal places.
posted by Lanark at 7:44 AM on May 2, 2023
posted by Lanark at 7:44 AM on May 2, 2023
Best answer: Ok. Final version!
=round(1+A1)&" times"
This will add the text
And of course you know each row will have its own number row 2 would be =round(1+A2)&" times"
posted by CleverClover at 7:48 AM on May 2, 2023 [1 favorite]
=round(1+A1)&" times"
This will add the text
And of course you know each row will have its own number row 2 would be =round(1+A2)&" times"
posted by CleverClover at 7:48 AM on May 2, 2023 [1 favorite]
Response by poster: Thanks so much, and sorry about the slightly chaotic shared sheet - appreciate the help on this one! Closing the shared editing now.
posted by rachaelfaith at 7:52 AM on May 2, 2023 [1 favorite]
posted by rachaelfaith at 7:52 AM on May 2, 2023 [1 favorite]
« Older Debit card expiration date keeps changing in... | Challenging the Introvert-Extrovert Dichotomy Newer »
This thread is closed to new comments.
I filled in 2 rows for you
posted by CleverClover at 7:41 AM on May 2, 2023