Can you roundup your totals without having a separate cell block. Meaning if I add $5.00 & $4.00 which is equal to $9.00 can that cell show $10.00 instead as my roundup number.
you made my day, but i have additional for this, is it possible to roundup like this? if 125 or 126 or 127 or 128 or 129 to130? and 121 or 122 or 123 or 124 to 120?
I have a number like 4,400.00 and i want to roundup to 4,500.00, but what it does is rounding up to 5,000.00 instead. What should i do? can i round it up to 4,500.00 ?? Thank you!
Hello! i'd like to know how to round up or add 2 to the whole number if the decimal point is .6 and 1 if the decimal point is .3... example: 26.6 i would like to automatically make it into 28 ; if 26.3 then it will automatically round up to 27.. need to know a possible formula if there is pls.
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.
Hello, I have a question, let's say I have the number 1,66 and I round it up to 2. But than I want to use the rounded up number in a Formula. Usually the Formula will calculate with the 1,66, so how do I make it possible so that the Formula uses the rounded up number 2? Thanks and Cheers!
Please give formula which value required just "123" as per your video. if value 156.001 that result will be "156" not 157. Again, if value 156.01 that result will be "157".
SHORT and SWEET.... to the point and EXACTLY what I needed. DANKE
That 1 min intro was just what I needed. Thanks🙌
what about if I want to round up the B3 cell??? that would be more useful!
=ROUNDUP(123.001,0) that's one way
This was my first time. Thank you!
great job! This is exactly what I needed to complete my tuition model projection!
Cheers, just what i was looking for.
easy peasy. you are a genius. Thank you!
This was helpful.
Thank you very much
Thank you so much, Short and informative
thanks, big help
Very useful to solve my problem
Thanks sir
THANK YOU!
Thank you
Exactly what I need.. Thank you!
Can you roundup your totals without having a separate cell block. Meaning if I add $5.00 & $4.00 which is equal to $9.00 can that cell show $10.00 instead as my roundup number.
I am wanting to round up a cell that already has a figure in it but I want to roundup that figure as a whole number
=round(cell,0)
@@ItsVansh2003 thanks sir
Thank you!
Thank you very helpful 👍
Thanks for this amazing video
Very useful
Very helpful, thank you.
Thanks you so much it's so helpful video thanks
You’re Welcome :) Thank you for your feedback :)
you made my day, but i have additional for this, is it possible to roundup like this? if 125 or 126 or 127 or 128 or 129 to130? and 121 or 122 or 123 or 124 to 120?
Thanks!
Thank u
I love that explanation ❤
Thank you, But I want to dig into a bit more.
I want this :
3.5 round up to 4 but 3.9 round up to 5 . Is there any formula to execute this?
Outstanding - Thanks so much...
Can I round up multiple cells?
Thanks buddy
Glad it was helpful! :)
I have a number like 4,400.00 and i want to roundup to 4,500.00, but what it does is rounding up to 5,000.00 instead. What should i do? can i round it up to 4,500.00 ?? Thank you!
Hello! i'd like to know how to round up or add 2 to the whole number if the decimal point is .6 and 1 if the decimal point is .3...
example:
26.6 i would like to automatically make it into 28 ; if 26.3 then it will automatically round up to 27..
need to know a possible formula if there is pls.
How do you round up the value itself? Not in a separate cell.
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.
Hello, I have a question,
let's say I have the number 1,66 and I round it up to 2. But than I want to use the rounded up number in a Formula. Usually the Formula will calculate with the 1,66, so how do I make it possible so that the Formula uses the rounded up number 2?
Thanks and Cheers!
insert a seperate column and in that column write down the rounded number
Hi, I want a cell to round up to a minimum value of 0.33 , is this possible ? Thanks.
Sir,
How to make values above 2.5 as 3 & values below 2.5 as 2.
Please reply
why didn't he reply--that's what I need to know
I want the result of the formula to round up to the nearest whole number. I cannot find anything to explain that 😢
What do I write if I want to:
Add 2.5% from a certain value into a cell of another column and have it rounded up to -3 all at that particular column?
=round(sum(cells you want to sum),-3)
My number is not in fraction but i want it roundup near by 10. What is the formula?
=round(number you want to round,-1)
I understand that easy but don't know this language.
Please give formula which value required just "123" as per your video. if value 156.001 that result will be "156" not 157. Again, if value 156.01 that result will be "157".
I just want only 123 ,
the sound is not good I am quite disappointed
how on earth is 123.001 closer to 124 than 123?!!
Because its roundedUP and not rounded in general.
Thanks!