Oh boy, I wish I was clever.
Using open office spreadsheet. Is it possible to introduce a statement into
a cell something like this:
=(b7+b13)*.05 IF answer is x = > .005 then let x = .01 IF x <= .005 then let
x = .00
Hope that is logical to everyone
Might it not be better to use an integer statement, to allow rounding of
different values too?
Seems to work in Excel. To explain:
(b7+b13)*.005 : the original formula.
* 1000 : multiply by 1000 to move the decimal point three places to the left
+0.5 : add 0.5
int : strip off anything after the decimal point
/ 1000 : divide by 1000 to move the decimal point three places to the right.
Adding the 0.5 before the 'int' function ensures that values from 0.0 -
0.499 will end up as 0.5 - 0.999, and hence '0' once the decimal part is
removed. And values 0.5 - 0.999 will end up as 1.0 - 1.499, and hence '1'
once the decimal part is removed.
HomeOwnersHub.com is a website for homeowners and building and maintenance pros. It is not affiliated with any of the manufacturers or service providers discussed here.
All logos and trade names are the property of their respective owners.