Create Formula in Excel

image_pdf

To create Formula in excel is very easy.

Let’s start with formula for summing two values

begin

1. Type the formula in cell C6.

 2. Press ENTER to display the formula result.

 3. Any time you click in cell C6, the formula appears in the formula bar.

The two CDs purchased in February cost $12.99 and $16.99. The total of these two values is the CD expense for the month.

You can add these values in Excel by typing a simple formula into cell C6.

Excel formulas always begin with an equal sign (=). Here's the formula typed into cell C6 to add 12.99 and 16.99:

=12.99+16.99

The plus sign (+) is a math operator that tells Excel to add the values. Check for other Math Operator.

If you wonder later on how you got this result, the formula is visible in the formula bar  near the top of the worksheet whenever you click in cell C6 again.

951 total views, 1 views today

Leave a Reply

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

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>