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