Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|