Hello guys,
I have been searching for something suitable for my case but i failed to find. So i need help.
I created a document where i will calculate supplier delivery performance score.
I enter 2 dates as due date and delivery date and the difference between dates are shown as day format.
For ex. 11 days difference. I calculated the score simple as =100-(differance*10)
But this formula doesn't work good always. The score exceeds above 100 or below 0. I would like the outcome to be in between 0 and 100.
What would you recommend for scoring formula?
Thank you.
P.S. Sorry i am at work now, system didn't let me upload files to forum. I will upload if needed in the evening.
Bookmarks