Reply to thread

Message: [QUOTE="Gary''s Student, post: 3434384"] 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 [/QUOTE]