Move value to formula result

[deciog]

I have the calculated address of a cell, with the ADDRESS formula, how do I put a value directly in that cell?

It is possible, only in formula, Version 2016 and 365

Decio

 

[bosco_yip]

=INDIRECT(ADDRESS(4,13,1))

or,

=INDIRECT("r4c13",)

or,

=INDIRECT(TEXT(413,"\r00\c00"),)

 

[pecoflyer]

Or =INDIRECT(INDEX($M$1:$M$100,4))
Be aware that INDIRECT is a volatile function...

 

[deciog]

First thanks for the reply.

What I need is to put value in cell $M$4 example value $125.32

look example

only by formula

It is possible?

Decio

 

[pecoflyer]

And where does that value come from?

 

[bosco_yip]

What I need is to put value in cell $M$4 example value $125.32
Decio

Your example in cell M4 already have $125.32,

Then.

What do you want?

 

[deciog]

Gentlemen, thank you for your help.
I noticed that it is not possible to move a value by cell address
Thank you for your time to help
Consider this doubt closed

Thank you very much
Décio