ExcelBanter - DIFFERENCES IN PERCENTAGES

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

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

- - DIFFERENCES IN PERCENTAGES (https://www.excelbanter.com/excel-worksheet-functions/153151-differences-percentages.html)

William Gregg

DIFFERENCES IN PERCENTAGES

I want to know the reduction in percentage terms from 12.000 minute to 3.48
minutes.

3.48 is in Cell B1 and 12.000 is in C1. What is the Formula I should use to
to show the decrease in Percentage terms from 12.000 to 3.480. The formula I
have used is =(C5-B5)/ABS(B5) and the Cell Formatted as a %.

Thank you.
--

W G HENRY

Toppers

DIFFERENCES IN PERCENTAGES

=(C1-B1)/C1

assuming 12.0 is start value and 3.48 is end value

"William Gregg" wrote:

I want to know the reduction in percentage terms from 12.000 minute to 3.48
minutes.

3.48 is in Cell B1 and 12.000 is in C1. What is the Formula I should use to
to show the decrease in Percentage terms from 12.000 to 3.480. The formula I
have used is =(C5-B5)/ABS(B5) and the Cell Formatted as a %.

Thank you.
--

W G HENRY

All times are GMT +1. The time now is 01:34 AM.