Force the decimals to even numbers in a formula

		Microsoft Office Forums > Microsoft Excel > Excel
Force the decimals to even numbers in a formula

01-21-2024, 05:31 PM

p45cal

Windows 10 Force the decimals to even numbers in a formula

Office 2021

Expert

Join Date: Apr 2014

Posts: 956

In more recent versions of Excel:

Code:

=CEILING.MATH(D7,0.02)

and older versions:

Code:

=CEILING(D7,0.02)

where cell D7 is the result of your calculations, or the calculation itself instead of a cell reference.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Create a sequence of numbers using a formula	14spar15	Excel Programming	9	03-19-2018 01:15 AM
force formula calc to manual when opening any workbook	johnd23	Excel	1	02-27-2017 08:22 PM
Display %complete in decimals	fridos	Project	3	05-04-2015 02:03 PM
Force a content control to be only numbers (not using VBA)	brent.fraser	Word	4	10-15-2013 11:12 AM
Prices from decimals to ticks	rollie	Excel	1	11-17-2012 08:08 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:10 PM.