Have you written a complex formula or had to understand a long formula that someone else wrote? It can become a jungle of parentheses and commas. One simple tip:
Use ALT+ENTER in the Formula Bar to Make Troubleshooting and Validation easier
Here’s a formula I wrote to calculate savings based on many variables (click on the images for a larger view):
ALT+ENTER used in key places shows that this formula has 4 distinct areas that can be reviewed in logical bite-sized pieces.
