Forum Discussion
Round up
If I have a column to round up, how do I do this?
I used round(X,2) for rounding up 95.7 to 96 but this means, I have key in round into the formula. It is very tedious. I had previously used formating but it shows 96 but in calculation, it is still 95.7.
- Hi Chan_Tze_Leong ,
how about this?
Best regards
Schnittlauch
https://support.microsoft.com/en-us/office/round-function-c018c5d8-40fb-4053-90b1-b3e7f61a213c If you want it to count with rounded numbers then use this formula as an example. .
in english: =SUM(ROUND(B2:B30,2) in German: =SUMME(RUNDEN(B2:B30;2)
Matrixformel you need to press Ctrl+Shift+Enter to enter them.
Wish you a nice day / night with lots of health, joy and love.
Thank you for your patience and time.
Hope to have helped you further.
Nikolino
I know I don't know anything (Socrates)
* Kindly Mark and Vote any reply if it helps please, as it will be beneficial to more Community members reading here.
