Re: Round to Nearest Integer in Access
If you incorporate a bit of elementary maths and use INT(number+0.5) it will
always round to the nearest integer. For gimmicky supermarket 'rounding
down' change the 0.5 to fit the store's exact criteria.
Alan
.
Relevant Pages
- RE: Rounding of floating point numbers
... what I am trying to do, I don't think "banker's rounding" will work. ... The total number of patterns I need will vary each time the ... The rule I must follow for odd numbers is to divide by two, round up ... nearest integer, numbers with .51 are always rounded up ...
(perl.beginners) - Re: Rounding a floating point number
... snip float rounding discussion ... ... functions round to nearest integer. ... but I am claiming that using the C99 functions to round to N ...
(comp.lang.c) - Re: Rounding a floating point number
... snip float rounding discussion ... ... functions round to nearest integer. ... but I am claiming that using the C99 functions to round to N ...
(comp.lang.c) - Re: rounding to nearest 100
... would like it to round down to 4" ... That is NOT rounding to nearest hundred but to nearest integer ... looking for a formula that would work for both in one cell ...
(microsoft.public.excel.worksheet.functions) - Re: round number to nearest integer.
... > I received some help here a week ago about rounding up numbers using ... Unfortunately it turns out that I need to round up/down numbers ... > to their nearest integer. ... an integer by adding 1/2, taking the floor of the result, and casting ...
(comp.lang.java.programmer) |
|
