Kasia has attended:
No courses
Formulas
How to build the formulas, transfer them over
RE: 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
