Not sure if this makes sense. Let's say I wanted to the user to just enter "amount * 7" in a cell with amount being a named range such that other cells can incorporate this into their existing formula,
e.g. I've tried "=B3+INDIRECT(A1)" which obviously doesn't work, but ideally if B3 is 5 and amount is 5, then it would calculate as 40. I'm really just wanting to be able to write custom formulas into a cell and have them update a whole bunch of cells. Or is there a better way to do this that I'm not thinking?