Rounding up in excel

		Microsoft Office Forums > Microsoft Excel > Excel
Rounding up in excel

FAQ

Thread Tools

Display Modes

09-27-2023, 12:37 AM

otuatail

Windows 7 64bit Rounding up in excel

Office 2016

Competent Performer

Join Date: Jun 2012

Posts: 245

Good question. Never thought about it properly. Currently today (UK time) it shows 68.64. I supose if it was greater than .5 then round up if lower round down. So rounded to the nearest whole value. I thought just wrapping the whole calculation in a ROUNDUP() function should have worked.

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Rounding of dollar value	Formd	Mail Merge	2	07-06-2022 01:21 PM
Custom rounding up	paulkaye	Excel	8	09-03-2016 11:12 PM
Excel Seems to be Rounding Twice Rather Than Once	melissapete24	Excel	5	08-27-2016 12:51 AM
Rounding to nearest 0.25	Guloluseus	Excel	5	10-27-2015 11:28 PM
Standard Dev. Rounding - Excel	judicial85	Excel	1	08-28-2011 05:41 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:40 PM.