ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Formulas for percentage (https://www.excelbanter.com/excel-discussion-misc-queries/107177-formulas-percentage.html)

beehappy4ever

Formulas for percentage
 
I am trying to set up a formula that will tell me what percentage of a number
and second number is.

Example

Cell H1 Cell H2
$45.00 $364.17

I need the formula to tell me $45 dollars is ___% of $364.17

Thanks


Carim

Formulas for percentage
 
Hi,

Wherever you need the result, just type in
=H1/H2
then in the main menu Format Cells Percentage ...

HTH
Carim



All times are GMT +1. The time now is 04:49 PM.

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