VehiclesFashionRecipesBlogsHuntTravelsSportFunHandmadeITEducation
Mini-Games
x

x
zakruti.com » IT - Software » IT, programs, coding
How to Calculate Percentages in Excel with Formulas - Envato

How to Calculate Percentages in Excel with Formulas - Envato

FBTwitterReddit

video description

Rating: 4.0; Vote: 1
How to Calculate Percentages in Excel with Formulas JayT_iNi: I cant find what I need please help. I have a commission structure based off percentage of sales, 1% at 5, 000, 2% at 7, 500 and 3% at 15, 000, I need a cell to work this out based on the total cell. Can anyone help?
Date: 2022-09-19

Comments and reviews: 6


What a superb representation. Thank you so much. I was so worried that how to arrange my data. It helped me alot. Once agin i appreciate you. Love from Pakistan.
reply

Please review the Formula for the % change need to be corrected. =(y2 - y1) / y1= your percentage change
(where y1=first value and y2=second value)

reply

I have a problem!
when I calculate the number of percentage I had repeat the percentage value in one cell how can resolve this problem?

reply

What if I want to work out the value of difference. Eg. I made 5000 this month, and spent 1800. What is the formula to get the answer of 36%
reply

Wait what? How do you go more than -100%
Then most you can go is -100% unless you take it to the negative numbers

reply

Thank you for sharing this! It helped SO much and you got straight to the point unlike some videos. :)
reply
Add a review, comment






Other channel videos