IF formual based on two criteria with a minus figure

redspanna

Well-known Member
Joined
Jul 27, 2005
Messages
1,462
Office Version
2016
Platform
Windows
I have simple table below that will work out return and place into E1 if a W is placed into C1

BackOddsW/LFormulaResult
15.002.5W=IF(C1,"W",A1*B137.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....

BackOddsW/LFormulaResult
15.002.5L??-15.00

hope makes sense and thanks in advance
 

Some videos you may like

Excel Facts

What is the last column in Excel?
Excel columns run from A to Z, AA to AZ, AAA to XFD. The last column is XFD.

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
40,849
Office Version
365
Platform
Windows
Maybe
=A2*(IF(C2="W",B2,IF(C2="L",-1,0)))
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
40,849
Office Version
365
Platform
Windows
You're welcome & thanks for the feedback
 

Watch MrExcel Video

Forum statistics

Threads
1,099,369
Messages
5,468,223
Members
406,574
Latest member
HeinrichPaul

This Week's Hot Topics

Top