MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Excel 2019: Match the Parentheses


August 26, 2019 - 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


Bill Jelen is the author / co-author of
MrExcel LX – The Holy Grail of Excel Tips

A book for people who use Excel 40+ hours per week. Illustrated in full color.