****** BLACK FRIDAY SALE ****** VBA/Macro Course (80% OFF) -> www.teachexcel.com/vba-course-update.php?src=yt_pin_fbWYuQgw6M8 Professional Forms in Excel (65% OFF) -> www.teachexcel.com/premium-courses/68/idiot-proof-forms-in-excel?src=yt_pin_fbWYuQgw6M8 Email from Excel (65% OFF) -> www.teachexcel.com/premium-courses/96/send-emails-from-excel-course?src=yt_pin_fbWYuQgw6M8
I actually did that but im always off .1 decimal meaning instead of 0.48 it shows 0.47 I'm computing my daily interest balance plus the daily average balance yesterday
Great video, but is there a way to round within the same cell, or do I have to insert the result in the adjacent cell? And this method requires me to do the function for each cell. This takes more time than just entering it manually. Microsoft should have an easier way for such a basic function.
For calculating retails… if I have a retail come out as 13.57 … is there a formula that will help round it up to $13.59?? Same with round down.. eg $13.09 to round down to $12.99? … I need the cents to end in a 9.
I'm making a workout program and have all the weights calculated in their cells but want to know how to have it round them all to the nearest 2.5, can anyone help?
Dear, loved you explanation, need to ask you one thing if you can please provide me a solution. Lets see below We have a number 26.71 and when i round off this it comes 27, So my question is how can we round off so that it gives 26 instead of 27. Thank you
i am trying to convert kb to mb then mb to gb here is the gb formula i used =D2 /( 1024 * 1024*1024) it works but it shows up as 1234.44234543 how do i make it so it does the formula and shows up like this 1234.44 also i have over 4000 in my list how do i add kb, mb, and gb to the end of every cell in each column so it would show 1234.44 mb.
nice, r you know how to draw the circle in excel work sheet, with calculation , if we put any value circle increase or decrease according to value put in excel sheet......
C'mon man, all caps?! You can ask questions like this on our free forum and, if you do, please upload a sample file so it''s easier to help: www.teachexcel.com/talk/microsoft-office?src=yt
Please help... In one cell if I have value of 10 Rupeea in column A1 ... In other cell it is 250 paise Column B1 I want to convert 250 paise to Rupees (which is equal to 100 paise) and resultant 2 rupees of B1 should automatically add to the Rupees 10 of A1 Column showing 12 Rupees in column A1 and 50 Paise in Column B1
Hi, I am unable to get my desired decimal number after doing an average of 4 cells. The average number gives me an unwanted decimal number. E.g First, I want .00 to .24 as the round number (Like: The average is 112.15, which should be 112.00), Then, .24 to .75 as .50 (Like: The average is 112.34, which should be 112.50), Finally, .76 to .99 as the next rounded number (Like: The average is 112.82, which should be 113.00). It would be a great favor, if you reply me with the formula for this problem. Have a great day. Thank you.
I apply a formula and get value 18.1159 Round off I get 18.12 Now I multiply it with 10 and i get 181.16 And i want value 181.20 What should I do Please help
Thanks for this Video. While calculating salary increment we round up to next tens if the amount is like 8932 or 8407 or 8159 BUT if the amount calculated is 8930.135 then we keep it to 8930 only. Here the [roundup(number, -1)] formula is calculating 8930.135 as 8940 too. Please help me with some formula to solve the issue.
Amazing that you can't simply have a number rounded off as you work, but you have to create an entirely new column where you type in the function you need. Excel doesn't have a number format that just limits the decimal points? Hard to believe.
83.84 74.19 55.81 43.97 42.9 27.05 Sir, I have above 6 numbers only in column or row, but I need only those three numbers out of above 6 numbers that give me average of 50 or nearby 50 (+5 or -5) I want those three numbers, highlighted or separated automatically.
****** BLACK FRIDAY SALE ******
VBA/Macro Course (80% OFF) -> www.teachexcel.com/vba-course-update.php?src=yt_pin_fbWYuQgw6M8
Professional Forms in Excel (65% OFF) -> www.teachexcel.com/premium-courses/68/idiot-proof-forms-in-excel?src=yt_pin_fbWYuQgw6M8
Email from Excel (65% OFF) -> www.teachexcel.com/premium-courses/96/send-emails-from-excel-course?src=yt_pin_fbWYuQgw6M8
I actually did that but im always off .1 decimal
meaning instead of 0.48
it shows 0.47
I'm computing my daily interest balance plus the daily average balance yesterday
great video straight to the point and easy to understand. Thank you vm! I subscribed.
This formula is The BEST to find STT CHARGE in STOCK MARKET... Thanks a lot...
You helped me a lot, I wasted 1 hour trying to know how to adjust the number, with your video it take it less than 1 min, Thank you very much
@ZeeMath thanks boss
Can you use the function to round an existing value in its original cell without having to create a new cell to put the rounded value in?
that was my question lol
Mine too
yes exactly my question too
Simply & perfectly explained, great job, thank uuuu.....
Great video, but is there a way to round within the same cell, or do I have to insert the result in the adjacent cell? And this method requires me to do the function for each cell. This takes more time than just entering it manually. Microsoft should have an easier way for such a basic function.
Put round on the outside of the formula.
@@timmyreed7903 how
Thank You so much. I was searching for this one the whole day. 💯💯💯💯👍👍👍👍
It was very helpful. Thank u for uploading this video
This will help me in the Mathematics examination and test.
Do you have to have an extra column for the rounded number? that doesn't seem right? I just want it to automatically round in one column
Am really grateful! You saved my time and my life as well 🙂
Ok
You're a lifesaver, thanks alot🙏
One Problem, I don't want the number to appear in a different cell, I want it to the number in a cell with the result being in the same cell.
enter the function of that cell to the "number" in the round function
Just do Ctrl+shift+1 , this is uupto 2 decimal
@@RahulKumar-yw8trThat applies the round function to the cell contents to two decimal places? Turns: 2.3456 Into: =ROUND(2.3456,2) ?
Thank you very much. You have saved me a lot of time. i wish I had seen this earlier.
You're very welcome! Glad to help :)
Thanks a tonne saved my time . Your explanation is very clear.
I was searching this !ty for this video
For calculating retails… if I have a retail come out as 13.57 … is there a formula that will help round it up to $13.59?? Same with round down.. eg $13.09 to round down to $12.99? … I need the cents to end in a 9.
Thanks for the tutorial 👍
What do I do if I want to round up or down by (5's)? For instance, the number 13 would round up to 15 or 12.4 for round down to 10.
My Computer Teacher recommended me to watch this vid
Great tutorial, thankyou!
Thanks you sir. It helps me a lot
NICE VIDEO DURING PRACTICAL EXAMINATIONS
I understand round off. Thank you
Best.... Keep it up...
Thank You! :))
Hi, can we round the decimal on top of =SUM(A1,A2) formula?
Yes
How to round the result of a formula and display it in the same cell?
is there a way to round numbers within .25 of accuracy?
cant we round for example 22.24 to 22.25?can you please explain?
Use MROUND(22.24,0.05)
Can you let me know who to convert these decimal numbers to percentage ?
Hey , can we roundup to nearest 5 ?
Thanks. Just what I needed.
I'm making a workout program and have all the weights calculated in their cells but want to know how to have it round them all to the nearest 2.5, can anyone help?
Superb....love it
Super class thank for this video 🤞
Dear, loved you explanation, need to ask you one thing if you can please provide me a solution. Lets see below
We have a number 26.71 and when i round off this it comes 27,
So my question is how can we round off so that it gives 26 instead of 27.
Thank you
Can you please tell how to take only decimal value from B coloumn to other coloumn
Thanks for your video. Very useful.
Thank you very much sir!!!
What's the rounding mode of round function? Is it ceiling?
This is so helpful thank you
Damm cool to the point video! Highly appreciate!
i am trying to convert kb to mb then mb to gb here is the gb formula i used =D2 /( 1024 * 1024*1024) it works but it shows up as 1234.44234543 how do i make it so it does the formula and shows up like this 1234.44 also i have over 4000 in my list how do i add kb, mb, and gb to the end of every cell in each column so it would show 1234.44 mb.
This is great thank you so much!
nice, r you know how to draw the circle in excel work sheet, with calculation , if we put any value circle increase or decrease according to value put in excel sheet......
Nyc helped it into my work
hello, how about for the last two decimal places, below 0.05 round down to 0.00;
below 0.09 round down to 0.05,ONLY equal to 0.09 round up to 0.1;
Thanks man... that really helped me...
very helpful.. thanks buddy .....
Many many thanks sir for this video
how do i do this without requiring an extra collumn]
Tq for this tips bro
If it appears there is an error in the fomula try use " ; " instead of " , "
👍good video
Thank you 🙏
WHAT IF I HAVE A FLEET OF VEHICLES AND EACH HAS A 17 DIGIT VIN NUMBER BUT I ONLY WANT TO SEE THE LAST 6 DIGITS OF THAT #? CAN YOU HELP
C'mon man, all caps?! You can ask questions like this on our free forum and, if you do, please upload a sample file so it''s easier to help: www.teachexcel.com/talk/microsoft-office?src=yt
thanks a bunch!
Please help...
In one cell if I have value of 10 Rupeea in column A1 ...
In other cell it is 250 paise Column B1
I want to convert 250 paise to Rupees (which is equal to 100 paise) and resultant 2 rupees of B1 should automatically add to the Rupees 10 of A1 Column showing 12 Rupees in column A1 and 50 Paise in Column B1
Thanks 👍
Great vedio sir
How do I keep a whole number in cell from turning into a formula everytime
thank u so much my problem is solved
I type 500 in excel and auto changes to 5.00 will some solve this problem
Hi, I am unable to get my desired decimal number after doing an average of 4 cells. The average number gives me an unwanted decimal number. E.g First, I want .00 to .24 as the round number (Like: The average is 112.15, which should be 112.00), Then, .24 to .75 as .50 (Like: The average is 112.34, which should be 112.50), Finally, .76 to .99 as the next rounded number (Like: The average is 112.82, which should be 113.00). It would be a great favor, if you reply me with the formula for this problem. Have a great day. Thank you.
thank you very much sir
Thanx
Thanks a lot
my favorite math
Thank you
Go to home > numbers ... click erow pointing to the right .
Thanks bro
It's not working :(
I get a box that tells me "the formula you typed contains errors"
Why what is the problem?
I have ICDL Exam tomorrow!!!
Help!!!
Did you pass the exam?
How to round 120.5% to 121%...... When i trying it becames as 100%... Help me
I apply a formula and get value 18.1159
Round off I get 18.12
Now I multiply it with 10 and i get 181.16
And i want value 181.20
What should I do
Please help
Blessings from pakistan
Why do you keep getting .0000 ??? .000000 ???
Thank you sir
What is rounding-off
Ok
Ok. Please explain to me
Oh. Wow
Everyone is praising about you till 1000000000000000000000%.
🌍🌎🌏🌍🌎🌏🌞
Thanks for this Video.
While calculating salary increment we round up to next tens if the amount is like 8932 or 8407 or 8159
BUT
if the amount calculated is 8930.135 then we keep it to 8930 only.
Here the [roundup(number, -1)] formula is calculating 8930.135 as 8940 too.
Please help me with some formula to solve the issue.
thanks! i needed that..>!!
Tnxs!
Amazing that you can't simply have a number rounded off as you work, but you have to create an entirely new column where you type in the function you need. Excel doesn't have a number format that just limits the decimal points? Hard to believe.
I know it has been a decade since this video is uploaded, but how do I go to nearest (.99) ?
put decimal 0 , the all decimal above 4 will be 1 and bellow 5 will be neglected
thank u....now iam passing yes
234576 iske liye formula ???
thanks
thank you so much ^_^
thank you love u
thanks!
appreciate it
pls round it to the nearest ten
Pearson statlab got me here
How to
=G43*L27 Round to nearest whole number, no decimal???
For answer on line G44
your audio is very low. you should reload this again with better audio
83.84
74.19
55.81
43.97
42.9
27.05
Sir, I have above 6 numbers only in column or row, but I need only those three numbers out of above 6 numbers that give me average of 50 or nearby 50 (+5 or -5) I want those three numbers, highlighted or separated automatically.
hirap Yan Hindi ko geys
Thank you very much. You have saved me a lot of time. I wish I had seen this earlier.
great video straight to the point and easy to understand. Thank you vm! I subscribed.
Thank you sir