#1
|
||||
|
||||
Force the decimals to even numbers in a formula
Hi. We collect real property taxes at 2% of the assessed values. Discounts are given to early payors and penalties imposed on the late ones. The collections are shared equally by the local govt and the schools. To make the sharing seamless, we would like the amounts collected rounded up to the last 2 even decimals. Example: 21.94*.20=4.39 I would like help in the formula =ROUND(D7*.2,2) that would make it 4.40 and all results to be rounded up to even numbers. Actually the formulae we are applying to compute the fines and penalties are quite lengthy,I just presented a simplified one here. Thank you. |
#2
|
||||
|
||||
In more recent versions of Excel:
Code:
=CEILING.MATH(D7,0.02) Code:
=CEILING(D7,0.02) |
#3
|
||||
|
||||
Thank you p45Cal. It is perfect. I need to do some reading on the role of the .02
|
#4
|
|||
|
|||
Quote:
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. |
#5
|
||||
|
||||
Quote:
|
|
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 |