Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default 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.
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 913
Default 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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 08:03 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"