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