ExcelBanter - Rounding

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Rounding (https://www.excelbanter.com/excel-discussion-misc-queries/221312-rounding.html)

Russ_Hiatt

Rounding

How do I get a formula to always round down?

Niek Otten

Rounding

=ROUNDDOWN(YourFormula,0)

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Russ_Hiatt" wrote in message
...
How do I get a formula to always round down?

FARAZ QURESHI

Rounding

=ROUNDDOWN(Number,Decimal places required)
--

Best Regards,
FARAZ A. QURESHI

"Russ_Hiatt" wrote:

How do I get a formula to always round down?

All times are GMT +1. The time now is 12:50 PM.