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. |
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 |