how to check function result in EXCEL

If there are two or more function in one formula, then you can check the outcome of one function using F9

For example: select substitute(“excelhome”,”e”,) and press F9, then it will show “xclhom” which is the outcome of the substitute function. if you select A2, then it will show 3 which is the outcome of the whole formula.

Capture.PNG