Excel Formula
- Status: Closed
- Prize: $10
- Entries Received: 12
- Winner: num13
Contest Brief
You will write just one formula in excel. File is attached. The first correct answer gets the prize.
*NOTE: Formula should use Stock, Sales, Rate, Priority and Limits. No manual number entry!
- We have one product. And 7 different color versions of it.
- We can paint our products into another colors to adjust our stock rates.
- Every color has different stocks and sell-out figures.
- Rate is: Stock/Monthly Selling
Our target is:
TARGET: If a color has more rate than X (upper limit), paint "some of it" into another color which has less rate then Y (lower limit), according to the priorities.
Priority means: I take from high rate colors and paint low rate colors starting from the lowest priority. When its rate reached Y, I skip to the next.
Write the formula which finds how much we should paint from each color.
Formula should be able to:
1) If there is not enough quantity, you cannot go less then X (even though some colors rates' couldnt reach Y)
2) If rate is between Upper and lower, do not touch that color
3) If rate is N/A do not touch that color.
4) Formula should NOT use any numbers. All parametric. (It should use all the information given)
Recommended Skills
Employer Feedback
“Thank you for great job!”
someka, Turkey.
Public Clarification Board
How to get started with contests
-
Post Your Contest Quick and easy
-
Get Tons of Entries From around the world
-
Award the best entry Download the files - Easy!