Calculating Percentage
 

Need help!

I have a value in B2 which represents the # of people who started a rewards
program here at work. B3 is the number of people who are still remaining. I
want to find out the percentage of people who have dropped out. Meaning if 43
(cell B2) started and there are 33 remaining (Cell B3), what percentage of
people have dropped?

Can someone help w/ a formula? Thanks so much!

Ms.Shopalot

Calculating Percentage
 

Ms Shopalot

What about

=1-(B3/B2)

Formatted as a percentage = 23.26% drop-out in your example

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
DTHIS
www.nickhodge.co.uk


"Ms.shopalot" wrote in message
...
Need help!

I have a value in B2 which represents the # of people who started a
rewards
program here at work. B3 is the number of people who are still remaining.
I
want to find out the percentage of people who have dropped out. Meaning if
43
(cell B2) started and there are 33 remaining (Cell B3), what percentage of
people have dropped?

Can someone help w/ a formula? Thanks so much!

Ms.Shopalot

Calculating Percentage
 

Thank you sugar! :)

Ms.Shopalot

"Nick Hodge" wrote:

Ms Shopalot

What about

=1-(B3/B2)

Formatted as a percentage = 23.26% drop-out in your example

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
DTHIS
www.nickhodge.co.uk


"Ms.shopalot" wrote in message
...
Need help!

I have a value in B2 which represents the # of people who started a
rewards
program here at work. B3 is the number of people who are still remaining.
I
want to find out the percentage of people who have dropped out. Meaning if
43
(cell B2) started and there are 33 remaining (Cell B3), what percentage of
people have dropped?

Can someone help w/ a formula? Thanks so much!

Ms.Shopalot