Forum Discussion
Solved
Reference to a specific cell (even after insert)
I've got a question that seems like there would be a simple solution... But I don't know it... I have a financial spreadsheet. The value of each account, for a given date, is put into cells in ...
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 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!
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!