## Cell Value Within Formula

### Cell Value Within Formula

In Cell "C2" I have a value or "12"
In Cell"C4" I have a formula somethine like = M12+N12+Q12

Is there a way in "C4" to have the formula reference "C2"
So if the value of "C2"were changed to 18
"C4" would change to:  =M18+N18+Q12

### Cell Value Within Formula

Have a look at the INDIRECT() function. Look in HELP for details

Regards,

Niek Otten

|
| In Cell "C2" I have a value or "12"
| In Cell"C4" I have a formula somethine like = M12+N12+Q12
|
| Is there a way in "C4" to have the formula reference "C2"
| So if the value of "C2"were changed to 18
| "C4" would change to:  =M18+N18+Q12
|
|
|
|
|

### Cell Value Within Formula

>In Cell "C2" I have a value or "12" In Cell"C4" I have a formula
>somethine like = M12+N12+Q12

>Is there a way in "C4" to have the formula reference "C2" So if the
>value of "C2"were changed to 18
>"C4" would change to:  =M18+N18+Q12

Consider INDEX()

=INDEX(M\$1:M\$65536,C2)+INDEX(N\$1:N\$65536,C2)+Q12

or more cleverly (since M and N are adjacent)

=SUM(INDEX(M\$1:N\$65536,C2,),Q12)

### Cell Value Within Formula

Quote:>In Cell "C2" I have a value or "12"
>In Cell"C4" I have a formula somethine like = M12+N12+Q12

>Is there a way in "C4" to have the formula reference "C2"
>So if the value of "C2"were changed to 18
>"C4" would change to:  =M18+N18+Q12

Use the =INDIRECT() function. Did you intend to not include column Q in the
reference to cell C2? If you did, then the formula would be:

=INDIRECT("M"&C2)+INDIRECT("N"&C2)+Q12

Help I'm stumped.  I have a range (E9..E34). Each cell has a value, but I need
to total the number of cells that have a value over 1.2 (not the sum of all
those cells, just a sum of the cells with a value over 1.2)
I'm using Lotus 123r5w

2. checkbox