Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculating a scoring system (issue #2)
#2. This one's a bit trickier. Is this even possible?! OK, my points are as follows: sales Penetration Forecast Loss Points (column H) (col I) (col R) 50% <2% =8 50% <3% =6 50% 3 but less than 4% =2 50% 4% = - 2 40% <3% = 6 40% 3% but less than 4% =0 40% 4% = - 3 30% <3% =3 30% 3% but less than 4% = - 3 30 4% = -5 20% < 2% = 0 20% 2% = - 5 < 20% < 2% =0 < 20% 2% = - 7 These are the parameters for the score in column R. Am I able to put them all in so that they calculate the points? My head hurts. Please help! -- jenparker1234 ------------------------------------------------------------------------ jenparker1234's Profile: http://www.excelforum.com/member.php...o&userid=36266 View this thread: http://www.excelforum.com/showthread...hreadid=568620 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculating a scoring system (issue #1) | Excel Worksheet Functions | |||
Calculating and changing cells automatically | Excel Discussion (Misc queries) | |||
Excel 2003: Not enough system resources to display completely | Setting up and Configuration of Excel | |||
calculating excel spreadsheet files for pensions and life insurance (including age calculation sheets) | Excel Worksheet Functions | |||
AGE CALCULATING EXCEL SPREADSHEETS AND OTHERS! | Excel Discussion (Misc queries) |