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
How Tos and Q&As Archives - Oz du Soleil

Formula Triggers & Absurd Results?

QUESTION Rowka asked “how do I make this formula smaller?” =IF(AND(E11>=K7,E11=K7,F11=K7,G11” jazz. Our trigger will be: If there are fewer than 3 readings, then don’t calculate anything. COUNTA is the function that counts non-empty cells....
#4 of the Top 5 Functions: IFERROR

#4 of the Top 5 Functions: IFERROR

#4 in the List of Top 5 Functions: IFERROR   Q:  What do an acrobat and Excel’s IFERROR function have in common? A:  An acrobat and an Excel user who employs IFERROR are both expressing: it’s risky but I know what I’m doing and I do it with elegance...