get cells address value in a cells to run a formula

[bigMe]

hello...
i have 2 sheets, in sheet1 in cell A1 contains cells address (the value is dynamic can change) refer to a cells in sheet2 (example C1)
i need to run formula Round in cells C1 in sheet2 with rule the value in C1 is result of previous cells divide with cells A1(fix cells)
in this case =ROUND(B1/A1;2) if the address in cells A1 in sheet1 change for example cells G7 the formula become =ROUND(F7/A1;2)
can someone help me on this case? thank you very much.

 

[arthurbr]

Hi
have a look at the INDIRECT function

 

[etaf]

not following exactly
if in A1 you have a cell reference

Sheet2!H4

then what would the round be
using the cell address in A1

so effectively you want

=round(B1/ the reference in A1 which is Sheet2!H4 , 2) to 2 places

the example you show is
B1 and then say use A1
if G7 then use F7

so is the reference used NOT whats in the cell A1 ???

as mentioned indirect() is how to get a value from a cell and use in a formula

 

[bigMe]

dear etaf,
please see the attachment, so you would get clear point for my question, thank you very much

note : the formula is previous column (in this case cloumn B) divide with cells A1(fix cells)

regards,
bigMe

 

[arthurbr]

Perhaps

=ROUND(B1/INDIRECT($A$1),2)

If you are referring to another workbook I think it should be open