LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 55
Default Help with worksheet function

I am trying to acheive the following formula: starting with 420 for the first
seven cells I want to deduct 14 at the next set of seven cells down as
follows:
J3=420
J4=420
J5=420
J6=420
J7=420
J8=420
J9=420
J10 to J17=406
J18 to J24=392
J25 to J32=378
And so on all the way down.
Please help. Thanks!
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Worksheet Function JeremyH1982 Excel Discussion (Misc queries) 4 May 9th 07 09:31 PM
Which worksheet function would I use? plunk25 Excel Worksheet Functions 4 October 13th 06 06:17 PM
Worksheet name in function Harv Excel Worksheet Functions 1 November 7th 05 09:34 PM
Reference the worksheet from a multiple worksheet range function ( DBickel Excel Worksheet Functions 1 May 28th 05 03:49 AM
Can the offset worksheet function reference another worksheet AlistairJ Excel Worksheet Functions 2 May 9th 05 06:18 PM


All times are GMT +1. The time now is 02:33 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"