ExcelBanter - Improvement Percentage Formula Help

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Improvement Percentage Formula Help (https://www.excelbanter.com/excel-worksheet-functions/58570-improvement-percentage-formula-help.html)

rpalmer4

Improvement Percentage Formula Help

looking to show a % of improvement...example January I was 8 out of 12 and
current YTD I'm 1 out of 12 so would the formula be if A15 = 1 & B15 = 8
1-(A15/B15) = 88% ?

Bob Phillips

Improvement Percentage Formula Help

=1-A15/B15

formatted as percentage

--

HTH

RP
(remove nothere from the email address if mailing direct)

"rpalmer4" wrote in message
...
looking to show a % of improvement...example January I was 8 out of 12 and
current YTD I'm 1 out of 12 so would the formula be if A15 = 1 & B15 = 8
1-(A15/B15) = 88% ?

All times are GMT +1. The time now is 04:50 AM.