Jun 01 2021 10:43 AM
I need help in creating a formula. I thought I was good at this stuff but I guess not, because I can't figure it out.
I was given a report in PDF format, to create. I do not have access to the original Excel, to copy it.
Here is what I need help with:
Month Forecast - 10
MTD Delivered Units = 7.
Selling Days - 26
Selling Days Completed - 22
I need the tracking %, how much I need to go to hit forecast. In the example I sent, the tracking percentage came to 83%. I know I should be pacing 8 units at this time, not 7, so what percentage of my goal have I hit in 22 days?
Jun 01 2021 11:40 AM
Here is a small example ... as far as I can understand what exactly you are trying to accomplish.
Attached is the file where you can see and use the simple formulas.
Hope to have helped you.
Nikolino
I know that I don't know (Socrates)
Jun 03 2021 10:20 AM
The calculations are fine, individually, thank you. I just can't seem to put it in to one string.
Jun 03 2021 01:06 PM
Jun 04 2021 01:25 AM
Attached two files that might help you in your project.
Many different templates that you can download for free from Microsoft and further develop if it suits you.
Thank you for your patience and time.
Wish you a nice day / night with lots of health, joy and love.
Nikolino
I know I don't know anything (Socrates)
*If you find this helpful, please mark it as "Best Answer" or give a “Like”, it will be beneficial to more Community members reading here.