Excel Expert strives to make all our spreadsheets “robust”. But what does this mean? The answer is simple: it means that all the equations within the workbook will continue to work properly, even when large sweeping changes are made to the workbook, unexpected data is encountered, columns are moved, etc. Think of it as “immunity […]

Bill’s Rule for Equations : Never use numbers in any equation or function!  Instead, use a cell reference which points to a cell which contains the value you need.  This allows you to change that value without editing any equations. Numbers used in equations make the equation more difficult to understand.  The reader may ask […]