Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
If auto fill is not allowed, then how do i go about doing it?
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
If auto fill is not allowed, then how do i go about doing it?
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
If auto fill is not allowed, then how do i go about doing it?
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro for Auto Fill | Excel Discussion (Misc queries) | |||
stop auto fill from thinking for itself!!!!!!! | New Users to Excel | |||
Auto Fill Options | Excel Discussion (Misc queries) | |||
Auto fill option box disappeared | Excel Worksheet Functions | |||
Auto Fill Options | Excel Discussion (Misc queries) |