ExcelBanter - how to round a cell value in formula

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

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - how to round a cell value in formula (https://www.excelbanter.com/excel-programming/351394-how-round-cell-value-formula.html)

Ducky

how to round a cell value in formula

If a cell contains a value such as 4.13, but in a formula I want to use the
rounded value which would be 4, how do I do that?

Ron Rosenfeld

how to round a cell value in formula

On Tue, 24 Jan 2006 18:57:04 -0800, "Ducky"
wrote:

If a cell contains a value such as 4.13, but in a formula I want to use the
rounded value which would be 4, how do I do that?
'
=ROUND(4.13,0)

--ron

All times are GMT +1. The time now is 02:49 PM.