Get instant live Excel expert help to learn how to calculate percentage in Excel
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”
Here are some problems that our users have asked and received explanations on
A supermarket XYZ is determined to please its customers with a customer advantage card. Currently 30% of all shoppers are loyal to XYZ. A loyal customer shops at XYZ 80% of the time. An unloyal customer shops at XYZ 10% of the time. A typical customer spends $150 each week and the profit margin at XYZ is 7.5%.
The expected increase of loyal customers is 8% and the percentage of time a loyal customer shops at XYZ is expected to increase by 9%. What is the maximum cost of the advantage card per dollar in order for the program to be profitable?
Solved by B. C. in 20 mins
I have to calculate in Cell B5 the 2019 sales goals amount based on a 2018 amount on a different worksheet snd the percentage from another cell
Solved by I. Y. in 24 mins
i have created a formula and wish to get a different soulution.
in AP 5-8 i have the percentage of points for and points aggainst and with to display them as a complete percentage.
Solved by T. B. in 15 mins
I have a cell whereby i need to show a percentage (81.69%), however I only want it to show 81% and not the two decimal places after. This cell is then used to populate another cell with costs that equates to 81.69% of the total cost. However, I only want to show the percentage cell as 81% and not 81.69%. When using the rounding function this makes it 82%, which I don't want. Please help??
Solved by B. Y. in 13 mins
need help converting a number to percentage with a 1 in the front, for example 1.0876 in percent should be 8.7 percent, my excel shows 109%
Solved by F. C. in 19 mins
Hi,
I need to multiply the value (currency amount) in one cell by another cell (again a currency amount) and then by a third cell (a number is in the cell - but it needs to be a percentage)?
e.g. £45 x £33 x 10 (percent)
Many thanks!!!!
Solved by K. Y. in 23 mins
I would like a column chart based on the data in the attachement. RevPAR and ADR should be measured in dollars. Occupancy should be based as a percentage. For each year there should be three different columns
Solved by A. Y. in 16 mins
I would like a column chart or whatever you think would be best based on the data in the excel spreadsheet. There are three different measurements for December 2015, 2016,2017. Occupancy should be labeled as a percentage while ADR and RevPAR are both in dollars. Dark blue, light blue, and gray for the colors
Solved by D. B. in 12 mins
I HAD 48 RESIDENTS GIVE 2.00, 4.00 AND 6.00 TO THE LOTTERY POOL. THE PAYOUT WAS 18.00 TOTAL/ HOW DO I CALCULATE IN EXCEL THE PERCENTAGE OF THE 18.00 THAT ALL 48 PEOPLE GET
Solved by K. S. in 24 mins
I need help on my assignment about how to find percentage in excel. I do not know anything about excel.
Solved by D. J. in 13 mins