Categories
Excel 2013

How to Use Parentheses in Excel Calculations

When you are performing calculations or doing just anything in a formula in Excel, what resides inside your parentheses will the first thing evaluated.

If there are more than one set of parentheses residing in the same formula, they will be evaluated inside-out, which means that the content residing in the innermost set of parentheses will be evaluated first and then the content in the next set of parentheses, until the last set has been reached.

Parentheses Example

You can use parentheses any time you need to group together a set of numbers, formulas or functions, including when you are using comparison operators. The only thing that will change is that your formulas will look more complex.

You can use parentheses with functions as well. Of course, it starts to get a bit confusing the more parentheses you use and the more complex it becomes. Just remember how Excel calculates: inside-out – and keep that in your mind as you continue to build the correct structure.

Categories
Subscribers Excel 2013

Subscribers: How to Copy a Worksheet in Excel

I am certain that you, like me, have needed to copy an Excel worksheet.  One of the reasons I have a need to copy a worksheet is that I have worked hard to have it formatted and set up exactly the way I like and I want to use it for another worksheet. The good […]

This content is exclusively for Carol's Corner Office Subscribers.
If you are a Subscriber please Log In below.

Not a Subscriber? Please Consider becoming one today for ONLY $20/yr. Your subscription supports the site and gives you access to many exclusive resources not available to non-subscribers, as well as substantial discounts on Carol's Microsoft Office books.

  • Exclusive in-depth content ONLY for subscribers. Use Microsoft Office like a Pro!
  • Large color screenshots illustrate the instructions so following along is easy!
  • Email notification of each new exclusive post for subscribers!
  • Exclusive discounts on Office books and other products!