|
|
|
|
|
|
by etskinner
1777 days ago
|
|
|
> (i.e. NEVER EVER hard code anything into a cell) Define 'hard code'... Is "=MONTH(A1)+2" no good when I'm trying to write a row of every other month? Is it bad to say '=IF(A1="USA",TRUE,FALSE)' when I'm trying to see what customers belong to our USA office? I have this problem with coding too. In my mind, it's okay to hard code things, since you can always debug and abstract them later. Excel's "Evaluate Formula" and "Trace Precedents" are both pretty handy tools. |
|
|