Cell Reference
try this
=INDIRECT("A"&A1)+50
so if you now enter 22 in a1 you will get the sume if A22 + 50
Mike
"Felix" wrote:
I need a formula on one worksheet (such as =$A$22+50) whereas the 22 comes
from an entry in a cell.
I tried with €śINDIRECT€ť, but did not succeed... Any other ideas?
--
Felix
|