Thread: Round to lowest or highest decimal.

Hi guys i'm kinda new and this is is what i want to do.

I have a cell with a decimal number e.g. 0.0017655 and i want to round it to 3 decimals but on the lowest closest like .001 in this case. round(cell;3) will give me .002 and that's not convienient in this case.

Any thoughs?

=ROUNDDOWN(A1,3)

Would that suit your needs?

that was exactly what i needed i wasn't familliar with the roundup and roundown functions.

thanx friend.