From the course: Excel 2016 Essential Training

Unlock the full course today

Join today to access over 22,400 courses taught by industry experts or purchase this course individually.

Creating simple formulas

Creating simple formulas

From the course: Excel 2016 Essential Training

Start my 1-month free trial

Creating simple formulas

- For many Excel users, writing formulas, creating formulas, one of the most common things they do. In this worksheet called Formulas, in the workbook Creating Formulas and Functions, we need some formulas in row 4, also over in column H and column I. Formulas many times are straightforward, simple, easy to use, but they start with a different concept than you might be familiar with. In cell B4, we want to substract the two numbers above it. Now, if that's all you were told and you never worked with Excel, you might be typing something like: 120 minus 100. But in Excel, typically we write formulas based on location, and that implies content. One way to state this is we're about to say that cell B4 equals whatever is in B2 minus whatever is in B3. And we don't need to type B4, we're already at that cell, we type =, formulas in excel begin with =. Now there are a few different ways to enter formulas. The most common way, at least initially, is to type addresses. B2. And what we're…

Contents