Force the decimals to even numbers in a formula

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

FAQ

Thread Tools

Display Modes

01-21-2024, 10:45 PM

ArviLaanemets ArviLaanemets is offline

Force the decimals to even numbers in a formula

Windows 8

Office 2016

Expert

Join Date: May 2017

Posts: 960

Quote:

Originally Posted by Marcia

We collect real property taxes at 2% of the assessed values.

Example: 21.94*.20=4.39

How much are taxes? 2% or 20%?

About CEILING() parameter - the result is rounded up, so it will be ending as multiply of parameter. So with parameter = 0.02, the results will be either ?.00, ?.02, ?.04, etc.

« Previous Thread | Next Thread »

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:28 PM.