Formula help

[Flub]

Hi All
I have a spreadsheet for a knockout tournament with four columns to a
round e.g. A to D rnd 1, F to I rnd 2, and so on.With A and C being team
names B and D being the scores. Using the following I can get the
winning team name to advance to the next round.If no score is entered into
B1 or D1 I would like cell F1 to remain blank, how would I amend this
formula. IF(b1>d1,a1,c1)
Thanks for any help
Regards

Glenn

 

[Norman Harker]

Hi Flub!

One way:

=IF(COUNTA(B1,D1)<2,"",IF(B1>D1,A1,C1))

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

 

[Flub]

=IF(COUNTA(B1,D1)<2,"",IF(B1>D1,A1,C1))

Many thanks Norman it worked a treat.

Regards
Glenn

 

[Norman Harker]

Hi Flub!

Always pleased to help and thanks confirms to Google Searchers that a
solution works.

Try to be more specific in your subject headings. It helps.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.