Way to give cell number after letter with function.

**lapator** · 12-03-2009, 02:42 PM

Something like this ...

I want the A4 cell contains the calculation of B4 (but the number gained from the funtion row and if the B1 cell contains the number 10 the K(B1)=K10

[A4]=B(row())*K(B1)

Thanks.

**NBVC** · 12-03-2009, 02:56 PM

Maybe?

=index(B:B,Row())*index(K:K,B1)

**lapator** · 12-03-2009, 03:15 PM

Originally Posted by NBVC

Maybe?

=index(B:B,Row())*index(K:K,B1)

The index (K:K,B1) is threated as a text not as cell. So it not working.

**NBVC** · 12-03-2009, 04:14 PM

This formula multiplies the value that is in column B of the row your formula is entered in...

e.g. if you are in A5, then it multiplies B5 by the number that is in column K defined by the row number you enter in B1.. so again if you are in Row 5 and have a 3 in B5 and B1 shows 4, so that K4 will have a number, say 7, then the result is

=Index(B:B,Row())*Index(K:K,B1)
=Index(B:B,5)*Index(K:K,4)
=B5*K4
=3*7
=21

**lapator** · 12-03-2009, 04:37 PM

Originally Posted by NBVC

This formula multiplies the value that is in column B of the row your formula is entered in...

e.g. if you are in A5, then it multiplies B5 by the number that is in column K defined by the row number you enter in B1.. so again if you are in Row 5 and have a 3 in B5 and B1 shows 4, so that K4 will have a number, say 7, then the result is

=Index(B:B,Row())*Index(K:K,B1)
=Index(B:B,5)*Index(K:K,4)
=B5*K4
=3*7
=21

You had right. Before it gave me an error...now it working fine.. Thanks.