|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
June 11th, 2005, 11:44 AM
|
|||
|
|||
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
June 11th, 2005, 01:45 PM
|
|||
|
|||
|
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
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Conditional formatting over a picture | Carl Rapson | Setting Up & Running Reports | 0 | December 27th, 2004 04:21 PM |
| HOW DO I EDIT A CONDITIONAL FORMAT? | WillRn | General Discussion | 0 | October 25th, 2004 06:37 PM |
| Equation Editor problems | Graeme Milne | New Users | 2 | June 25th, 2004 01:12 PM |
| Trendline Equation Accuracy | Jerry W. Lewis | Charts and Charting | 0 | March 5th, 2004 11:56 AM |
Linear Mode
