| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
help with IF statement
I need a cell to calculate points based on position finished example if
racer finished 1st then he gets 50 points. another racer finishes 2nd he gets 49 point and so on. Here what Ive tried but it only lets me enter up to 7 th place. I need it to go to 50th place at least. =IF(C5<1,"",IF(C5<2,"50",IF(C5<3,"49",IF(C5<4,"47" ,IF(C5<5,"46",IF(C5<6,"45",IF(C5<7,"44",IF(C5<8,"4 3")))))))) Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| IF statement inside a SUMIF statement.... or alternative method | Excel Worksheet Functions | |||
| Reconcile Bank statement & Credit card statement & accounting data | Excel Worksheet Functions | |||
| Embedding an OR statement in an IF statement efficiently | Excel Discussion (Misc queries) | |||
| SUMIF statement with AND statement | Excel Discussion (Misc queries) | |||
| appending and IF statement to an existing IF statement | Excel Worksheet Functions | |||
Threaded Mode
