Excel Excel IF statement with 3 outcomes

A

Alex777

Joined
May 5, 2016
Messages
1
Reaction score
0
Hello,

I'm trying to make a football (soccer) table using the if statement to display whether a side has won, drawn or lost.

This is the current IF statement I'm using,

=IF(R3>S3,"W","L")

As you can see I can only make the statement display W and L

I know that if I put R3=S3,"D", that will show D but I do not know how to make an if statement show 3 results.

If someone could assist that will be great thanks.
 
Becky

Becky

Webmistress
Joined
Mar 25, 2003
Messages
7,424
Reaction score
1,511
Hi Alex, and welcome to PC Review :)

You need another IF function inside your IF function. This should work:

=IF(R3>S3,"W",IF(R3<S3,"L","D"))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Multiple condition if statement 5
Excel VBA code which copy data from a web page in excel 3
If statement with dates 0
Excel MS Excel "IF" Logic Help Needed 1
How to add (sum) a row cells with letter 12
combining two cell values to one value to chart 4
World Cup 2010 Spreadsheet 1
IF formula with 3 possible outcomes 8

Top