redspanna
Well-known Member
- Joined
- Jul 27, 2005
- Messages
- 1,602
- Office Version
- 365
- Platform
- Windows
I have simple table below that will work out return and place into E1 if a W is placed into C1
how can I change the Formula to also check if a L is placed into C1 and show the result as a minus figure using the figure shown in A1
example....
hope makes sense and thanks in advance
Back | Odds | W/L | Formula | Result |
15.00 | 2.5 | W | =IF(C1,"W",A1*B1 | 37.50 |
how can I change the Formula to also check if a L is placed into C1 and show the result as a minus figure using the figure shown in A1
example....
Back | Odds | W/L | Formula | Result |
15.00 | 2.5 | L | ?? | -15.00 |
hope makes sense and thanks in advance