| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Help with worksheet function
Try...
J3, copied down: =420-INT((ROWS(J$3:J3)-1)/7)*14 -- Domenic Microsoft Excel MVP www.xl-central.com Your Quick Reference to Excel Solutions In article , Josh W wrote: 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! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Help with worksheet function
J10:J17 is actually 8 cells but I assume that to be a typo...
In cell J10 add the formula =J3-14 copy that down and it should work... No need to be any fancier than that... -- HTH... Jim Thomlinson "Josh W" wrote: 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! |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Help with worksheet function
Thanks! Learning new things all the time.
"Domenic" wrote: Try... J3, copied down: =420-INT((ROWS(J$3:J3)-1)/7)*14 -- Domenic Microsoft Excel MVP www.xl-central.com Your Quick Reference to Excel Solutions In article , Josh W wrote: 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! |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Help with worksheet function
Works perfectly Jim. I actually do like the fancy ones sometimes just for the
sake of learning. "Jim Thomlinson" wrote: J10:J17 is actually 8 cells but I assume that to be a typo... In cell J10 add the formula =J3-14 copy that down and it should work... No need to be any fancier than that... -- HTH... Jim Thomlinson "Josh W" wrote: 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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Worksheet Function | Excel Discussion (Misc queries) | |||
| Which worksheet function would I use? | Excel Worksheet Functions | |||
| Worksheet name in function | Excel Worksheet Functions | |||
| Reference the worksheet from a multiple worksheet range function ( | Excel Worksheet Functions | |||
| Can the offset worksheet function reference another worksheet | Excel Worksheet Functions | |||
Linear Mode
