View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Crumb Crumb is offline
external usenet poster
 
Posts: 5
Default Automatic Config Tool Question

Can anyone help me with this configuration question?

I am trying to build a tool that allows user to input any number and
the results are broken down into units of 5,10,20, 50, 100 and 200
starting at the highest were possible and working its way down. the
Number of units should always exceed the input.

Example.

User enters 67

Return should be 50x1, 10x2

The units will be in cells A1, A2 and so on and I am looking for the
return to be entered into B1 B2 .....


Can anyone help with this?

Many Thanks

Ian