Thread: if statements
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_6_] Bob Phillips[_6_] is offline
external usenet poster
 
Posts: 11,272
Default 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.