Help with a formula

M

mom2hallie

I'm trying to create a formula to do the following, can someone please help??

I want to take the sum of B25 & B26 and divide that sum by the sum of B40 &
B41 divided by 2.
 
L

Lars-Åke Aspelin

I'm trying to create a formula to do the following, can someone please help??

I want to take the sum of B25 & B26 and divide that sum by the sum of B40 &
B41 divided by 2.


Try one of these, depending on if it is the sum of B40 and B41 that
should be divided by 2 or it is B41 divided by 2 that should be added
to B40.

=(B25+B26)/((B40+B41)/2)
....(the sum of B40 & B41) divided by 2....

=(B25+B26)/(B40+B41/2)
....the sum of B40 & (B41 divided by 2)...

Hope this helps / Lars-Åke
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top