Previous Topic Next Topic

Excel Formula Question

Closed
Pharas - Sep 10, 2010 at 03:27 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Sep 10, 2010 at 08:38 PM
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 response

Answer 1 / 1
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
Sep 10, 2010 at 08:38 PM
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
0

Similar discussions

How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses
How to calculate position (1st,2nd,3rd) in excel....?
abdulwajid -
TrowaD -

1 response
Keyboard troubles
jimbobjoe -
car -

38 responses
Calculation of positions in excel
Mohsin -
Dausayi -

12 responses
formulas for 1st and 2nd position in class
jack -
suff954 -

1 response