| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If Statement On Two Conditions
Okay, I need to calculate a total based off of two conditions. I am assuming
their is a way to do it via table, which I am unfamilar with. Is there an easy way to do this example below? Maybe breaking it up into two calculations? Essentially, if an individual has E5=Platinum and F5=Copper, then they would achieve a score of 175. The Table below would be in L1:P5 of the same sheet. Platinum Gold Silver Copper Platinum 350 300 225 175 Gold 300 225 175 150 Silver 225 175 150 100 Copper 175 150 100 75 Thank you |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Nested if statement with over 7 conditions - VBA? | Excel Discussion (Misc queries) | |||
| Conditions with IF statement | Excel Discussion (Misc queries) | |||
| IF Statement with multiple conditions | Excel Discussion (Misc queries) | |||
| If statement using multiple conditions | Excel Worksheet Functions | |||
| Nesting If Statement with "AND", "OR" conditions | Excel Worksheet Functions | |||
Threaded Mode
