What is the formulae to find out a %

M

Mike H

Maybe,

=actual value/maxvalue
format as percentage

or as a practical example

=44/200

=22%
 
D

David Biddulph

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Find and Change with highlight in main text, footnote, endnote 1
find out specific month and year 1
Finding asymptote equation and how to draw them in excel 0
formula for arriving net difference 0
Using FIND to highlight text (with dashes) 4
Copy addition formula of non-consecutive horizontal cells 2
finding repeating numerical pattern using array functions? 0
Problem with formula for finding last greater than/less than or equal to value 2

Top