How to do multiple if and or statments

1. How to do multiple if and or statments

Ok here's the story.

I'm making a spreadsheet for the Red Sox season record. I have multiple information being decided just from the scores, as in; the record for Vs East, Vs West, etc.

I have all of those being counted correctly. However I want to go one step farther with determining the winner of the game.

Right now in Colum F I have two differently formulas. If Boston is home then I have the following formula:

=IF(AND(D2="", E2=""),"",IF(D2<E2,"Win", "Loss"))

If there away I have the following formula:

=IF(AND(D5="", E5=""),"",IF(D5>E5,"Win", "Loss"))

While that works for me, I have to manually put that formula in there deciding upon if their home or away.

What I want to be able it to do is:

If D2 and E2 are blank then nothing else. If B2 equals home than (the home formula) or if B2 equals away than (the away formula).

The reason I want this is I want to be able to give this to my friends who only need to input the data, not the formulas.

2. Re: How to do multiple if and or statments

Try this:

=IF(AND(D2="",E2=""),"",IF(B2="Home",IF(D2<E2,"Win","Loss"),IF(D2<E2,"Loss","Win")))

3. Re: How to do multiple if and or statments

Thanks so much. The funny thing is i had that formula, but i had another if and statment in there for if B2=Away. thanks again.

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1