| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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. |
|
#2
|
|||
|
|||
|
=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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VBA function for "Mean" using Array as argument | Excel Worksheet Functions | |||
| creating function (vba) with range arguments | Excel Worksheet Functions | |||
| Round whole numbers up and down | Excel Discussion (Misc queries) | |||
| Automatically up date time in a cell | Excel Discussion (Misc queries) | |||
| HOW CAN I GET OFFICE 2003 EXCEL BASIC TO NEST FUNCTIONS LIKE EXCE. | Excel Worksheet Functions | |||
Linear Mode
