Simple Function question?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

This is a simple mistake but for some reason I can not get around it...any
help would be great.

What I am trying to accomplish is to have one cell (in this case T11)
display the winner of a game from cells R10 and R12. I am using "IF" >, <
and = to display the winner or a tie. The problem I am running into is if
they two cells have not played yet, it will show in cell T11 the first cell
(R10) as the winner. Is there a formula to add to this so it will not show a
winner in T11 until a number is in place? Here is my formula:
=(IF(S10>S12,R10,R12)+IF(S10=S12,0))
 
Don't, know where S10 and S12 come into it

=IF(OR(R10="",R12=""),"",IF(R10>R12,R10,IF(R10<R12,R12,"tie")))

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
Got it.....thanks for your help!

Bob Phillips said:
Don't, know where S10 and S12 come into it

=IF(OR(R10="",R12=""),"",IF(R10>R12,R10,IF(R10<R12,R12,"tie")))

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
Click to expand...
 
Hi

When R10:R11 contain player names, and S10:S11 their scores, then
=CHOOSE(IF(OR(S10="";S11="");1;(S10>S11)+2*(S10>S11)+1);"Tie";R10;R11)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formula to return lowest value of 3 datapoints 3
Help with formula 8
formula or conditional formating 2
Formulae check 1
problem: "You entered too many arguments for this function" 1
College Football IF Formula 0
Index and Match 3
Need help Taking alot data from one sheet (if not blank) and copying toa list on another sheet. 1

Back
Top