What we’re going to do here is have a look at some of the formulas already in place in your templates to get familiar with their structure, and then put together a simple formula by combining functions through the ribbon options. Let’s get going.
1 Take a look
Open the Mortgage Loan Calculator template, then tap a formula cell. Notice the colour of the selected cells and how it matches up to parts of the formula at the top.
2 Close it down
You’ll also see that brackets, operators and functions (like IF or SUM) are just plain text. Tap the red cross to the right to cancel (or the tick saves any changes).
3 Start a formula
Find an empty cell up at the top-left and tap it. Now tap the ‘fx’ button to the left of the formula bar – this drops in an ‘=’ and brings up the function options below.
4 Get info
Scroll past your recent functions at the top
to see the full list below. Tap the ‘i’ beside a function to see what it does – this is a great way to learn new functions.
5 Add a function
Tap a function to add it and you’ll see a formula template ready for you. Tap the first argument to begin. Since we’ve gone for an IF, we’ll start with a logic test.
6 Select and type
If you now tap other cells, their references will be added to your formula. You can use the keyboard switcher above your Delete key to input characters, numbers and operators.
7 Quick add
If you want to input another function inside your formula, start typing it and you can quickly add it from the drop-down that appears. Finish up your formula and tap the tick.
8 Ribbon tools
You can also find functions by tapping the categories that appear in your Formulas ribbon at the top of the interface. Quick sums and recent functions are over to the left.
9 Convert to value
To the right of the Formulas ribbon, past the More category (‘…’), there’s a calculator icon. Tap that with a formula selected and you’ll convert it into a regular value.
Click Image to Enlarge: