Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
if statements
I've tried and tried, but can't figure this one out. Any help is
appreciated. Would like to program this statement in but can't figure out the proper form If Cell 1 = 2 and Cell 2 = 3 then Cell 3 should display 2/3 If Cell 1 = 2 and Cell 2 = 4 then Cell 3 should display 2/4 If Cell 1 = 2 and Cell 2 = 5 then Cell 3 should display 2/5 If Cell 1 = 2 and Cell 2 = 6 then Cell 3 should display 2/6 If Cell 1 = 2 and Cell 2 = 7 then Cell 3 should display 2/6 If Cell 1 = 3 and Cell 2 = 2 then Cell 3 should display 3/2 If Cell 1 = 3 and Cell 2 = 3 then Cell 3 should display 2/2 If Cell 1 = 3 and Cell 2 = 4 then Cell 3 should display 2/3 If Cell 1 = 3 and Cell 2 = 5 then Cell 3 should display 2/4 If Cell 1 = 3 and Cell 2 = 6 then Cell 3 should display 2/5 It goes on like this, but think you may get the picture. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
if statements
I assume the last few are typos
If Cell 1 = 3 and Cell 2 = 3 then Cell 3 should display 2/2 If Cell 1 = 3 and Cell 2 = 4 then Cell 3 should display 2/3 If Cell 1 = 3 and Cell 2 = 5 then Cell 3 should display 2/4 If Cell 1 = 3 and Cell 2 = 6 then Cell 3 should display 2/5 =cell1&"/"&cell2 -- HTH RP (remove nothere from the email address if mailing direct) "kdkat" wrote in message ... I've tried and tried, but can't figure this one out. Any help is appreciated. Would like to program this statement in but can't figure out the proper form If Cell 1 = 2 and Cell 2 = 3 then Cell 3 should display 2/3 If Cell 1 = 2 and Cell 2 = 4 then Cell 3 should display 2/4 If Cell 1 = 2 and Cell 2 = 5 then Cell 3 should display 2/5 If Cell 1 = 2 and Cell 2 = 6 then Cell 3 should display 2/6 If Cell 1 = 2 and Cell 2 = 7 then Cell 3 should display 2/6 If Cell 1 = 3 and Cell 2 = 2 then Cell 3 should display 3/2 If Cell 1 = 3 and Cell 2 = 3 then Cell 3 should display 2/2 If Cell 1 = 3 and Cell 2 = 4 then Cell 3 should display 2/3 If Cell 1 = 3 and Cell 2 = 5 then Cell 3 should display 2/4 If Cell 1 = 3 and Cell 2 = 6 then Cell 3 should display 2/5 It goes on like this, but think you may get the picture. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
if statements
Cell 3 does equate to any mathematically figure. the "/" is figurative. It
is strictly text. Basically I run an amateur pool league. Every player has a handicap # and based on these #'s depending on who your playing at the time, there is a game race. So Cell 1 = Handicap 3 and Cell 2 = Handicap 4 then Cell 3 should display the game race which in the above example is a 2 to 3 race. Hope this clarifies, and hope someone can help Thanks Katherine "Bob Phillips" wrote: I assume the last few are typos If Cell 1 = 3 and Cell 2 = 3 then Cell 3 should display 2/2 If Cell 1 = 3 and Cell 2 = 4 then Cell 3 should display 2/3 If Cell 1 = 3 and Cell 2 = 5 then Cell 3 should display 2/4 If Cell 1 = 3 and Cell 2 = 6 then Cell 3 should display 2/5 =cell1&"/"&cell2 -- HTH RP (remove nothere from the email address if mailing direct) "kdkat" wrote in message ... I've tried and tried, but can't figure this one out. Any help is appreciated. Would like to program this statement in but can't figure out the proper form If Cell 1 = 2 and Cell 2 = 3 then Cell 3 should display 2/3 If Cell 1 = 2 and Cell 2 = 4 then Cell 3 should display 2/4 If Cell 1 = 2 and Cell 2 = 5 then Cell 3 should display 2/5 If Cell 1 = 2 and Cell 2 = 6 then Cell 3 should display 2/6 If Cell 1 = 2 and Cell 2 = 7 then Cell 3 should display 2/6 If Cell 1 = 3 and Cell 2 = 2 then Cell 3 should display 3/2 If Cell 1 = 3 and Cell 2 = 3 then Cell 3 should display 2/2 If Cell 1 = 3 and Cell 2 = 4 then Cell 3 should display 2/3 If Cell 1 = 3 and Cell 2 = 5 then Cell 3 should display 2/4 If Cell 1 = 3 and Cell 2 = 6 then Cell 3 should display 2/5 It goes on like this, but think you may get the picture. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
if statements
On Wed, 26 Oct 2005 11:40:03 -0700, "kdkat"
wrote: Cell 3 does equate to any mathematically figure. the "/" is figurative. It is strictly text. Basically I run an amateur pool league. Every player has a handicap # and based on these #'s depending on who your playing at the time, there is a game race. So Cell 1 = Handicap 3 and Cell 2 = Handicap 4 then Cell 3 should display the game race which in the above example is a 2 to 3 race. Hope this clarifies, and hope someone can help Thanks Katherine How do you determine that if Cell1=3 and Cell2=4 that it is a 2 to 3 race? --ron |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
if statements
There is a pre-determined "race grid" that we follow.
"Ron Rosenfeld" wrote: On Wed, 26 Oct 2005 11:40:03 -0700, "kdkat" wrote: Cell 3 does equate to any mathematically figure. the "/" is figurative. It is strictly text. Basically I run an amateur pool league. Every player has a handicap # and based on these #'s depending on who your playing at the time, there is a game race. So Cell 1 = Handicap 3 and Cell 2 = Handicap 4 then Cell 3 should display the game race which in the above example is a 2 to 3 race. Hope this clarifies, and hope someone can help Thanks Katherine How do you determine that if Cell1=3 and Cell2=4 that it is a 2 to 3 race? --ron |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
if statements
On Wed, 26 Oct 2005 14:02:02 -0700, "kdkat"
wrote: There is a pre-determined "race grid" that we follow. "Ron Rosenfeld" wrote: On Wed, 26 Oct 2005 11:40:03 -0700, "kdkat" wrote: Cell 3 does equate to any mathematically figure. the "/" is figurative. It is strictly text. Basically I run an amateur pool league. Every player has a handicap # and based on these #'s depending on who your playing at the time, there is a game race. So Cell 1 = Handicap 3 and Cell 2 = Handicap 4 then Cell 3 should display the game race which in the above example is a 2 to 3 race. Hope this clarifies, and hope someone can help Thanks Katherine How do you determine that if Cell1=3 and Cell2=4 that it is a 2 to 3 race? --ron You'll need to take the contents of Cell 1 and Cell 2 and match it to your Grid. Exactly how depends on how the Grid is set up. --ron |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
if statements
Can I not specify the race grid in the statement? My problem is that I know
what I want to happen, but I am unsure how to proceed. Basically, based on values in 2 cells, I want the result in the 3rd cell to display.. "Ron Rosenfeld" wrote: On Wed, 26 Oct 2005 14:02:02 -0700, "kdkat" wrote: There is a pre-determined "race grid" that we follow. "Ron Rosenfeld" wrote: On Wed, 26 Oct 2005 11:40:03 -0700, "kdkat" wrote: Cell 3 does equate to any mathematically figure. the "/" is figurative. It is strictly text. Basically I run an amateur pool league. Every player has a handicap # and based on these #'s depending on who your playing at the time, there is a game race. So Cell 1 = Handicap 3 and Cell 2 = Handicap 4 then Cell 3 should display the game race which in the above example is a 2 to 3 race. Hope this clarifies, and hope someone can help Thanks Katherine How do you determine that if Cell1=3 and Cell2=4 that it is a 2 to 3 race? --ron You'll need to take the contents of Cell 1 and Cell 2 and match it to your Grid. Exactly how depends on how the Grid is set up. --ron |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
if statements
Here is the entire race grid spelled out. Based on Cell 1 and Cell 2 I'd
like the correct text value from Cell 3 displayed. I know it's long and maybe it's not an IF statement I'm looking for? Trouble is, I don't use Excel very often, and am completely unaware of what else is out there, or even how to go about using it. I'm limited to =SUM knowledge - lol Your help is extremely appreciated.. Kath If Cell 1 = 2 and Cell 2 = 3 then Cell 3 should display 2/3 If Cell 1 = 2 and Cell 2 = 4 then Cell 3 should display 2/4 If Cell 1 = 2 and Cell 2 = 5 then Cell 3 should display 2/5 If Cell 1 = 2 and Cell 2 = 6 then Cell 3 should display 2/6 If Cell 1 = 2 and Cell 2 = 7 then Cell 3 should display 2/6 If Cell 1 = 3 and Cell 2 = 2 then Cell 3 should display 3/2 If Cell 1 = 3 and Cell 2 = 3 then Cell 3 should display 2/2 If Cell 1 = 3 and Cell 2 = 4 then Cell 3 should display 2/3 If Cell 1 = 3 and Cell 2 = 5 then Cell 3 should display 2/4 If Cell 1 = 3 and Cell 2 = 6 then Cell 3 should display 2/5 If Cell 1 = 3 and Cell 2 = 7 then Cell 3 should display 2/6 If Cell 1 = 4 and Cell 2 = 2 then Cell 3 should display 4/2 If Cell 1 = 4 and Cell 2 = 3 then Cell 3 should display 3/2 If Cell 1 = 4 and Cell 2 = 4 then Cell 3 should display 3/3 If Cell 1 = 4 and Cell 2 = 5 then Cell 3 should display 3/4 If Cell 1 = 4 and Cell 2 = 6 then Cell 3 should display 3/5 If Cell 1 = 4 and Cell 2 = 7 then Cell 3 should display 2/5 If Cell 1 = 5 and Cell 2 = 2 then Cell 3 should display 5/2 If Cell 1 = 5 and Cell 2 = 3 then Cell 3 should display 4/2 If Cell 1 = 5 and Cell 2 = 4 then Cell 3 should display 4/3 If Cell 1 = 5 and Cell 2 = 5 then Cell 3 should display 4/4 If Cell 1 = 5 and Cell 2 = 6 then Cell 3 should display 4/5 If Cell 1 = 5 and Cell 2 = 7 then Cell 3 should display 3/5 If Cell 1 = 6 and Cell 2 = 2 then Cell 3 should display 6/2 If Cell 1 = 6 and Cell 2 = 3 then Cell 3 should display 5/2 If Cell 1 = 6 and Cell 2 = 4 then Cell 3 should display 5/3 If Cell 1 = 6 and Cell 2 = 5 then Cell 3 should display 5/4 If Cell 1 = 6 and Cell 2 = 6 then Cell 3 should display 5/5 If Cell 1 = 6 and Cell 2 = 7 then Cell 3 should display 4/5 If Cell 1 = 7 and Cell 2 = 2 then Cell 3 should display 6/2 If Cell 1 = 7 and Cell 2 = 3 then Cell 3 should display 6/2 If Cell 1 = 7 and Cell 2 = 4 then Cell 3 should display 5/2 If Cell 1 = 7 and Cell 2 = 5 then Cell 3 should display 5/3 If Cell 1 = 7 and Cell 2 = 6 then Cell 3 should display 5/4 If Cell 1 = 7 and Cell 2 = 7 then Cell 3 should display 5/5 "kdkat" wrote: There is a pre-determined "race grid" that we follow. "Ron Rosenfeld" wrote: On Wed, 26 Oct 2005 11:40:03 -0700, "kdkat" wrote: Cell 3 does equate to any mathematically figure. the "/" is figurative. It is strictly text. Basically I run an amateur pool league. Every player has a handicap # and based on these #'s depending on who your playing at the time, there is a game race. So Cell 1 = Handicap 3 and Cell 2 = Handicap 4 then Cell 3 should display the game race which in the above example is a 2 to 3 race. Hope this clarifies, and hope someone can help Thanks Katherine How do you determine that if Cell1=3 and Cell2=4 that it is a 2 to 3 race? --ron |
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
if statements
Hi Kath
One way, assuming your cell 1, cell 2 and cell 3 are in fact A1, B1 and C1 on Sheet1. On Sheet2 set up a table in columns A and B with column A holding 23,24,25,2,27,32,33, etc using your cell 1 and cell2 values combined. Alongside these in column B place your desired display result '2/3, '2/4, '2/5, '2/6, '2/6 You will need to use the preceding apostrophe to prevent Ecel from treating them as date entries. Then on Sheet 1 in C1 enter =VLOOKUP(A1&A2,Sheet2!$A$1:$B$36,2,0) Copy down through C2:C36 Regards Roger Govier kdkat wrote: Here is the entire race grid spelled out. Based on Cell 1 and Cell 2 I'd like the correct text value from Cell 3 displayed. I know it's long and maybe it's not an IF statement I'm looking for? Trouble is, I don't use Excel very often, and am completely unaware of what else is out there, or even how to go about using it. I'm limited to =SUM knowledge - lol Your help is extremely appreciated.. Kath If Cell 1 = 2 and Cell 2 = 3 then Cell 3 should display 2/3 If Cell 1 = 2 and Cell 2 = 4 then Cell 3 should display 2/4 If Cell 1 = 2 and Cell 2 = 5 then Cell 3 should display 2/5 If Cell 1 = 2 and Cell 2 = 6 then Cell 3 should display 2/6 If Cell 1 = 2 and Cell 2 = 7 then Cell 3 should display 2/6 If Cell 1 = 3 and Cell 2 = 2 then Cell 3 should display 3/2 If Cell 1 = 3 and Cell 2 = 3 then Cell 3 should display 2/2 If Cell 1 = 3 and Cell 2 = 4 then Cell 3 should display 2/3 If Cell 1 = 3 and Cell 2 = 5 then Cell 3 should display 2/4 If Cell 1 = 3 and Cell 2 = 6 then Cell 3 should display 2/5 If Cell 1 = 3 and Cell 2 = 7 then Cell 3 should display 2/6 If Cell 1 = 4 and Cell 2 = 2 then Cell 3 should display 4/2 If Cell 1 = 4 and Cell 2 = 3 then Cell 3 should display 3/2 If Cell 1 = 4 and Cell 2 = 4 then Cell 3 should display 3/3 If Cell 1 = 4 and Cell 2 = 5 then Cell 3 should display 3/4 If Cell 1 = 4 and Cell 2 = 6 then Cell 3 should display 3/5 If Cell 1 = 4 and Cell 2 = 7 then Cell 3 should display 2/5 If Cell 1 = 5 and Cell 2 = 2 then Cell 3 should display 5/2 If Cell 1 = 5 and Cell 2 = 3 then Cell 3 should display 4/2 If Cell 1 = 5 and Cell 2 = 4 then Cell 3 should display 4/3 If Cell 1 = 5 and Cell 2 = 5 then Cell 3 should display 4/4 If Cell 1 = 5 and Cell 2 = 6 then Cell 3 should display 4/5 If Cell 1 = 5 and Cell 2 = 7 then Cell 3 should display 3/5 If Cell 1 = 6 and Cell 2 = 2 then Cell 3 should display 6/2 If Cell 1 = 6 and Cell 2 = 3 then Cell 3 should display 5/2 If Cell 1 = 6 and Cell 2 = 4 then Cell 3 should display 5/3 If Cell 1 = 6 and Cell 2 = 5 then Cell 3 should display 5/4 If Cell 1 = 6 and Cell 2 = 6 then Cell 3 should display 5/5 If Cell 1 = 6 and Cell 2 = 7 then Cell 3 should display 4/5 If Cell 1 = 7 and Cell 2 = 2 then Cell 3 should display 6/2 If Cell 1 = 7 and Cell 2 = 3 then Cell 3 should display 6/2 If Cell 1 = 7 and Cell 2 = 4 then Cell 3 should display 5/2 If Cell 1 = 7 and Cell 2 = 5 then Cell 3 should display 5/3 If Cell 1 = 7 and Cell 2 = 6 then Cell 3 should display 5/4 If Cell 1 = 7 and Cell 2 = 7 then Cell 3 should display 5/5 "kdkat" wrote: There is a pre-determined "race grid" that we follow. "Ron Rosenfeld" wrote: On Wed, 26 Oct 2005 11:40:03 -0700, "kdkat" wrote: Cell 3 does equate to any mathematically figure. the "/" is figurative. It is strictly text. Basically I run an amateur pool league. Every player has a handicap # and based on these #'s depending on who your playing at the time, there is a game race. So Cell 1 = Handicap 3 and Cell 2 = Handicap 4 then Cell 3 should display the game race which in the above example is a 2 to 3 race. Hope this clarifies, and hope someone can help Thanks Katherine How do you determine that if Cell1=3 and Cell2=4 that it is a 2 to 3 race? --ron |
#10
Posted to microsoft.public.excel.programming
|
|||
|
|||
if statements
23,24,25,2,27,32,33, etc using your cell 1 and cell2 values combined.
That should read 23,24,25,26,27,32,33, etc using your cell 1 and cell2 values combined. Regards Roger Govier Roger Govier wrote: Hi Kath One way, assuming your cell 1, cell 2 and cell 3 are in fact A1, B1 and C1 on Sheet1. On Sheet2 set up a table in columns A and B with column A holding 23,24,25,2,27,32,33, etc using your cell 1 and cell2 values combined. Alongside these in column B place your desired display result '2/3, '2/4, '2/5, '2/6, '2/6 You will need to use the preceding apostrophe to prevent Ecel from treating them as date entries. Then on Sheet 1 in C1 enter =VLOOKUP(A1&A2,Sheet2!$A$1:$B$36,2,0) Copy down through C2:C36 Regards Roger Govier kdkat wrote: Here is the entire race grid spelled out. Based on Cell 1 and Cell 2 I'd like the correct text value from Cell 3 displayed. I know it's long and maybe it's not an IF statement I'm looking for? Trouble is, I don't use Excel very often, and am completely unaware of what else is out there, or even how to go about using it. I'm limited to =SUM knowledge - lol Your help is extremely appreciated.. Kath If Cell 1 = 2 and Cell 2 = 3 then Cell 3 should display 2/3 If Cell 1 = 2 and Cell 2 = 4 then Cell 3 should display 2/4 If Cell 1 = 2 and Cell 2 = 5 then Cell 3 should display 2/5 If Cell 1 = 2 and Cell 2 = 6 then Cell 3 should display 2/6 If Cell 1 = 2 and Cell 2 = 7 then Cell 3 should display 2/6 If Cell 1 = 3 and Cell 2 = 2 then Cell 3 should display 3/2 If Cell 1 = 3 and Cell 2 = 3 then Cell 3 should display 2/2 If Cell 1 = 3 and Cell 2 = 4 then Cell 3 should display 2/3 If Cell 1 = 3 and Cell 2 = 5 then Cell 3 should display 2/4 If Cell 1 = 3 and Cell 2 = 6 then Cell 3 should display 2/5 If Cell 1 = 3 and Cell 2 = 7 then Cell 3 should display 2/6 If Cell 1 = 4 and Cell 2 = 2 then Cell 3 should display 4/2 If Cell 1 = 4 and Cell 2 = 3 then Cell 3 should display 3/2 If Cell 1 = 4 and Cell 2 = 4 then Cell 3 should display 3/3 If Cell 1 = 4 and Cell 2 = 5 then Cell 3 should display 3/4 If Cell 1 = 4 and Cell 2 = 6 then Cell 3 should display 3/5 If Cell 1 = 4 and Cell 2 = 7 then Cell 3 should display 2/5 If Cell 1 = 5 and Cell 2 = 2 then Cell 3 should display 5/2 If Cell 1 = 5 and Cell 2 = 3 then Cell 3 should display 4/2 If Cell 1 = 5 and Cell 2 = 4 then Cell 3 should display 4/3 If Cell 1 = 5 and Cell 2 = 5 then Cell 3 should display 4/4 If Cell 1 = 5 and Cell 2 = 6 then Cell 3 should display 4/5 If Cell 1 = 5 and Cell 2 = 7 then Cell 3 should display 3/5 If Cell 1 = 6 and Cell 2 = 2 then Cell 3 should display 6/2 If Cell 1 = 6 and Cell 2 = 3 then Cell 3 should display 5/2 If Cell 1 = 6 and Cell 2 = 4 then Cell 3 should display 5/3 If Cell 1 = 6 and Cell 2 = 5 then Cell 3 should display 5/4 If Cell 1 = 6 and Cell 2 = 6 then Cell 3 should display 5/5 If Cell 1 = 6 and Cell 2 = 7 then Cell 3 should display 4/5 If Cell 1 = 7 and Cell 2 = 2 then Cell 3 should display 6/2 If Cell 1 = 7 and Cell 2 = 3 then Cell 3 should display 6/2 If Cell 1 = 7 and Cell 2 = 4 then Cell 3 should display 5/2 If Cell 1 = 7 and Cell 2 = 5 then Cell 3 should display 5/3 If Cell 1 = 7 and Cell 2 = 6 then Cell 3 should display 5/4 If Cell 1 = 7 and Cell 2 = 7 then Cell 3 should display 5/5 "kdkat" wrote: There is a pre-determined "race grid" that we follow. "Ron Rosenfeld" wrote: On Wed, 26 Oct 2005 11:40:03 -0700, "kdkat" wrote: Cell 3 does equate to any mathematically figure. the "/" is figurative. It is strictly text. Basically I run an amateur pool league. Every player has a handicap # and based on these #'s depending on who your playing at the time, there is a game race. So Cell 1 = Handicap 3 and Cell 2 = Handicap 4 then Cell 3 should display the game race which in the above example is a 2 to 3 race. Hope this clarifies, and hope someone can help Thanks Katherine How do you determine that if Cell1=3 and Cell2=4 that it is a 2 to 3 race? --ron |
#11
Posted to microsoft.public.excel.programming
|
|||
|
|||
if statements
OK, here is how I would do that (and I would not have been able to set it up
had you not supplied the entire grid). First, set up a grid someplace on your worksheet and NAME it "grid". The grid should look like: 2 3 4 5 6 7 2 2/3 2/4 2/5 2/6 2/6 3 3/2 2/2 2/3 2/4 2/5 2/6 4 4/2 3/2 3/3 3/4 3/5 2/5 5 5/2 4/2 4/3 4/4 4/5 3/5 6 6/2 5/2 5/3 5/4 5/5 4/5 7 6/2 6/2 5/2 5/3 5/4 5/5 Note that the numbers representing the contents of Cell_1 and Cell_2 are across the top and left side; and in the grid are what should be displayed given the contents of those cells. To NAME this, after you have entered these values, select the grid; then Insert/Name/Define and type grid into the box labeled "Names in Workbook". IMPORTANT: Format the cells as TEXT before entering the values. Otherwise your 'fractions' will be interpreted as dates. You can then use this formula to show your displays: =HLOOKUP(Cell_2,grid,VLOOKUP(Cell_1,grid,1,0),0) If you get #NA as a result, it is probably due to the contents of either Cell 1 or Cell 2 being TEXT that looks like a number and not a real number. Those cells should be formatted as General or Number before you make your entries. On Wed, 26 Oct 2005 17:11:01 -0700, "kdkat" wrote: Here is the entire race grid spelled out. Based on Cell 1 and Cell 2 I'd like the correct text value from Cell 3 displayed. I know it's long and maybe it's not an IF statement I'm looking for? Trouble is, I don't use Excel very often, and am completely unaware of what else is out there, or even how to go about using it. I'm limited to =SUM knowledge - lol Your help is extremely appreciated.. Kath If Cell 1 = 2 and Cell 2 = 3 then Cell 3 should display 2/3 If Cell 1 = 2 and Cell 2 = 4 then Cell 3 should display 2/4 If Cell 1 = 2 and Cell 2 = 5 then Cell 3 should display 2/5 If Cell 1 = 2 and Cell 2 = 6 then Cell 3 should display 2/6 If Cell 1 = 2 and Cell 2 = 7 then Cell 3 should display 2/6 If Cell 1 = 3 and Cell 2 = 2 then Cell 3 should display 3/2 If Cell 1 = 3 and Cell 2 = 3 then Cell 3 should display 2/2 If Cell 1 = 3 and Cell 2 = 4 then Cell 3 should display 2/3 If Cell 1 = 3 and Cell 2 = 5 then Cell 3 should display 2/4 If Cell 1 = 3 and Cell 2 = 6 then Cell 3 should display 2/5 If Cell 1 = 3 and Cell 2 = 7 then Cell 3 should display 2/6 If Cell 1 = 4 and Cell 2 = 2 then Cell 3 should display 4/2 If Cell 1 = 4 and Cell 2 = 3 then Cell 3 should display 3/2 If Cell 1 = 4 and Cell 2 = 4 then Cell 3 should display 3/3 If Cell 1 = 4 and Cell 2 = 5 then Cell 3 should display 3/4 If Cell 1 = 4 and Cell 2 = 6 then Cell 3 should display 3/5 If Cell 1 = 4 and Cell 2 = 7 then Cell 3 should display 2/5 If Cell 1 = 5 and Cell 2 = 2 then Cell 3 should display 5/2 If Cell 1 = 5 and Cell 2 = 3 then Cell 3 should display 4/2 If Cell 1 = 5 and Cell 2 = 4 then Cell 3 should display 4/3 If Cell 1 = 5 and Cell 2 = 5 then Cell 3 should display 4/4 If Cell 1 = 5 and Cell 2 = 6 then Cell 3 should display 4/5 If Cell 1 = 5 and Cell 2 = 7 then Cell 3 should display 3/5 If Cell 1 = 6 and Cell 2 = 2 then Cell 3 should display 6/2 If Cell 1 = 6 and Cell 2 = 3 then Cell 3 should display 5/2 If Cell 1 = 6 and Cell 2 = 4 then Cell 3 should display 5/3 If Cell 1 = 6 and Cell 2 = 5 then Cell 3 should display 5/4 If Cell 1 = 6 and Cell 2 = 6 then Cell 3 should display 5/5 If Cell 1 = 6 and Cell 2 = 7 then Cell 3 should display 4/5 If Cell 1 = 7 and Cell 2 = 2 then Cell 3 should display 6/2 If Cell 1 = 7 and Cell 2 = 3 then Cell 3 should display 6/2 If Cell 1 = 7 and Cell 2 = 4 then Cell 3 should display 5/2 If Cell 1 = 7 and Cell 2 = 5 then Cell 3 should display 5/3 If Cell 1 = 7 and Cell 2 = 6 then Cell 3 should display 5/4 If Cell 1 = 7 and Cell 2 = 7 then Cell 3 should display 5/5 "kdkat" wrote: There is a pre-determined "race grid" that we follow. "Ron Rosenfeld" wrote: On Wed, 26 Oct 2005 11:40:03 -0700, "kdkat" wrote: Cell 3 does equate to any mathematically figure. the "/" is figurative. It is strictly text. Basically I run an amateur pool league. Every player has a handicap # and based on these #'s depending on who your playing at the time, there is a game race. So Cell 1 = Handicap 3 and Cell 2 = Handicap 4 then Cell 3 should display the game race which in the above example is a 2 to 3 race. Hope this clarifies, and hope someone can help Thanks Katherine How do you determine that if Cell1=3 and Cell2=4 that it is a 2 to 3 race? --ron --ron |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
IF statements | New Users to Excel | |||
IF Statements (Mutliple Statements) | Excel Worksheet Functions | |||
if/and statements | Excel Worksheet Functions | |||
If statements | Excel Discussion (Misc queries) | |||
operator statements, shorting when reusing one of the statements? | Excel Programming |