Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 | |
|
|
![]() |
||||
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 |