If you use other software like Microsoft Excel or Google Sheets to work on your spreadsheets, you’ll be pleased to know that you can use formulas and perform mathematical operations in a very similar way with ease. Once you get the hang of it, working with formulas in Numbers is such a breeze and can greatly improve your spreadsheets.

However, depending on the function you chose, the calculations could get complex. What we described here is just a very basic example of what you could do with functions in Numbers. So, you don’t have to redo all these steps if you just want to change the inputs. Now you have learned how you can access and use formulas in your spreadsheets using the Numbers app on an iPad or iPhone.Įvery time you change the values in any of the cells you chose for a calculation, the results will be automatically updated in their corresponding cells. As you can see here, the calculated result will show up in the cell you selected in Step 4.When you’re ready to obtain the result, tap on the green check mark located just above the keyboard. Now, you can select the cells to perform the mathematical function.However, for this instance, we’ll choose “SUM”. Here, you can choose any of the functions.Next, tap on the “fx” option as shown in the screenshot below to the access various mathematical functions.Now, tap on the “=” icon located right above the keyboard to access formulas. Here, enter the values in their respective cells and select the cell where you want the calculated result.Now, choose the “Blank” template for a start.If you haven’t created any spreadsheets with Numbers before, tap on the “+” icon located at the top-right corner of the screen.Open the “Numbers” app on your iPhone or iPad.Now, without further ado, let’s open a spreadsheet and start using formulas. How to Use Formulas in Numbers Spreadsheets on iPhone & iPadīefore you go ahead with the procedure, you’ll need to download and install Numbers app from the App Store. You might be familiar with the Numbers app on Mac, but if you have no idea how to access and use formulas on your iOS or iPadOS device, we’ll walk you through the necessary steps to learn how to use formulas in Numbers spreadsheets on both the iPhone and iPad. It also keeps the results updated as you change the values in the respective cells. In Numbers, formulas provide calculated values based on the contents of the cells you select in your spreadsheet. This eliminates the need to use a calculator for doing your math. Numbers, just like any other spreadsheet application features built-in functions and formulas to make calculations a lot easier.

Osx spreadsheet