Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Not a Math Doctor
 
Posts: n/a
Default 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   Report Post  
Dave Peterson
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Conditional Formatting Error ddate Excel Worksheet Functions 0 May 5th 05 09:00 PM
How do i create a conditional sum? tmiller708 Excel Worksheet Functions 2 May 5th 05 01:58 AM
Logarithmic Trendline Equation Phil Hageman Charts and Charting in Excel 2 January 13th 05 12:55 PM
Determine cells that drive conditional formatting? Nicolle K. Excel Discussion (Misc queries) 2 January 7th 05 02:08 AM
Conditional formatting not available in Excel BAB Excel Discussion (Misc queries) 2 January 1st 05 04:33 PM


All times are GMT +1. The time now is 04:50 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"