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

Advertisements

Author: summer512blog

I am an accountant. I will post some article about EXCEL, ACCOUNTING and PHOTOGRAPHY.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s