| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how would I write a formula
how would I write a formula for cell B8 that divides cell D5 by the sum of
cells N10 through N13, write the formula so that when it is copied to cell C8 and D8, cell D5 remains absolute? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how would I write a formula
Homework?
-- Don Guillett Microsoft MVP Excel SalesAid Software "Lisa" wrote in message ... how would I write a formula for cell B8 that divides cell D5 by the sum of cells N10 through N13, write the formula so that when it is copied to cell C8 and D8, cell D5 remains absolute? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how would I write a formula
yeah
"Don Guillett" wrote: Homework? -- Don Guillett Microsoft MVP Excel SalesAid Software "Lisa" wrote in message ... how would I write a formula for cell B8 that divides cell D5 by the sum of cells N10 through N13, write the formula so that when it is copied to cell C8 and D8, cell D5 remains absolute? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how would I write a formula
Lisa
The purpose of home work is to learn not to provide the answer. Tell us what you have tried, what worked and what did not work. Tell us where you have looked and what you do or do not understand. Show us some effort and we will direct you in this LEARNING process. Help us help you! Mike Rogers "Lisa" wrote: yeah "Don Guillett" wrote: Homework? -- Don Guillett Microsoft MVP Excel SalesAid Software "Lisa" wrote in message ... how would I write a formula for cell B8 that divides cell D5 by the sum of cells N10 through N13, write the formula so that when it is copied to cell C8 and D8, cell D5 remains absolute? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how would I write a formula
I'm with you on this
"Mike Rogers" wrote: Lisa The purpose of home work is to learn not to provide the answer. Tell us what you have tried, what worked and what did not work. Tell us where you have looked and what you do or do not understand. Show us some effort and we will direct you in this LEARNING process. Help us help you! Mike Rogers "Lisa" wrote: yeah "Don Guillett" wrote: Homework? -- Don Guillett Microsoft MVP Excel SalesAid Software "Lisa" wrote in message ... how would I write a formula for cell B8 that divides cell D5 by the sum of cells N10 through N13, write the formula so that when it is copied to cell C8 and D8, cell D5 remains absolute? |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how would I write a formula
On 9 Feb, 22:40, Jeremy <jeremiah.a.reynolds @ gmail.com wrote:
I'm with you on this "Mike Rogers" wrote: Lisa The purpose of home work is to learn not to provide the answer. Tell us what you have tried, what worked and what did not work. Tell us where you have looked and what you do or do not understand. Show us some effort and we will direct you in this LEARNING process. Help us help you! Mike Rogers "Lisa" wrote: yeah "Don Guillett" wrote: Homework? -- Don Guillett Microsoft MVP Excel SalesAid Software "Lisa" wrote in message ... how would I write a formula for cell B8 that divides cell D5 by the sum of cells N10 through N13, write the formula so that when it is copied to cell C8 and D8, cell D5 remains absolute? I also agree with the guys here. I posted my response before Id seen that it was definitely homework. Whilst Im glad I helped I would definitely recommend that rather than just followin g the instructions I posted you try and understand WHY it works. Regards, Matt Richardson http://teachr.blogspot.com |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how would I write a formula
On 9 Feb, 16:14, Lisa wrote:
how would I write a formula for cell B8 that divides cell D5 by the sum of cells N10 through N13, write the formula so that when it is copied to cell C8 and D8, cell D5 remains absolute? In B8 type:- =$D$5/SUM(N10:N13) The $ (Dollar) symbol before the column and row parts of the cell reference D5 ensure that that remains absolute as you want. N10:N13 will remain relative. Hope this helps, Matt Richardson http://teachr.blogspot.com |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how would I write a formula
thanks matt, I put a hyphen where the colon should of been and i didn't place
a dollar sign in front of the five...thanks for your help "Matt Richardson" wrote: On 9 Feb, 16:14, Lisa wrote: how would I write a formula for cell B8 that divides cell D5 by the sum of cells N10 through N13, write the formula so that when it is copied to cell C8 and D8, cell D5 remains absolute? In B8 type:- =$D$5/SUM(N10:N13) The $ (Dollar) symbol before the column and row parts of the cell reference D5 ensure that that remains absolute as you want. N10:N13 will remain relative. Hope this helps, Matt Richardson http://teachr.blogspot.com |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to I 'write-through' a formula | New Users to Excel | |||
| What is the best way to Write this Formula | Excel Discussion (Misc queries) | |||
| how to write a formula | New Users to Excel | |||
| write a formula | Excel Worksheet Functions | |||
| how do i write a formula and keep in in formula form, so it DOESN. | Excel Discussion (Misc queries) | |||
Hybrid Mode
