how would I write a formula

[Lisa]

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?

 

[Don Guillett]

Homework?

 

[Lisa]

yeah

Homework?

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
(e-mail address removed)

 

[Matt Richardson]

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

 

[Mike Rogers]

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]

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

 

[Jeremy]

I'm with you on this

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

 

[Matt Richardson]

I'm with you on this

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