| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Indirect & Round Functions
How do I round a number that I am pulling with the Indirect function? My
indirect calculation is: =INDIRECT($A$23&"!k11") and I need to have this number rounded to 3 digits. Thanks in advance for your spreading the knowledge! Jani |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Indirect & Round Functions
Hi Jani,
=ROUND(INDIRECT($A$23&"!k11"),3) Or did I misunderstand your question? -- Kind regards, Niek Otten Microsoft MVP - Excel "Jani" wrote in message ... | How do I round a number that I am pulling with the Indirect function? My | indirect calculation is: =INDIRECT($A$23&"!k11") and I need to have this | number rounded to 3 digits. | | Thanks in advance for your spreading the knowledge! | | Jani |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Indirect & Round Functions
=Round(INDIRECT($A$23&"!k11"),3)
-- Charles Chickering "A good example is twice the value of good advice." "Jani" wrote: How do I round a number that I am pulling with the Indirect function? My indirect calculation is: =INDIRECT($A$23&"!k11") and I need to have this number rounded to 3 digits. Thanks in advance for your spreading the knowledge! Jani |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Indirect & Round Functions
You understood it perfectly... can't believe the quick response! Thanks so
much. jms "Niek Otten" wrote: Hi Jani, =ROUND(INDIRECT($A$23&"!k11"),3) Or did I misunderstand your question? -- Kind regards, Niek Otten Microsoft MVP - Excel "Jani" wrote in message ... | How do I round a number that I am pulling with the Indirect function? My | indirect calculation is: =INDIRECT($A$23&"!k11") and I need to have this | number rounded to 3 digits. | | Thanks in advance for your spreading the knowledge! | | Jani |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Allow EXCEL INDIRECT(ADDRESS()) and INDIRECT(RANGE()) functions | Excel Worksheet Functions | |||
| Using INDIRECT within functions | Excel Worksheet Functions | |||
| How to use Indirect functions? | Excel Discussion (Misc queries) | |||
| If and Round Functions | Excel Worksheet Functions | |||
| row-indirect functions | Excel Discussion (Misc queries) | |||
Linear Mode
