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.
 
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"))
 
Back
Top