ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Calculating percentages (https://www.excelbanter.com/excel-discussion-misc-queries/59649-calculating-percentages.html)

Louise

Calculating percentages
 
Hi all

I have two figures - 315 and 88. How do I calculate what percentage of 315
the 88 is???

Thank you

Louise

Ron Coderre

Calculating percentages
 
Try this:
A1: 88
A2: 315
A3: +A1/A2
Now format cell A3 for percents:
FormatCellNumber
Category: Percentage

Does that help?

***********
Regards,
Ron


"Louise" wrote:

Hi all

I have two figures - 315 and 88. How do I calculate what percentage of 315
the 88 is???

Thank you

Louise


Dave Peterson

Calculating percentages
 
One way:
=(88/315)*100



Louise wrote:

Hi all

I have two figures - 315 and 88. How do I calculate what percentage of 315
the 88 is???

Thank you

Louise


--

Dave Peterson

Louise

Calculating percentages
 
Thanks very much, worked a treat.

Louise

"Ron Coderre" wrote:

Try this:
A1: 88
A2: 315
A3: +A1/A2
Now format cell A3 for percents:
FormatCellNumber
Category: Percentage

Does that help?

***********
Regards,
Ron


"Louise" wrote:

Hi all

I have two figures - 315 and 88. How do I calculate what percentage of 315
the 88 is???

Thank you

Louise


Louise

Calculating percentages
 
Thanks very much - I was doing it the other way round - 315/88*100

Louise

"Dave Peterson" wrote:

One way:
=(88/315)*100



Louise wrote:

Hi all

I have two figures - 315 and 88. How do I calculate what percentage of 315
the 88 is???

Thank you

Louise


--

Dave Peterson



All times are GMT +1. The time now is 08:43 AM.

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