Formula to find out number per 100

**ExcelNub** · 08-11-2010, 05:44 PM

Ok so I am trying to figure out how to figure out how many of something would occur per 100.

So for example -

200 people are in a pool, 150 of them drown.

Does anyone know the formula to use to figure out how many people per 100 drown in the pool?

Help would be greatly appreciated.

**Richard Buttrey** · 08-11-2010, 05:48 PM

Hi

That's some unsafe pool you have there.

Please Login or Register  to view this content.

Rgds

**Maudise** · 08-11-2010, 05:49 PM

Where the spreadsheet is set up as follows;

A B C
People in Pool Number of Drowning Drowning per 100
A2 B2 C2

In C2 put =(B2/A2)*100 and make sure the number is formatted as a number.

Maudise

**meyero90** · 08-11-2010, 05:50 PM

I think there's not much of a formula to be used however the logic behind your problem is 100 corresponds to 1 occurrence, so how many occurrences are in 200 given 150 people drown? =150/200*100.
maybe if you have a spreadsheet with some dummy data in it, I could be of a better help

**ExcelNub** · 08-11-2010, 05:52 PM

Thanks alot, everything works fine now.

**MilyZC** · 05-26-2021, 03:41 PM

Hi guys, need help ! trying to figure out the formula for the following;
For every hundred pounds the handling in is $4.50
If I have 1,995 pounds how to do the formula please ?

I thought it is =sum(1995/100*4.50) ???? not sure

Thank you, Mily

**FDibbins** · 05-27-2021, 12:19 AM

Originally Posted by MilyZC

Hi guys, need help ! trying to figure out the formula for the following;
For every hundred pounds the handling in is $4.50
If I have 1,995 pounds how to do the formula please ?

I thought it is =sum(1995/100*4.50) ???? not sure

Thank you, Mily

Administrative Note:

Welcome to the forum.

We are happy to help, however whilst you feel your request is similar to this thread, experience has shown that things soon get confusing when answers refer to particular cells/ranges/sheets which are unique to your post and not relevant to the original.

Please see Forum Rule #4 about hijacking and start a new thread for your query.

If you are not familiar with how to start a new thread see the FAQ: How to start a new thread