I have an issue guys. I want to create a formula which does a simple thing, however I am stuck.
For example, I want a formula that rounds down the number of any cell to a number that is integral multiple of 10,000.
Lets take a case. If A1 = 386,542 I want a formula in B1 that takes that number from A1 and makes it 380,000.
If A1= 383,000 I want a formula that takes that number and makes it 380,000.
Any ideas?
may be
=ROUNDDOWN(A1,-4)
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
No, that does not work :S
Works for me.Originally Posted by nflsales
Regarding this attached of mine, can you make that formula work ?
Here you go.
Wow that is weird, because it did not work for me the first time. Anyway, thanks a lot for your assistance mate!
Have a nice day
see the attached file
You will need this:
=ROUNDDOWN(A1;-4)
not this:
=ROUNDDOWN(A1,-4)
because you are in Greece (different locale).
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks