Question

if the value in the cell of a1 is 100 and b1 is 10, then the result of the formula =a1=b1

Answer 1

Answer:

Hi,

If you mean that you want the contents of the Cell C1 then you can use cell Function:

eG, Your Cell A1 & B1 already have values

A1= 5

B1 = 5

C1 = A1+B1 = 10 (Cell C1 has a formula of =A1+B1 upon pressing enter key you get 10 as a value)

Use this formula in Cell D1

D1 = CELL( “contents”, C1)

This will give you the contents of Cell C1….. only contents which in this case will be value.

I am assuming that this is what you were looking for.

Thanks