Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Setup / March 2008

Tip: Looking for answers? Try searching our database.

how to get denomination

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
anoshan - 24 Mar 2008 20:22 GMT
please provide detail to get brake down of $104258 as denomination
Gary''s Student - 25 Mar 2008 16:19 GMT
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

Signature

Gary''s Student - gsnu200775

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

Rate this thread:






 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.