Excel Formula Question [Closed]

Report
-
Posts
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
-
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
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
797
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

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!