| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If statements
This should be simple but I'm on a deadline. Need to write a formula that
will provide a weighted total. I think it's an IF statement something like: IF a1=5 then * 2 (I have a table with the weights so the number 2 would be a cell reference. Just not sure of all the commas, semi-colons and parens! Help. Thanks! 5 = 5 points 4 = 3 points 3 = 2 points 2 = 1 point 1 = 1 points |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| 2 IF Statements not mutually exclusive | Excel Discussion (Misc queries) | |||
| if statements, and statements | Excel Worksheet Functions | |||
| UDFunctions and nested If-the-else statements | Excel Worksheet Functions | |||
| Linking two IF statements together | Excel Discussion (Misc queries) | |||
| Nested IF statements | Excel Worksheet Functions | |||
Threaded Mode
