|
|
|
Sample formulas |
 | The formulas below use the example worksheet data. If you want to practice, start a new worksheet and enter the same values into cells A1 and A2. Type the formulas, shown below, into cell A3. |
 | | | |
=A1/2+100 | divide value in A1(10) by 2, then add 100 | Answer: | 105 |
=A1+4*5 | multiply 4 x 5, then add to value in A1(10) | Answer: | 30 |
=(A1-2)*5 | subtract 2 from value in A1(10), multiply by 5 | Answer: | 40 |
| | | |