Autofill to a number using a numerial value in a cel

G

gacollege

Bernie,

I am fiding out that if A2 is below 7, it does not work.

On another note, I wished I knew the explanation behind ROW()-2 ...
mean I can translate the rest of the formula, but you lost me there...

Thanks!
Richard
 
B

Bernie Deitrick

Richard,

The formula should work for all values in A2 - IF you entered it into cell
B3. Otherwise, the Row()-2 part needs to be adjusted.

ROW() simply returns the row number of the cell where it appears. Since we
started in row 3, I subtracted 2 to get the IF part to work properly: If A2
is 1, then ROW()-2<$A$2 evaluates as 3-2<1 ---- 1<1 ---- FALSE, so
you don't get another label listed.

HTH,
Bernie
MS Excel MVP
 
Top