| 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
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 |
| 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 | |||
Hybrid Mode
