- Worldstart's Tech Tips And Computer Help - http://www.worldstart.com -

When to Use What

When to Use What

Do you find that referring to cell ranges in Excel formulas is a difficult task? Confused by the use of the colons, commas and spaces?

These characters are definitely a part of formula writing and if they aren’t used correctly, you’ll probably run into some problems.

So, here’s the information that can make formula writing with ranges a much more manageable task.

I’ve shown you the results of the named ranges as highlighted cells, but obviously, when you actually go to use them in formulas, it’s the values within those cells that are put to work.

Now, go forward and confidently name ranges to your heart’s content!

~ April