ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   What is the percentage (https://www.excelbanter.com/new-users-excel/251787-what-percentage.html)

Israel

What is the percentage
 
Hi I have a value of (A) 642 and a value of (B) 385.20. The difference is
256.80 what formula would I use to find the percentage of value 256.80

Thank you
--
smile

Joe User[_2_]

What is the percentage
 
"israel" wrote:
I have a value of (A) 642 and a value of (B) 385.20.
The difference is 256.80 what formula would I use
to find the percentage of value 256.80


If you want the percentage increase from 385.20 to 642, then:

=A1/B1 - 1

formatted as Percentage. You can also write =(A1-B1)/B1.

If you want the percentage decrease from 642 to 385.20, then:

=B1/A1 - 1

You can also write =(B1-A1)/A1.

If you want something else, it would help if you gave a numerical example as
you worked it out on paper; that is, "show your work".


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

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com