ExcelBanter - how do i set up round function

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

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - how do i set up round function (https://www.excelbanter.com/excel-worksheet-functions/49085-how-do-i-set-up-round-function.html)

run superman

how do i set up round function

I am trying to insert round function on external reference functions, and
nothing is happening.
'Category Financial Review'!G7/(H7*$L$4) is the formula I am trying to round.

David Billigmeier

=ROUND('Category Financial Review'!G7/(H7*$L$4),0) will round to 0 digits
=ROUND('Category Financial Review'!G7/(H7*$L$4),1) will round to 1 digit
=ROUND('Category Financial Review'!G7/(H7*$L$4),2) will round to 2 digits
etc.

--
Regards,
Dave

"run superman" wrote:

I am trying to insert round function on external reference functions, and
nothing is happening.
'Category Financial Review'!G7/(H7*$L$4) is the formula I am trying to round.

All times are GMT +1. The time now is 03:37 PM.