Dear all, pls i need help on how to calculate the percentage change on the below
[*] The figures are showing pallets need in a warehouse, the whole warehouse pallet space needed = 3744[*] But they have 6843.1 pallets, meaning the warehouse is over full.[*] The difference between the two figures is 6843.1 - 3744 = 3099.1[*] Now want to calculate the percentage change on both figuers and adding both percentage should be = 100
percentage change.JPG
Percentage Change.xlsx
Last edited by Gabriel Padi; 11-25-2019 at 08:59 AM.
Welcome to the forum!
Please explain your logic (not the mathematical calculation) - why should the two values come to 100 percent?
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
need the total percentage to be 100% to ensure balance and also need to work within percentage of 100
Last edited by Gabriel Padi; 11-23-2019 at 08:02 AM.
Attachment 651072
pls the calculation should be in the empty cells
I know what you need, but you haven't explained the logic of the calculation.
Sorry - I can't helped based on the information given as it is too scant.
Well... I will wade in with a blind guess. Take a look. If this is incorrect (it probably is!!), please post a sample with a few rows and include some MANUALLY CALCULATED expected results.
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
Thanks Glenn,
That was nice and ok
Pls have used same formula but look at the image attached and see second row with different figures the number of pallets has increase hence the percentage change should also go up but rather going down.
Wish i can get some good explanation on that cos its confusing me.
Attachment 651113
Why do you expect it to be different???
I am struggling to understand what you are doing. A warehouse that is more tan 100% full just does not work as an analogy.
What EXACTLY are you trying to do?
Oh. And please post Excel sheets, not pictures of them.
Attachment 651119
Pls am thinking that since the warehouse is full then the percentage change should go up just like the first row you did resulting to 83.3% increase but the second row is resulting to 45.3% decrease
Please define EXACTLY what you mean by "percentage change".
Percentage change is a change in percentage either increase or decrease
but really appreciate your good work.
Thanks so much Glenn.
You have marked the thread as solved. is it??
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks