Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Simplify equation
Cna someone simplify this for me please? Starting at b2
=IF((MOD(COLUMN(),6))=0,6,IF((MOD(COLUMN(),6))=1,7 ,(MOD(COLUMN(),6)))) so i get 2 3 4 5 6 7 2 3 4 5 6 7 2 etc in row 2 Thanks |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Simplify equation
Here is one way... In B2 enter
=IF(OR(COLUMN()=2,A2=7),2,A2+1) and copy across row 2 as needed. Hope this helps, Hutch "Stephen Christian" wrote: Cna someone simplify this for me please? Starting at b2 =IF((MOD(COLUMN(),6))=0,6,IF((MOD(COLUMN(),6))=1,7 ,(MOD(COLUMN(),6)))) so i get 2 3 4 5 6 7 2 3 4 5 6 7 2 etc in row 2 Thanks |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Simplify equation
In B2 enter the below and copy to the right as required...
=MOD(COLUMN(F1),6)+2 If this post helps click Yes --------------- Jacob Skaria "Stephen Christian" wrote: Cna someone simplify this for me please? Starting at b2 =IF((MOD(COLUMN(),6))=0,6,IF((MOD(COLUMN(),6))=1,7 ,(MOD(COLUMN(),6)))) so i get 2 3 4 5 6 7 2 3 4 5 6 7 2 etc in row 2 Thanks |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Simplify equation
Another way (not a formula):
Enter 2 - 7 in B2 through G2. Select B2:G2. Position the cursor over the dot in the lower right corner of G2 (the cursor should change to a plus sign). Hold down the Ctrl key and drag across row 2 as needed. Hope this helps, Hutch "Stephen Christian" wrote: Cna someone simplify this for me please? Starting at b2 =IF((MOD(COLUMN(),6))=0,6,IF((MOD(COLUMN(),6))=1,7 ,(MOD(COLUMN(),6)))) so i get 2 3 4 5 6 7 2 3 4 5 6 7 2 etc in row 2 Thanks |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Simplify equation
=MOD(COLUMN()-2,6)+2
-- David Biddulph "Stephen Christian" wrote in message ... Cna someone simplify this for me please? Starting at b2 =IF((MOD(COLUMN(),6))=0,6,IF((MOD(COLUMN(),6))=1,7 ,(MOD(COLUMN(),6)))) so i get 2 3 4 5 6 7 2 3 4 5 6 7 2 etc in row 2 Thanks |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Simplify equation
Here is another method for you to consider. Put the number 2 in cell B2, put
this formula in C2 and copy it across as far as needed... =IF(B2=7,2,B2+1) -- Rick (MVP - Excel) "Stephen Christian" wrote in message ... Cna someone simplify this for me please? Starting at b2 =IF((MOD(COLUMN(),6))=0,6,IF((MOD(COLUMN(),6))=1,7 ,(MOD(COLUMN(),6)))) so i get 2 3 4 5 6 7 2 3 4 5 6 7 2 etc in row 2 Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I need to simplify this... | Excel Worksheet Functions | |||
Simplify this formula | Excel Worksheet Functions | |||
Simplify Formula | Excel Worksheet Functions | |||
simplify equation | Excel Worksheet Functions | |||
Equation Editor- problem when editing an equation | Excel Discussion (Misc queries) |