View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Bob I Bob I is offline
external usenet poster
 
Posts: 2,819
Default Number sortation

What if there is say 22 pages?

daffy1 wrote:

Sorry, I should have said that there is only even numbers to start with.

"Pete_UK" wrote:


What happens if you have an odd number of pages to start with? Is it
increased by 1 to make it even?

Pete

On Oct 11, 10:38 pm, daffy1 wrote:

I am trying to come up with a formula to sort page counts. Example: If I
give the number 52. It has to sort into 1 24-page, 0 20-page, 1 16-page, 1
12-page and 0 8 page. The only available dividers are 24, 20, 16, 12 and 8.