urgently need help - rounding and underlying data

  • Thread starter Thread starter Christina S
  • Start date Start date
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.
 
-----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)
 
Back
Top