Re: If auto fill is not allowed, then how do i go about doing it?

[cloud]

The whole question is actually like this:
Create a worksheet that gives in column B a list of all of the 4 digit years
that are palindromes, beginning with 1001 in B6 and extending on down in
ascending order. You may use other columns as well but the final answer for
the row must be in coulmn B. Furthermore,all rows below row 7 must be the
result of filling the cells in row 7 down the worksheet. You may not use Auto
Fill.

[SludgeQuake]

try entering the following formula in B7:
=if(mid(b6,2,1)="9",11,110)+b6
Hope that helps.
- sludge

"cloud" wrote:

> The whole question is actually like this:
> Create a worksheet that gives in column B a list of all of the 4 digit years
> that are palindromes, beginning with 1001 in B6 and extending on down in
> ascending order. You may use other columns as well but the final answer for
> the row must be in coulmn B. Furthermore,all rows below row 7 must be the
> result of filling the cells in row 7 down the worksheet. You may not use Auto
> Fill.

[cloud]

thank you so much for ur help

"SludgeQuake" wrote:

> try entering the following formula in B7:
> =if(mid(b6,2,1)="9",11,110)+b6
> Hope that helps.
> - sludge
>
> "cloud" wrote:
>
> > The whole question is actually like this:
> > Create a worksheet that gives in column B a list of all of the 4 digit years
> > that are palindromes, beginning with 1001 in B6 and extending on down in
> > ascending order. You may use other columns as well but the final answer for
> > the row must be in coulmn B. Furthermore,all rows below row 7 must be the
> > result of filling the cells in row 7 down the worksheet. You may not use Auto
> > Fill.