please provide detail to get brake down of $104258 as denomination

The following will break a value down into thousands, hundreds, fifties,
twenties, tens, fives, and ones:

In cell A1 enter:
104258

In cell B1 enter:
=ROUNDDOWN(A1/1000,0)

In cell A2 enter:
=A1-B1*1000

In cell B2 enter:
=IF(A2<100,0,ROUNDDOWN(A2/100,0))

In cell A3 enter:
=A2-B2*100

In cell B3 enter:
=IF(A3<50,0,ROUNDDOWN(A3/50,0))

In cell A4 enter:
=A3-50*B3

In cell B4 enter:
=IF(A4<20,0,ROUNDDOWN(A4/20,0))

In cell A5 enter:
=A4-20*B4

In cell B5 enter:
=IF(A5<10,0,ROUNDDOWN(A5/10,0))

In cell A6 enter:
=A4-10*B4

In cell B6 enter:
=IF(A6<5,0,ROUNDDOWN(A6/5,0))

In cell A7 enter:
=A6-5*B6

In cell B7 enter:
=A7

So if we examine B1 thru B7 we see:

104 thousands
2 hundreds
1 fifties
0 twenties
0 tens
1 fives
3 ones

--
Gary''s Student - gsnu200775


"anoshan" wrote:

please provide detail to get brake down of $104258 as denomination