Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Conditional w/ three possibilities
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 ") -- MathDoctor ------------------------------------------------------------------------ MathDoctor's Profile: http://www.excelforum.com/member.php...o&userid=24216 View this thread: http://www.excelforum.com/showthread...hreadid=378284 |
#2
|
|||
|
|||
=IF(A1="Win",3,IF(A1="Tie",1,0)) presumably in cell b1 -- duane ------------------------------------------------------------------------ duane's Profile: http://www.excelforum.com/member.php...o&userid=11624 View this thread: http://www.excelforum.com/showthread...hreadid=378284 |
#3
|
|||
|
|||
One way:
=IF(A1="Win","3",IF(A1="Tie","1","0")) or if you want to do arithmetic with the results of that formula: =IF(A1="Win",3,IF(A1="Tie",1,0)) MathDoctor 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 ") -- MathDoctor ------------------------------------------------------------------------ MathDoctor's Profile: http://www.excelforum.com/member.php...o&userid=24216 View this thread: http://www.excelforum.com/showthread...hreadid=378284 -- Dave Peterson |
#4
|
|||
|
|||
Try:
=(A1="Win")*3+(A1="Tie")*1 Notice that no "IF"s are neded. Also notice that "Loss" is automatically covered since it yields zero anyway -- Gary's Student "MathDoctor" 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 ") -- MathDoctor ------------------------------------------------------------------------ MathDoctor's Profile: http://www.excelforum.com/member.php...o&userid=24216 View this thread: http://www.excelforum.com/showthread...hreadid=378284 |
#5
|
|||
|
|||
You were almost there.........just move a couple of parenthisis and add for
condition that B1 should be blank if cell A1 is blank (or accidently contains anything else)........ =IF(A1="Win","3",IF(A1="Tie","1",IF(A1="Loss","0", ""))) Incidently, the double quotes you have around the numbers actually turn their result into TEXT format, if you want actual numbers use same formula but just delete those double quotes, like........... =IF(A1="Win",3,IF(A1="Tie",1,IF(A1="Loss",0,""))) Vaya con Dios, Chuck, CABGx3 "MathDoctor" wrote in message ... 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 ") -- MathDoctor ------------------------------------------------------------------------ MathDoctor's Profile: http://www.excelforum.com/member.php...o&userid=24216 View this thread: http://www.excelforum.com/showthread...hreadid=378284 |
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 | |||
Effect of Conditional Formatting, Data Validation | Excel Discussion (Misc queries) | |||
Conditional formatting not available in Excel | Excel Discussion (Misc queries) | |||
copy conditional format as ACTUAL format | Excel Discussion (Misc queries) |