Link to home
Create AccountLog in
Avatar of tezza73
tezza73Flag for United Kingdom of Great Britain and Northern Ireland

asked on

Three Conditions of the 'IF' statement in Excel

Hi Experts

Before I ask the question, May I wish you all a Happy & (Hopefully) Prosperous New Year.

The attached spreadsheet is simply a list of results
Column "B" being the score of the Home Side and in Column "C" is the Opponents score:

Column A is the result - ie whether it is a WIIN (W), LOSE (L) or DRAW (D)

I would like to use Multipe "IF's" but I cannot seem to get the syntax correct. Any Help Much Appreciated.
Thanks in advance, Regards

Terence
ex-exc-iftest.xls
SOLUTION
Avatar of SiddharthRout
SiddharthRout
Flag of India image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
SOLUTION
Avatar of Ingeborg Hawighorst (Microsoft MVP / EE MVE)
Ingeborg Hawighorst (Microsoft MVP / EE MVE)
Flag of New Zealand image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
<chit chat>
Hi Sid, what are you doing answering EE questions on New Year's Eve? Get out there with the crowd and have a great party.

1 hour and 10 minutes to go in NZ.

Have  a great time!!

</chit chat>

cheers, teylyn
Teylyn :)

It is just 3:20 pm here :)

Happy new Year to you and your family as well :)

Sid
ASKER CERTIFIED SOLUTION
Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Three minutes to midnight in NZ.

Happy New Year, tezza73, Sid and Barry!

cheers, teylyn
Lolzzz

What are you doing near a pc?

Sid
typing, maybe??

The kids are in bed, and the hubby is down with a gastro bug, so new year parties are not suitable right now.

But in 10 hrs I'll be on the beach with the kids, enjoying a nice warm summer day and a beach carnival festival with lots of goodies and fun things to do. That'll make up for tonite.

cheers, teylyn
Gr8!!!!

Have a nice one!

Sid
Well, we've still got more than 12 hours to go......but wth.....Happy New Year tezza, teylyn and Sid

regards, barry
Barry... Happy New Year to you and your family as well :)

Sid
Hello tezza, you accepted my suggestion and also gave me an assist - did you mean to give that to Sid?
Avatar of tezza73

ASKER

There were 3 people's suggestions which all worked so the fairest was to allot them equally. Hope that clears.

A Happy New Year to All
Tezza
But you missed mine ;)

Sid
Avatar of tezza73

ASKER

Oopps yes Sorry Sid, how do I go about remedying this please. Sorry
That's ok...

No issues ;)

Happy New Year

Sid
teylyn: Hey Thanks :)

So did you finally leave?

Sid
You were supposed to go out with family to some beach... If I remember correctly?

Sid
It was a great day! Stage show hypnotist, Miss Taranaki contest, live music, swimming safely between the flags, ice cream, bouncy castles and other treats, sky divers, helicopter flights, dig-for-the-prize contest for the kids, swimming safely for the kids  .... and relentless sunshine assaulting my skin while supervising the tribe of littlies.

Great start of 2011 (at least for the under-12-yr-olds). Hope it will continue in this spirit!
Kooool! :)

Sid
sheesh, you're fast!

Happy New Year, Sid. I won't even try to compete with you.

cheers, teylyn
lolzzzz

Sid