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
|