-
Recent Posts
Archives
Categories
Meta
-
Join 2 other subscribers
Tag Archives: Logic
Good design – introduction
Spreadsheets mean that things can be tried out very quickly; and changes and improvements made (almost) immediately. However, in a ‘mature’ spreadsheet, the only changes should be to the data, with the functionality locked down and well documented. There are … Continue reading
Posted in Uncategorized
Tagged Development, Formulae, Functions, Good design, Logic, Robustness, Security
Leave a comment
IF statements – multiple levels
IF statements really bring power to your spreadsheets. And multiple IFs, even more so. Before 2007, the limit was 7 nested IFs in one statement. My advice was to avoid anything more than 3, because it would make your head … Continue reading
Conditional Formatting: highlight items automatically
Conditional Formatting changes the font, border or colour of a cell depending on the criteria you have chosen. For example you might set a cell to go red if it went over 32 or green if a certain date is … Continue reading
IF statements – very useful, but take care!
IF statements really bring power to your spreadsheets. And multiple IFs, even more so. There are two main problems: Firstly, they can get very difficult to understand, particularly if you are working on someone else’s spreadsheet, or even your own … Continue reading
Spreadsheet Expert Blog 