Forum Discussion
Reference to a specific cell (even after insert)
INDIRECT(address) returns the value of the cell with the specified address, whether that is a text value, a number, a date, ...
=INDIRECT("C114")/(INDIRECT("C98")+INDIRECT("C103")) should work if C114, C98 and C102 contain valid numbers.
You do have to set the number format of the cell with the formula the way you want.
If you want to refer to a fixed cell, e.g. C2:
=INDIRECT("C2")
If you want to refer to the cell in column C in the same row as the cell with the formula:
=INDIRECT("C"&ROW())
- Thank you Hans! The "Indirect" function is just what I needed.
How do I do simple math using the "Indirect" function, like: =C114/(C98+C103)? I tried =Indirect("C114")/(Indirect("C98")+Indirect("C103")) but not sure if the function returns a number or string... Thanks again!INDIRECT(address) returns the value of the cell with the specified address, whether that is a text value, a number, a date, ...
=INDIRECT("C114")/(INDIRECT("C98")+INDIRECT("C103")) should work if C114, C98 and C102 contain valid numbers.
You do have to set the number format of the cell with the formula the way you want.
- Thank you. That command works... (I must have had a typo...)
Anyway, thank you and have a great day!
