IF Statement - if cell is empty?

[Barb54]

I have created a spreadsheet for hosting an online tournament. I have an IF statement that basically says "IF(E3="W",B3,D3)".

The code field(E) for the logical check will have either a W for win or L for loss OR nothing which presents a problem, lol. The field needs to remain empty until a winner or looser posts in to the Host. If it's empty, it will still put a nick in the next round spot with my formula as it is right now. So I guess I need another check but not sure how to go about it. I tried OR but it didn't work or my syntax was wrong.

IF E3 is empty, leave the next round player field empty
ELSE if E3="W",D3,B3 is what I want it to do.

I have a sample of the spreadsheet I'm just not sure how to put it on the board, lol. I was going to post it as an attachment but see no way to do that. I downloaded something that was suppose to help but not sure how I'm suppose to use it LOL. OMG, if anyone needs to SEE the file I will post it online if need be as I have my own webspace, sheesh, lol.

Thanks in Advance......................
Barb

 

[Matty]

If I've understood what you're trying to do, a Nested IF formula is what you need.

Something like:

=IF(E3="","",IF(E3="W",B3,D3))

Am I along the right tracks?

Matty

 

[Scott Huish]

I have a sample of the spreadsheet I'm just not sure how to put it on the board, lol.

Have a look at the (currently) 4th item down on the main Excel Questions page.

 

[Barb54]

It worked Matty, THANKS!

Thank you so much Matty, that did it! I can see now that my error was one of syntax after all. I had given up on the OR idea and was trying to do nested IF's but couldn't get it right. It was the parenthesis that got me which is typical for me, lol.

HOTPEPPER..........errr, no clue what you are talking about.....4th item on the list had to do with Pivot Tables, lol.

THANKS!!!!

 

[Scott Huish]

No, the 4th item is:

Sticky: How to display your sheet on the board/HTML Maker FAQ

 

[Barb54]

I dld HTML Maker but couldn't get it to work

I did download HTML Maker but when I tried to put the spreadsheet in the message it didn't work. After I dropped in the AddIn, Excel went nuts on me and my Office Assistent kept locking up. I had to pop in my CD to get it fixed. I haven't tried to use the AddIn since but maybe next time I post I will.

Thanks,
Barb