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.