Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #4  
Old 06-14-2013, 04:22 PM
BobBridges's Avatar
BobBridges BobBridges is offline Repeat formula 5 times and repeat? Windows 7 64bit Repeat formula 5 times and repeat? Office 2010 32bit
Expert
 
Join Date: May 2013
Location: USA
Posts: 700
BobBridges has a spectacular aura aboutBobBridges has a spectacular aura about
Default

Well, the simple way to do it (it seems to me) would be in four steps:

1) In B1: =A1/2
2) In B2: =A2/2+B1
3) Copy the formula in B2 to B3:B5

Now you have the first block of five. You don't have to repeat all three steps throughout the rest of the worksheet; instead, just do this:

4) Copy the block B1:B5 to B6:B20 (or whatever).
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Bibliography Hyphen for repeat author grantgibson45 Word 3 02-25-2013 04:32 AM
Repeat formula 5 times and repeat? Text will repeat in the fields ypurcaro Word 1 02-07-2013 01:46 AM
Repeat formula 5 times and repeat? Repeat Spell check in a doc that has already been checked mawigfie Word 1 08-22-2012 01:16 PM
Repeat formula 5 times and repeat? how to repeat row in header gsrikanth Excel 10 06-28-2012 02:31 AM
i want to insert page break without repeat row on top gsrikanth Excel 0 05-24-2012 04:07 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:00 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft