michael coughlin
New Member
- Joined
- Dec 11, 2014
- Messages
- 20
I want to convert the letter "W" to "5" and the letter "L" to "-5" in a column
Excel 2010 | |||||||||
---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | |||
1 | MIKE | NORTH | EAST | WEST | SHOOT MOON | W/L | WON/LOST | ||
2 | 28 | 27 | 78 | 102 | -5 | ||||
3 | 44 | 57 | 112 | 104 | 5 | ||||
4 | 78 | 52 | 37 | 84 | -5 | ||||
5 | 46 | 110 | 73 | 83 | 10 | 5 | |||
6 | 60 | 66 | 109 | 77 | 15 | 5 | |||
7 | 71 | 63 | 104 | 22 | -5 | ||||
Sheet25 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
F2 | =IF(MIN(A2:D2)=A2,5,-5) |
Where is the $5 or -$5 located at... in the "Shoot Moon" column? If so, what about the other numbers in that column other than $5 and -$5... what should be done with them?you're making this too difficult. I want to put a W in column F to equal $5.00 or an L to equal -$5.00
I want to convert the letter "W" to "5" and the letter "L" to "-5" in a column
columns a to d are the score for each player. each point equals $1. the person with the lowest score wins. if you shoot the moon you win $5 from each player. if you win the game you win $5 from each player. column g shows my won/loss dollars for each hand. I just need a formula for column f for $ amount won as well as wins and losses
last sentence should read. Need a formuls for column F for $ amount won or lost as well as wins and losses,
So now you want two values in one cell? Instead of trying to describe what you want in words, why don't you simply manually fill out Column F on sample worksheet you posted with the value(s) you want in those cells so that we know exactly what you are after without having to guess at what you are trying to describe?last sentence should read. Need a formuls for column F for $ amount won or lost as well as wins and losses,
[COLOR=#0000ff]=SUMPRODUCT((B4:D4-A4>0)*5-(B4:D4-A4<0)*5)[/COLOR]