If Statement return “W” or “L” result

**Killer17** · 10-14-2008, 06:04 PM

Hello can someone help me on creating a formula that will give me a result of either "W" or "L" depending on the amount in corresponding cell.

Example has been attached

Thanks

**Paul** · 10-14-2008, 06:11 PM

Hi Killer,

I'm assuming you're trying to compare cells D5 to D8, E5 to E8, etc., and the highest number gets the "W"?

If so, in D6 use:

=IF(D5>D8,"W","L")

Then in D9 use:
=IF(D6="W","L","W")

In D9 you could use =IF(D8>D5,"W","L"), but you don't necessarily need to since you've already determined the W or L value in D6. Whatever is in D6, you want the opposite in D9.

If this isn't the case let us know.

**homerj** · 10-14-2008, 06:12 PM

What's the condition for when it needs to return W or L?

Your basic formula should be =if(condition,if true,if false), for an example lets assume you are looking at a numerical value in Cell A1, and if it is equal to or less than 10 you want it to return W, but if it's greater than 10 you want it to return L.

=if(A1<=10,"W","L")

Simply change your cell reference and condition to match your needs.

**Killer17** · 10-14-2008, 07:06 PM

Hey Paul

Thanks for the help this formula works

=IF(D8>D5,"W","L")

But it’s added L if cell is empty is there a way of not showing anything until there's an actual number in the 2 cells?

**shg** · 10-14-2008, 07:19 PM

=if(or(d8 = "", d5 = ""), "", if(d8 > d5, "w", "l") )

**snasui** · 10-14-2008, 07:25 PM

Try this,

=If(And(D5<>"",D8<>""),If(D5>D8,"W","L"),"")

**Killer17** · 10-14-2008, 07:30 PM

Hey snasui

It's not working I think it might becasue I have this formula in Cell D5

=IF(OR(D12=0,D13=0),0,D12+D13)

**snasui** · 10-14-2008, 07:53 PM

Replace... And(D5<>""... with ... And(D5<>0...

Succeed?

**Killer17** · 10-14-2008, 08:01 PM

Thanks snasui it did the job

**NBVC** · 10-14-2008, 10:23 PM

Originally Posted by Killer17

Thanks snasui it did the job

I would have hoped you learned by now... almost every post I answered of yours, as well as from several other members have answered you in the same way: I.e. change the "" to a 0. This is because you have formulas in the reference cells that do not really return blanks... If you go to Tools|Options and select "Zero Values" from the View tab, you will see that you have 0's in those cells not blanks.