urgently need help - rounding and underlying data

C

Christina S

I am doing a list of items needed for hurricane shelters,
based on a scientific amount alloted per person. The
quantity needed per shelters is sometimes eg 22.43 cases.
To nearest decimal it looks like 22, but in my
calculation, it still uses the underlying data 22.43 when
calculating cost of cases. Eg $56.00 x 22.43 instead of
$56.00 X 22. I urgently need help.
 
M

Marty Suckstorff

-----Original Message-----
I am doing a list of items needed for hurricane shelters,
based on a scientific amount alloted per person. The
quantity needed per shelters is sometimes eg 22.43 cases.
To nearest decimal it looks like 22, but in my
calculation, it still uses the underlying data 22.43 when
calculating cost of cases. Eg $56.00 x 22.43 instead of
$56.00 X 22. I urgently need help.
.
If you want to round a number before using it in a
Click to expand...
formula you would do this:

=Round(Field1,0) * [Field2]

Rounding after the calculation is done would look like
this:

=Round(([Field1] * [Field2]),0)
 
Top