Slider

How to Enter a Formula in Excel

Date:2019-7-26 Author:Cordelia

Making a worksheet referring to total amount or commercial profit usually needs some calculations. If it's a complex operation, you may expend much time on it and the result could still be wrong. So how about letting Excel help you out? I'd like to share a quick guide of entering formula in Excel here.

Step 1, open the worksheet, select the F2 cell (in which I want to calculate).

How to Enter a Formula in Excel

Step 2, enter "= B2-C2-D2-E2". Click on any whitespace and the result will show. In a similar way, you can calculate F3, F4, etc.

How to Enter a Formula in Excel

How to Enter a Formula in Excel

Please note that the formula and the number of cell within it should correspond to your actual conditions and needs. For example, if you want to calculate the value in F3, you should enter "= B3-C3-D3-E3".

Copyright Statement: Regarding all of the posts by this website, any copy or use shall get the written permission or authorization from Myofficetricks.

Leave a Reply

Your email address will not be published. Required fields are marked *