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 |
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) |