Hey All need help creating a formula that will limit how much a person can drop their average per season but not limit how much they can increase their average per season.
Examples:
Starting Average: 176
Current Average: 156
Limit Drop On Average: 5
Actual Average: 171
Starting Average: 150
Current Average: 165
Limit Drop On Average: 5
Actual Average: 165
Much appreciated
Last edited by Killer17; 01-27-2014 at 10:46 PM.
Please explain the method
Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.
Click on GO ADVANCED and use the paperclip icon to open the upload window.
View Pic
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
Hey Sixthsense
Here's a example as requested
thanks
Cap Average.xlsx
=if(c3-d3>5,c3-5,d3)
thanks Ckim551 for your helpOriginally Posted by ckim551
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks