Round number

[wladoD]

Hi,

I would like to ask about round function.
Number 2.9 will be rounded to number 3
Anyhow I could make number 2.9 to round to number 2?

Thank you

[The_Snook]

Hi wladoD,

The ROUNDDOWN function should be able to do this for you.

E.g. =ROUNDDOWN(Cell Ref,0)

Regards,

Snook

[wladoD]

Great it worked.

Thank you