ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   What is the formulae to find out a % (https://www.excelbanter.com/excel-worksheet-functions/202580-what-formulae-find-out-%25.html)

AOD

What is the formulae to find out a %
 
Help

Mike H

What is the formulae to find out a %
 
Maybe,

=actual value/maxvalue
format as percentage

or as a practical example

=44/200

=22%

"AOD" wrote:

Help


Gaurav[_3_]

What is the formulae to find out a %
 
Elaborate


"AOD" wrote in message
...
Help




David Biddulph[_2_]

What is the formulae to find out a %
 
Firstly, the place to ask your question is in the body of the message, not
in the subject line.

If you want to know what percentage A1 is of B1, then the formula is =A1/B1
and format the result as percentage.
Otherwise =100*A1/B1 formatted as a number or general will give a number
equal to the percentage.
--
David Biddulph

"AOD" wrote in message
...
Help





All times are GMT +1. The time now is 03:42 AM.

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