ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Help with a formula (https://www.excelbanter.com/excel-worksheet-functions/253005-help-formula.html)

mom2hallie

Help with a formula
 
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.

Lars-Åke Aspelin[_2_]

Help with a formula
 
On Mon, 11 Jan 2010 09:23:01 -0800, mom2hallie
wrote:

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




All times are GMT +1. The time now is 10:01 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com