View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
andresg1975 andresg1975 is offline
external usenet poster
 
Posts: 60
Default COPY FORMULA EVERY TWO ROWS

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