We can evaluate a formula in Excel using the Evaluate Formula option in the Formulas tab
Parts of an formula can be evaluated using the F9 key
The part of the nested formula that needs to be evaluated has to be selected before using this option
Note
- If used on a simple formula the formula is going to be replaced with its Evaluated value
- In a nested formula after evaluating a part if we press the Enter key that part to be replaced with its Evaluated value