Excel Formula Question

Closed
Report
-
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
-
Hello,

I am new to excel. I wan want to create a database list in Sheet1 and use the formula on Sheet2 onwards.

What I want to creat in logic is:

A variable (should be 2 cells left on the same row)* a constant figure (eg. 30)

I want the variable can be use on every sheet.

Please help. Thanks.

1 reply

Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
803
your requirement is not clear.any how see whether this answer helps you


A1 has value 1
b1 2
C1 3

now in D1 type this formula

=OFFSET(C1,0,-2,1,1)*30
note the third argument in offset is minus 2
and hit enter