Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel - calculating a percentage | Excel Discussion (Misc queries) | |||
Calculating a percentage with the end percentage in mind | Excel Discussion (Misc queries) | |||
Calculating forecast accuracy as a percentage | Excel Discussion (Misc queries) | |||
Calculating Percentage Rent | Excel Worksheet Functions | |||
Calculating Percentage | Excel Worksheet Functions |