how can i copy formula every two rows

lets say

=if(E9<=$E$4,$E$4,E9)
BLANK CELL
BLANK CEEL
=IF(E12<=$E$4,$E$4,E12)
BLANK CELL
BLANK CELL

AND SO ON

THANKS A LOT

Select the cell with formula and the two blanks cells below
Now drag the fill handle (solid square in lower right corner of selection
This puts a formula in every THIRD cell which seems to be what you want
notwithstanding the subject text.
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"andresg1975" wrote in message
...
how can i copy formula every two rows

lets say

=if(E9<=$E$4,$E$4,E9)
BLANK CELL
BLANK CEEL
=IF(E12<=$E$4,$E$4,E12)
BLANK CELL
BLANK CELL

AND SO ON

THANKS A LOT

F9 =IF(MOD(ROW(),3)=0,MAX($E$4,E9),"")

Copy down as fas as need it


"andresg1975" wrote:

how can i copy formula every two rows

lets say

=if(E9<=$E$4,$E$4,E9)
BLANK CELL
BLANK CEEL
=IF(E12<=$E$4,$E$4,E12)
BLANK CELL
BLANK CELL

AND SO ON

THANKS A LOT