Autofill to a number using a numerial value in a cel

  • Thread starter Thread starter gacollege
  • Start date Start date
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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Autofill to a number using a numerial value in a cel 2
Autofill column values in formulas 4
Entering numbers in a cel formula 2
When I enter a number in an empty cel, de cel returns the value d. 2
how to get word amounts from numbers in cels 2
Auto fill values with a blank row formatting between entries 7
How-To Autofill cell if cell beside it is a certain value 6
Macro - Using a variable number of columns in a Range 2

Back
Top