Excel 2020: Match the Parentheses
August 31, 2020 - by Bill Jelen
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.
In Office 365, you could use the following formula to solve the discount presented above:
Title Photo: Liao Je Wei at Unsplash.com
This article is an excerpt from MrExcel 2020 - Seeing Excel Clearly.