Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
getting numbers that are divisible by 4
Hi evebody,
I have data(numbers) from 1 to 10000 in columnA Now I need in column B the numbers which are divisible by 4, it looks very simple but I'm finding it hard to get this. Could some body help me how to do this. Thanks and Regards Ramana |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
getting numbers that are divisible by 4
Here's one way:
Enter 4 in B1 Select B1 Goto the menu EditFillSeries Select Columns and Linear Step value 4 Stop value 10000 OK Biff "ramana" wrote in message oups.com... Hi evebody, I have data(numbers) from 1 to 10000 in columnA Now I need in column B the numbers which are divisible by 4, it looks very simple but I'm finding it hard to get this. Could some body help me how to do this. Thanks and Regards Ramana |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
getting numbers that are divisible by 4
Enter this formula in B1 and double click on fill handler to copy it 10000 rows below. =IF(MOD(A1,4)=0,A1,"") |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
getting numbers that are divisible by 4
On Jun 19, 10:54 am, Jovan Timotijevic
wrote: Enter this formula in B1 and double click on fill handler to copy it 10000 rows below. =IF(MOD(A1,4)=0,A1,"") Hi Jovan, Thank you for giving the reply, I have already tried what you have suggested, I'm getting the value in every 4th row, remaining are blank, but I need in continuous cells. i.e. in the first row it should be 4 second row 8 third row 12 and so on... Thanks and Regards Ramana |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
getting numbers that are divisible by 4
On Jun 18, 11:06 pm, ramana wrote:
On Jun 19, 10:54 am, Jovan Timotijevic wrote: =IF(MOD(A1,4)=0,A1,"") I have already tried what you have suggested, I'm getting the value in every 4th row, remaining are blank, but I need in continuous cells. i.e. in the first row it should be 4 second row 8 third row 12 and so on... I'm not sure why I cannot get Biff's (T Valko's) solution to work. It seems to be the simplest, if you always want multiples of 4 from 1 to 10000, as you wrote. If you simply want multiples of 4 from 1 to 10000 starting in B1, try: B1: =4*row() Copy down through B2500. If you are starting in some other cell (e.g. B10), write: B10: =4*(row()-row($B$10)+1) If you want a more general solution, please clarify the general problem that you want to solve. For example, multiples of 4 from any set of 10000 numbers, monotonically increasing, but not necessarily sequential, in column A. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Check if Equally Divisible | Excel Worksheet Functions | |||
need a conditional formula to generate numbers divisible by 4 between a given starting no. & end No. | Excel Worksheet Functions | |||
Roundup to the nearest number that is divisible by 3 | Excel Worksheet Functions | |||
How get true response when numbers divisible by 12? | Excel Worksheet Functions | |||
how do an @if formula to meet criteria where x is divisible by 12 | Excel Worksheet Functions |