Floor function

[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

 

[Mike]

Your understanding is correct.

 

[Anon]

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

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