Floor function

  • Thread starter Thread starter Rene
  • Start date Start date
R

Rene

I am looking for the correct way to do a "FLOOR" function.
I want to calculate one cell, say "D10" and put the
results in cell "F10" then "FLOOR" the value in "F10".

Any help owuld be appreciated.

Thanks
Rene
 
Rene said:
I am looking for the correct way to do a "FLOOR" function.
I want to calculate one cell, say "D10" and put the
results in cell "F10" then "FLOOR" the value in "F10".

Any help owuld be appreciated.

Thanks
Rene
Click to expand...

The formula in F10 will be
=FLOOR(D10,x)
where x is the significance (or multiple to which you want to round).

For example, if the value in D10 is 123.4 then:
=FLOOR(D10,1)
would give a result of 123

=FLOOR(D10,2)
would give 122

=FLOOR(D10,5)
would give 120
 
Back
Top