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
Calculate insurance cost with a formula by using the Ins_Percent lookup table on the Reference worksheet to determine the insurance percentage to be applied to the Appraised Value.
Solved by K. E. in 21 mins
i am using a form , =contar.se, for get the numbers higher then 10 and while i am getting that numbers i want to transform that value into a percentage. this is the form that i was trying to use, =CONTAR.SE(Folha1!C2:C11;">=10")*100%
Solved by G. J. in 30 mins
How can I work out the percentage of values in a column which are less than 72?
Solved by S. J. in 17 mins
if the store gets a discount percentage for any invoices greater than 5,000 using the IF function to determine the discount amount with "0" for value_if_false? how do you get the correct amount to enter if its not false?
invoice amount: 5,678.50
discount %: 5%
Solved by C. D. in 13 mins
In cell D5, construct a formula to calculate the % of Total Projected Investments for Pooled Investments by dividing the Projected Investments for Next Fiscal Year for Pooled Investments by the Total Projected Investments for Next Fiscal Year. Use absolute cell references as necessary, format the result in Percent Style, and Center the percentage. Fill the formula down through cell D9.
Solved by S. E. in 29 mins
I need to compute the total cost and the percentage of each item. formatting it as a decimal to 3 places and a percentage into 1 place
Solved by F. C. in 28 mins
Remove the Legend chart element, and then add the Data Labels chart element formatted so that only the Category Name and Percentage display positioned in the Center.
Solved by C. J. in 23 mins
I need help creating a flexible formula that will return to me the matching payment percentage dependent on the dates
Solved by M. L. in 17 mins
I need help with a formula that would get match the biweekly dates in the income projections tab and return to me the percentage of COGS or Revenue payment percentage. I have the dates calculated in the assumptions tab. I am open to changing the format to make a formula work as well.
Solved by T. F. in 14 mins
On the Payment Table worksheet, in the range A2:B4, enter the following row titles and data. Format the Amount of Loan as Currency with 0 decimals. Format the Interest as Percentage with 2 decimals.
Amount of Loan $425,000
Period (months) 120
Interest rate (per year) 5.25%
Solved by M. C. in 13 mins