Example in excel Lets call it cell A and B How can I output

Example in excel: Let\'s call it cell \"A\" and \"B\"

How can I output the result value from a cell \"B\" that has a formula embeded to cell \"A\" with another formula in excel?

Solution

assume, you contain formula in cell A1, and text A1 in cell C1. at the moment, put the formula =INDIRECT(C1) in any other cell and see what occurs

The INDIRECT function submits to the value in cell C1, which is A1.

The function is way to cell A1 where it selects the value to return, which is formula have value.

consequently, what the INDIRECT function really does in this example is converting a text string into a cell reference.