Provides best practice guidelines that should be considered when building spreadsheets so as to minimise the risk of errors occurring, and improve reliability. usability, robustness and accuracy.
Essential reading for anyone involved in building financial models!
Counting weekdays - Is it possible to figure out how many occurrences of a certain weekday there are in a specific month? I need to figure out how many Thursdays in each month of the year.
Yes, but the formula has 6 IF functions
in it. Assume cell A2 has the date of the first day of
the month involved, for example 1/2/08 for February 2008 ...
One technique
to speed up macros is to turn off Excel's automatic calculation
at the beginning of your macro and then turn it back on
at the end of your code ...
Using the AND + OR functions - I struggle to use the AND and OR functions. Could you explain how they should be used?
AND
and OR functions are typically used with the IF function.
They allow you to examine multiple logical tests in a
single function rather than use numerous IF functions
to achieve the same result ...
