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

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

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

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