training ms excel advanced - Formulas

Hi Kasia

How you put a formula together depends on what you want it to do. For example, if I have typed 10 into cell B5 in a spreadsheet and 10 into cell B6, I can put together a formula that will add or subtract or multiply or divide these numbers.

The formula is always put into it's own cell in the spreadsheet, so let's say I put the formula into cell B7. Here are some examples of formulas I could put into cell B7 (note that a formula always starts with =):

=B5+B6 will add what's in cell B5 to what's in cell B6

=B5-B6 will minus what's in cell B6 from what's in cell B5

=B5*B6 will multiply the two numbers together

=B5/B6 will divide what's in cell B5 by what's in cell B6.


I hope this helps.
Amanda