This video was prepared in response to a clients question on how to round up pricing for retail. I share some issues and some various ways.. I hope this helps you,
Nguồn: https://chaddnrc.net/
Xem thêm bài viết: https://chaddnrc.net/category/cong-nghe
How to Round to a specific number in Excel
Never Knew It Before Thumbs Up Sir
This was exactly what i was searching for. thank you so much .
Thanks so much for this upload, keep it continue…
thanks dear
I want to round off in lakhs value in 7digits how to go
Sir two cell add & third cell devide ans round off mein kaise laate hain
Thank you so much Sir,
You just saved my day with ceiling function!!! 🙂
Thanks for the round function
Hello! I have this problem: I used function Average(C3:F3), the result is 5,33; in other cell i have 5,66. I want to use function countif to count how many of 5 and 6 are.I formated cells to remove decimals; excel show numbers without decimals, but in background they are still there and formula countif dont count them.What can i do? Thank you!
ROUNDING SHOULDNT TAKE 6 mins
Thanks Brain, i was actually looking for CEILING formula. (Y)
aap sabhi logo ka bahut bahut thanky ..jo aap logo ne video uplod kiye aur sabhi logo ko ghar baithe exce ki jankari di …..aage bhi aap log aise hi video banaye aur ham logo ki padhai me help kijeye
Thank you very much sir 🙂
What about changing a decimal number to the next whole number. (e.g. 3.14 –> 4)
How about correcting to N significant figure? Would that be possible in excel?
How could we adjust excel to show 2 decimal as a parameter from excel options
Awesome video really helpful. How would I round all of my prices up to the nearest 9. Example My price is 23.43 and I need it to round up to 23.49 and I need to do this for the entire price list. Thank you!
👍
Really helpful !! Tx a lot !!
Sir Brian.. Hi I'd like to ask you how will i convert hours in to amount like for example 10:38am up to 11:38am its 1 hour and it 15.00 pesos how will i do that in excel? thanks
Hi , great video there! However how do I round down if its <0.50 and round up if its>0.50? Say i wanna round down if its 200.25 (to 200.00) and round up if its 200.60 (to 201.00), how can i do that ? Please help thanks !
thanks, very useful
Thanks a lot Mr glen .
great video
Incredible~
Thanks man. Helped a lot!
Thanks dear!!!
Love your video 🙂 I needed to round as well…thank you a bunch.
Hello. Yes we are talking about reordering on an inventory level. Say they sold 32 on hand have 6 it is an easy formula to subtract to get the total to reorder however what happens when you have to order by a case pack of say 24
If I am using excel to help do reordering for retail products. If I need to reoder 18 pcs for example, but I have to order in quantities of 24 what is the forumula Thanks
I Just solve a problem with this wonderful tutorial, thanks for your help
Thanks, I was looking how to round off to the nearest 5,000, and this video provided the exact explanation I needed.
Thanks Alot for Information.
Glad it helped. Thanks for watching.