LinkBack URL
About LinkBacks
I have 4,96 inside a cell but need to put inside cell as a lower level 4 not 5. Can be managed inside Excel 2007 Pro version?
I have 4,96 inside a cell but need to put inside cell as a lower level 4 not 5. Can be managed inside Excel 2007 Pro version?
is this from a calculation or entered into cell
rounddown()
or
int()
Wayne
if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Not sure what you mean exactly.
Administrative Note:
Although we value your privacy as much you do, it could be important that members have a rough idea of your location as the solutions they offer may be affected by your locale. For instance, you might in the future post questions which are related to your regional settings.
With this in mind, please update your profile to something more precise (something such as UK, Europe, USA, UAE, etc. will suffice).
Thank you for helping us to help you.
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.
We are from Europe. I use Office PRO Excel version 2007. When I calculate =1998/400, I get a result like 4,995. As I need to bring such number to the lowest rounded number, need to know how to manage this using formula settings. An example: 4,995 should be rounded to 4.
Pleae update your forum profile with Europe instead of N/A. Thanks.
You can use:
=ROUNDDOWN(yourformula,0) as suggested in Post 2.
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
I have tried. =ROUNDDOWN(D7/H4,0) will not work.
Invisible problems are hard to diagnose. Read the yellow banner (top) and post a sample sheet.
Also you were asked to add your approx (national) location. N/a means nothing. You stated Europe... that's too vague. Here we use , as the separator. In many other countries ; is used.
Kindly, DO NOT ignore requests from Forum Moderators.
Thank you for all help. I have managed using pure menu options. Your suggestions fixes when I go step by step using menu. It is more accurate.
It works perfect: =ROUNDDOWN(J4;0)
Last edited by toplisek; 04-02-2021 at 04:24 AM.
rounddown() is supported in version 2007
so Why doesnot work, as suggested a sample spreadsheet would help to see whyI have tried. =ROUNDDOWN(D7/H4,0) will not work.
As you can see from the attached spreadsheeet = D7=4.96 and H4 = 1 - so result in A1 should be 4.96 - but i used rounddown() and got 4
or try
=FLOOR(J4;0)
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks