Warning: mysql_real_escape_string(): Access denied for user 'dragon99'@'localhost' (using password: NO) in /home3/dragon99/public_html/wp-content/plugins/easy-contact-forms/easy-contact-forms-database.php on line 152

Warning: mysql_real_escape_string(): A link to the server could not be established in /home3/dragon99/public_html/wp-content/plugins/easy-contact-forms/easy-contact-forms-database.php on line 152
Troubleshooting Complicated Formulae - Oz du Soleil

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.