SHORT and SWEET.... to the point and EXACTLY what I needed. DANKE
@brovashift
4 жыл бұрын
what about if I want to round up the B3 cell??? that would be more useful!
@Anenemmea
2 ай бұрын
=ROUNDUP(123.001,0) that's one way
@bentonsdiscounttires8588
10 ай бұрын
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.
@valiantcolumnar1992
5 ай бұрын
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?
@lavieestbelle6068
11 ай бұрын
This was my first time. Thank you!
@apurbaoverdrive
10 ай бұрын
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?
@cannskulls
7 ай бұрын
Cheers, just what i was looking for.
@BarbaraEngle-q6f
Жыл бұрын
easy peasy. you are a genius. Thank you!
@hollyjohnson1214
Жыл бұрын
great job! This is exactly what I needed to complete my tuition model projection!
@alexandrucristian289
Жыл бұрын
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!
@lavieestbelle6068
11 ай бұрын
This was helpful.
@ericquillano8979
Жыл бұрын
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.
@wanasaraf9124
11 ай бұрын
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.
@ToYsparrtan
3 жыл бұрын
Can I round up multiple cells?
@carlos10571
Жыл бұрын
How do you round up the value itself? Not in a separate cell.
@bryan2439
4 ай бұрын
That 1 min intro was just what I needed. Thanks🙌
@christianalbers3820
7 ай бұрын
thanks, big help
@syedraheel1354
2 жыл бұрын
Thank you so much, Short and informative
@TheManojutube
3 жыл бұрын
Thank you very much
@andreabennett3220
3 жыл бұрын
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
@ItsVansh2003
2 жыл бұрын
=round(cell,0)
@Rem-fg2yd
Жыл бұрын
@@ItsVansh2003 thanks sir
@viivek6686
7 ай бұрын
Thanks sir
@NurulHuda-hi6vb
2 жыл бұрын
Very useful to solve my problem
@drkiransonar5790
Жыл бұрын
Thank you
@rubiahmasgipan4311
2 жыл бұрын
Exactly what I need.. Thank you!
@purplesky99876
3 жыл бұрын
THANK YOU!
@brettcattell
3 жыл бұрын
Hi, I want a cell to round up to a minimum value of 0.33 , is this possible ? Thanks.
@harsinchh4342
Жыл бұрын
Sir, How to make values above 2.5 as 3 & values below 2.5 as 2. Please reply
@rr2647
Жыл бұрын
why didn't he reply--that's what I need to know
@Annabr-pm5bv
2 жыл бұрын
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!
@ItsVansh2003
2 жыл бұрын
insert a seperate column and in that column write down the rounded number
@creative.lee3
Жыл бұрын
I want the result of the formula to round up to the nearest whole number. I cannot find anything to explain that 😢
@abdulbasit9364
3 жыл бұрын
Thanks for this amazing video
@madhuribhat3069
3 жыл бұрын
Thank you very helpful 👍
@martyswild
3 жыл бұрын
Thank you!
@ashtonjunge6841
3 жыл бұрын
Very helpful, thank you.
@bck4589
3 жыл бұрын
My number is not in fraction but i want it roundup near by 10. What is the formula?
@ItsVansh2003
2 жыл бұрын
=round(number you want to round,-1)
@shailashetty8996
Жыл бұрын
Thank u
@JaswinderSingh-vb1us
3 жыл бұрын
Very useful
@baseer4371
4 жыл бұрын
Thanks you so much it's so helpful video thanks
@ExcelTutorialsEasyClickAcademy
4 жыл бұрын
You’re Welcome :) Thank you for your feedback :)
@abcasia4150
2 жыл бұрын
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?
@ItsVansh2003
2 жыл бұрын
=round(sum(cells you want to sum),-3)
@dishanthaheshan6901
3 жыл бұрын
I love that explanation ❤
@Philion1
3 жыл бұрын
Outstanding - Thanks so much...
@1234andrew1234
4 жыл бұрын
Thanks!
@rahulgaikwad1509
4 жыл бұрын
Thanks buddy
@ExcelTutorialsEasyClickAcademy
4 жыл бұрын
Glad it was helpful! :)
@sujay857
10 ай бұрын
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".
@maharasikavitha1998
2 жыл бұрын
I understand that easy but don't know this language.
Пікірлер: 59