Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
best config | Excel Worksheet Functions | |||
Config Now() troubles | Excel Worksheet Functions | |||
Deployment and config files | Excel Programming | |||
tool bar question | Excel Worksheet Functions | |||
Creating and using a config file | Excel Programming |