| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculating a scoring system (issue #1)
I used nested IF statements after writing out a number line for your
scores. As long as the ranges don't overlap I wrote this formula to place in P2, giving you the score of H2 =IF(H2=3,2,IF(H22.25,4,IF(H22,6,IF(H21,8,IF(H2 0,1,"-"))))) Plus you may need to change some or < to = or <= http://www.excel-ant.co.uk |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculating and changing cells automatically | Excel Discussion (Misc queries) | |||
| Wrap Text issue | Excel Discussion (Misc queries) | |||
| Excel Tends to access network when I issue commands | Excel Discussion (Misc queries) | |||
| 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) | |||
Threaded Mode
