Add a value to current cell using FormulaR1C1

[ajaykgarg]

I need to add value in cell Z7 to the value in J2 (and retain the value in J2).

This does not work (adding another cell to same cell)

Please Login or Register  to view this content.

But, this works. (Adding two different cells - Y7 and Z7 - and storing the sum in J2)

Please Login or Register  to view this content.

What do I need to do to make the first command work?

tia
ajay

[wakeupcall]

Hi Ajay

perhaps something using similar logic

Please Login or Register  to view this content.

[HaHoBe]

Hi, ajaykgarg,

what you try to do looks like creating a circular reference to a cell where you want to insert a formula - you could place the current value of the cell and add the address of new one to the formula instead if you really want a formula in the cell.

Ciao,
Holger

[ajaykgarg]

Hello

I believe this way, I will get the value in J2, but not the formula.

I need to retain the formula (J2 + Z7) in J2, as I want to let users change Z7, and show new sum in J2.

Thanks
Ajay

[ajaykgarg]

Hi, ajaykgarg,

what you try to do looks like creating a circular reference to a cell where you want to insert a formula - you could place the current value of the cell and add the address of new one to the formula instead if you really want a formula in the cell.

Ciao,
Holger

Hi Holger

You are right. I made it work without a formula, but I need the formula, so users can change values in future, and see the updated results.

I need to do this for thousands of values.
I can maybe use a hidden sheet to do it for every value.

I will go for that option, if I cant find any other simpler way of doing it.

Thanks
Ajay

[HaHoBe]

Hi, Ajay,

Please Login or Register  to view this content.

Ciao,
Holger

[ajaykgarg]

Thanks, Holger. That works perfectly!