ExcelBanter - percent formulas

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

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

- - percent formulas (https://www.excelbanter.com/excel-worksheet-functions/27074-re-percent-formulas.html)

Ron Coderre

percent formulas

It seems like you aren't looking for the percent tha Col B is of Col A.
Are you actually looking for the Percent Increase(Decrease)?

If yes, then try this formula in C1 then copy it down: =(B1-A1)/A1
--
Regards,
Ron

All times are GMT +1. The time now is 01:42 PM.