MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Excel 2020: Match the Parentheses


August 31, 2020 - by Bill Jelen

Excel Match the Parentheses. Photo Credit: Liao Je Wei at Unsplash.com

Excel cycles through a variety of colors for each new level of parentheses. While Excel reuses the colors, it uses black only for the opening parenthesis and for the matching closing parenthesis. As you are finishing the formula below, just keep typing closing parentheses until you type a black parenthesis.


Excel uses 9 different colors for parentheses. While the magenta color is used every 8th time, the color black is reserved for the first parenthesis and the matching closing parenthesis.

Tip

In Office 365, you could use the following formula to solve the discount presented above:

=IFS(B10>500000,20%,B10>250000,15%,B10>100000,10%,B10>50000,5%,B10>10000,1%,TRUE,0)

Title Photo: Liao Je Wei at Unsplash.com


This article is an excerpt from MrExcel 2020 - Seeing Excel Clearly.


Bill Jelen is the author / co-author of
MrExcel 2020 - Seeing Excel Clearly

This is a 4th edition of MrExcel LX. Updates for 2020 include: Ask a question about your data, XLOOKUP, Power Query's Data Profiling tools, How Geography Data Types decide which Madison, A SEQUENCE example for descending 52 weeks, Exchange Rates support in Stock Data Types, How to collapse the Search box, How to leave effective feedback for Microsoft, How to post your worksheet to the MrExcel Board using XL2BB.