Why should a rate or assumption never be typed directly inside multiple formulas?
- A It cannot be updated reliably and creates inconsistency
- B It causes a circular reference
- C Excel does not allow constants in formulas
- D It slows recalculation
Answer
It cannot be updated reliably and creates inconsistency
Put the value in one labelled cell and reference it. Named ranges make the reference self-documenting as well.





