| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
A conditional equation with three possible outcomes?
Any assistance is appreciated:
Column A will list results that a team has - only possible results are "win", "tie", or "loss". You get three points for a win, one point for a tie and zero for a loss. So if A1 is a win, B1 will display "3" How would I write that equation. The below is not working ... =IF(A1="Win","3"),IF(A1="Tie","1"),IF(A1="Loss","0 ") |
|
#2
|
|||
|
|||
|
See one response in .misc.
It's not necessary to multipost to multiple groups. But if you think it's necessary, then post to all groups in one message. Not a Math Doctor wrote: Any assistance is appreciated: Column A will list results that a team has - only possible results are "win", "tie", or "loss". You get three points for a win, one point for a tie and zero for a loss. So if A1 is a win, B1 will display "3" How would I write that equation. The below is not working ... =IF(A1="Win","3"),IF(A1="Tie","1"),IF(A1="Loss","0 ") -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional Formatting Error | Excel Worksheet Functions | |||
| How do i create a conditional sum? | Excel Worksheet Functions | |||
| Logarithmic Trendline Equation | Charts and Charting in Excel | |||
| Determine cells that drive conditional formatting? | Excel Discussion (Misc queries) | |||
| Conditional formatting not available in Excel | Excel Discussion (Misc queries) | |||
Hybrid Mode
