2 ms·
Would it not be tedious to mark each cell as constant or input parameter? Perhaps it would be preferable to just ask the fine user when copying a cell with a fo
by dotancohen 5y ago
Would it not be tedious to mark each cell as constant or input parameter? Perhaps it would be preferable to just ask the fine user when copying a cell with a formula?
- magicalhippo 5y agoI almost always have <5 such cells in a sheet, typically just 2-3, so I don't think it would be that tedious given you only have to set that once. In comparison, I often have formulas with over 20 cell references and/or multiple formulas referencing the "constants", so getting asked for each would indeed be tedious.