Insert functions and formulas | Zoho Sheet for iOS

Use functions and formulas

To use a predefined or custom function in your spreadsheet:
  1. Double tap on the cell where you want the result to be displayed.
  2. Start with an equal sign (=), then type the desired function's name. While typing, you can also choose from the function suggestions shown above the keypad.
  3. In the function syntax that appears, enter the input values or choose the input cell ranges and tap  to get the result.



Notes:
  • You can also use the Insert > Function option to add a function.
  • You can refer to the functions guide by tapping the fx icon.
  • To refresh the functions in your spreadsheet, you can use the Recalculate option under the Function menu.
  • You can also use the quick functions displayed on the top bar once a cell range containing numerical values is selected.

    Zoho DataPrep Personalized Demo

    If you'd like a personalized walk-through of our data preparation tool, please request a demo and we'll be happy to show you how to get the best out of Zoho DataPrep.

    Zoho CRM Training

      Create, share, and deliver

      beautiful slides from anywhere.

      Get Started Now





              Zoho CRM Training Programs

              Learn how to use the best tools for sales force automation and better customer engagement from Zoho's implementation specialists.

              Zoho CRM Training

                  Zoho SalesIQ Resources



                      Zoho TeamInbox Resources




                                Zoho DataPrep Resources

                                  Zoho DataPrep Demo

                                  Get a personalized demo or POC

                                  REGISTER NOW


                                    Design. Discuss. Deliver.

                                    Create visually engaging stories with Zoho Show.

                                    Get Started Now











                                                          • Related Articles

                                                          • Share spreadsheet for collaboration

                                                            To share a spreadsheet file: Go to ... > Add People if you are on the listing page. Go to ... > Add People or  > + if you are on the spreadsheet editor. Enter the email address of the desired people you want to share the file with, set the access ...
                                                          • Export or download a spreadsheet

                                                            To download or export a spreadsheet: Go to ... > Download As in the editor. Choose the file format in which you want to export the spreadsheet. Select the location to save or send the spreadsheet. Note: To download from the file listing screen, use ...
                                                          • Open a spreadsheet from Dropbox/Box

                                                            To open a spreadsheet from Dropbox, or Box: Go to Places using the option in the bottom bar of the file listing page. Choose the desired place from which you wish to open the file. For Dropbox and Box, you will need to authenticate your account. Pick ...
                                                          • Insert a new chart into a spreadsheet

                                                            To create a new chart: Select the source data for the desired chart. Go to  and choose Chart under the Insert menu. Tap on the desired chart type from the list of chart types displayed. Once the chart is inserted into the spreadsheet, you can start ...
                                                          • Create a new blank spreadsheet

                                                            To create a new blank spreadsheet, open the app and follow these steps: In the listing page, tap the + icon in the bottom bar. Choose the Blank Spreadsheet option from the listed gallery.

                                                          Resources

                                                          Videos

                                                          Watch comprehensive videos on features and other important topics that will help you master Zoho CRM.



                                                          eBooks

                                                          Download free eBooks and access a range of topics to get deeper insight on successfully using Zoho CRM.



                                                          Webinars

                                                          Sign up for our webinars and learn the Zoho CRM basics, from customization to sales force automation and more.



                                                          CRM Tips

                                                          Make the most of Zoho CRM with these useful tips.



                                                            Zoho Show Resources