LinkBack URL
About LinkBacks
Hi all,
I have problem with round amount
i need to round amount after decimal like:
Eg: amount 36,345, need to round it to be 36,500.
amount 36,600 need to round it to be 37,500.
Hi all,
I have problem with round amount
i need to round amount after decimal like:
Eg: amount 36,345, need to round it to be 36,500.
amount 36,600 need to round it to be 37,500.
Hi yukioh,
Try below formula:-
Formula:
Please Login or Register to view this content.
Regards,
DILIPandey
<click on below * if this helps>
DILIPandey, Excel rMVP
+919810929744 (India), +971528225509 (Dubai), [email protected]
Try
=CEILING(A3,500)
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
ok this looks insane, but because of how you want the rounding done, I couldnt get mround, round, roundup or rounddown to work, so I had to brute-force it...
=(VALUE(LEFT(A3,IF(ISERROR(SEARCH(".",A3,1)),LEN(A3)-3,SEARCH(".",A3,1)-4)))*1000)+IF(VALUE(RIGHT(INT(A3),3))<500,500,1000)
edit, of, so I forgot ceiling(), but I put so much effort into the above that I am leaving it there lol
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Yesterday, i spend more than 1 hour to fix an issue like this in a my own project. I tried too many ways and at last i used simple the Ceiling function....edit, of, so I forgot ceiling(), but I put so much effort into the above that I am leaving it there lol
That's why.
But Dillip is faster!
Thanks my friend.. "fotis" .. cheers
Regards,
DILIPandey
<click on below * if this helps>
Thank you so much you guy
Try it like this with ROUNDUP()Originally Posted by FDibbins
=ROUNDUP(A3/500,)*500
nice one 'mama' ..
you are welcome yukioh
cheers
Regards,
DILIPandey
<click on below * if this helps>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks