On Fri, 17 Jun 2005 11:55:38 -0500, HUBBUB88
wrote:


Hi all

This is my problem:


I need a breakdown of a number that the user types in in cell A1, in
terms of 1000's and 500's and 100s and 10's and 1's


This seems to work, but not extensively tested.

Set up a worksheet as follows:

C1: 1000
D1: 500
E1: 100
F1: 10
G1: 1

C2: =INT(Num/C1)
D2: =INT((Num-INT(SUMPRODUCT($C$1:C1,$C$2:C2)))/D1)

then copy/drag the formula in D2 across to G2.


--ron