LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #2   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 903
Default WHAT ARE PARENTHESIS IN FORMULAS?

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I copy only cells with formulas in another row? Soozy Excel Worksheet Functions 2 October 21st 05 08:02 PM
How to change column letters to correct ones in many formulas automatically? Dmitry Kopnichev Links and Linking in Excel 7 October 13th 05 09:52 PM
How to change column letters to correct ones in many formulas automatically? Dmitry Kopnichev Excel Worksheet Functions 7 October 13th 05 09:52 PM
how can i get formulas in excel to copy and paste? bman Excel Worksheet Functions 1 October 3rd 05 04:15 PM
calculating formulas for all workbooks in a folder Chad Excel Worksheet Functions 3 November 13th 04 05:22 PM


All times are GMT +1. The time now is 12:25 AM.

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"