Excel function as a quoted cell number

Closed

Elena - 3 Apr 2010 à 14:34
Elena - 4 Apr 2010 à 06:56

Hi,
I want to have a formula for the number of the row I am quoting, i.e. B[=4+4*A7], but it does not work
Thank you!
Elena

2 responses

Réponse 1 / 2

Jack Rex Posts 177 Registration date Saturday 2 January 2010 Status Member Last seen 13 August 2016 7
4 Apr 2010 à 01:55

Formulas should always be entered with an = first or the function. Like-
=2+3+4, or SUM(2,3), etc.

Réponse 2 / 2

Elena
4 Apr 2010 à 06:56

Namely, this is how I used it with = in front, but it gives Error 508! Maybe I am not allowed to quote in the cell number formula another cell, am I?