If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
formula
Hello All,
I need help with a formula that multiplies two cells. The first numberis the actual cell, but the second number refers to a cell with a cell address. I.e. =A1*A10 A1 is an actual number A10 has a cell address ($B2) So I actually want the formula to calculate A1*$B2 A10 is a concantenation of two other cells. So I think I need to somehow let the formula know it is a cell reference. Thanks in Advance |
#2
|
|||
|
|||
formula
one way:
=A1*INDIRECT(A10) In article , "Tim" wrote: Hello All, I need help with a formula that multiplies two cells. The first numberis the actual cell, but the second number refers to a cell with a cell address. I.e. =A1*A10 A1 is an actual number A10 has a cell address ($B2) So I actually want the formula to calculate A1*$B2 A10 is a concantenation of two other cells. So I think I need to somehow let the formula know it is a cell reference. Thanks in Advance |
Thread Tools | |
Display Modes | |
|
|