Mod Function?

[Richard]

I have a real problem!
A club enters any number of teams in a competition.The teams are entered into sections for a playoff.The sections must contain 6 teams,but where there is an imperfect number of team entries, a section may contain 5 teams.The number to test with must always be 6.For example:
1]77 teams are entered= 12 sections of 6,
and 1 section of 5
2]45 teams are entered =5 sections of 6,
and 3 sections of 5.
Note the second example where 5 could be used
as the divisor,but 6 is always the preferred
number
VBA requirement: the operator enters the number of teams and the vba function calulates the rest.Is this possible?
I would be most grateful for help on this
Richard

 

[R. Hicks]

Do you want the result to be a string like in your example?

Number Entered: 77

String Result = "12 sections of 6, and 1 section of 5"

RDH


[This message has been edited by R. Hicks (edited 10-07-2000).]