ROUND function not working how I want it
Hi everyone!
I have some data I am trying to look at and I was wondering if there was a way to get this ROUND fxn / decimal place thing to work! I have numbers that I want to round up, but when I try to do that anything under 1 turns into 0
I have attached a picture of what I mean.
Thank you in advance!
**Thank you everyone for reminding me its roundUP not just round, you guys rock!
Last edited by sy898661; 07-09-2019 at 11:09 AM.
Thank you!!!
=roundup(a2,)
Have you tried ROUNDUP?
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.
Try it this way:
=INT(A2+1)
where A2 contains the (fractional) number of pallets.
Hope this helps.
Pete
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks