Prev Previous Post   Next Post Next
  #1   Report Post  
Member
 
Posts: 36
Default Round Amount

We are using bahrain Currecny, Kindly Help me to get the below mentioned amount format
eg:
9.922 Round to : 9.925
9.949 Round to : 9.950
9.973 Round to : 9.975
9.988 Round to : 10.000

Pls Help me..
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Calculate the amount of time over a permitted amount (12 hours) Steve M Excel Discussion (Misc queries) 9 June 2nd 10 09:25 PM
How do I get a calculated amount to round to the nearest nickel? Raina Excel Worksheet Functions 3 July 24th 07 07:28 AM
how can i round a dollar amount to the nearest thousand? Karen Excel Worksheet Functions 1 January 22nd 07 08:06 PM
How can I calculate amount of time left based on amount spent? KLD Excel Worksheet Functions 3 May 23rd 06 04:20 PM
Round amount to nearest $10 after other formula calc. in same cell debtors Excel Worksheet Functions 2 March 24th 06 11:45 AM


All times are GMT +1. The time now is 10:16 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"