Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Simple Function question?
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(S10S12,R10,R12)+IF(S10=S12,0)) |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Simple Function question?
Don't, know where S10 and S12 come into it
=IF(OR(R10="",R12=""),"",IF(R10R12,R10,IF(R10<R12 ,R12,"tie"))) -- HTH Bob Phillips (remove nothere from email address if mailing direct) "jboss73" wrote in message ... 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(S10S12,R10,R12)+IF(S10=S12,0)) |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Simple Function question?
Got it.....thanks for your help!
"Bob Phillips" wrote: Don't, know where S10 and S12 come into it =IF(OR(R10="",R12=""),"",IF(R10R12,R10,IF(R10<R12 ,R12,"tie"))) -- HTH Bob Phillips (remove nothere from email address if mailing direct) "jboss73" wrote in message ... 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(S10S12,R10,R12)+IF(S10=S12,0)) |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Simple Function question?
Hi
When R10:R11 contain player names, and S10:S11 their scores, then =CHOOSE(IF(OR(S10="";S11="");1;(S10S11)+2*(S10S1 1)+1);"Tie";R10;R11) -- Arvi Laanemets ( My real mail address: arvi.laanemets<attarkon.ee ) "jboss73" wrote in message ... 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(S10S12,R10,R12)+IF(S10=S12,0)) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Simple count function | Excel Worksheet Functions | |||
Simple question: Difference between two dates? | Excel Discussion (Misc queries) | |||
Array Function Question | Excel Worksheet Functions | |||
Function question | Excel Worksheet Functions | |||
Simple, Monday morning brain function | Excel Worksheet Functions |