Home |
Search |
Today's Posts |
#2
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
The SUM(H24:H25) if that is what you meant is a function
and sums the cells in the range. The rest of the parens (parentheses) can be used to change the order of operations. Since multiplication and division take place before additions and subtractions they don't really matter here. The formulas are like what you use in algebra. See your Excel Help for "order of operation" or specifically "about calculation operators". Also look at "functions" in your Excel help. --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "ann" wrote in message ... I have a formula: =(h24*j24)+(h25*j25)/sum(h24:25) But I have no idea how many parentheses I am suppose to place around the formula or what additional ones I need other than the one that surround the indivudual formula. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I copy only cells with formulas in another row? | Excel Worksheet Functions | |||
How to change column letters to correct ones in many formulas automatically? | Links and Linking in Excel | |||
How to change column letters to correct ones in many formulas automatically? | Excel Worksheet Functions | |||
how can i get formulas in excel to copy and paste? | Excel Worksheet Functions | |||
calculating formulas for all workbooks in a folder | Excel Worksheet Functions |