Help with a formula

  • Thread starter Thread starter mom2hallie
  • Start date Start date
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.
 
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.
Click to expand...


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
 
Back
Top