Rounding to a whole number

R

Randy

I have a report that I need a result rounded to the nearest whole number.
Iv'e used the round function before with no problems. The only difference
here is I have a Y/N box included in the expression as follows. What ever I
do, I cannot get it to round as I need. I get 4.56 rather than 5. The
Yes/No box is [ShelledFeeY/N]. Thanks...Randy Here is the expression:
=Round(-([Total Kernels]*[ShelledFeeY/N]))/2000
 
R

Randy

Worked Great! Thanks Bob
Bob said:
Try:

=Round((-([Total Kernels]*[ShelledFeeY/N]))/2000,0)
-----Original Message-----
I have a report that I need a result rounded to the nearest whole number.
Iv'e used the round function before with no problems. The only difference
here is I have a Y/N box included in the expression as follows. What ever I
do, I cannot get it to round as I need. I get 4.56 rather than 5. The
Yes/No box is [ShelledFeeY/N]. Thanks...Randy Here is the expression:
=Round(-([Total Kernels]*[ShelledFeeY/N]))/2000


.
Click to expand...
Click to expand...
 
Top