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 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
      Redefine the way you work
      with Zoho Workplace

        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 Sign now offers specialized one-on-one training for both administrators and developers.

            BOOK A SESSION





                        Still can't find what you're looking for?

                        Write to us:  support@zohoforms.com


                              



                            



                          Manage your brands on social media




                              Zoho Marketing Automation

                                Zoho Sheet Resources

                                 




                                    Zoho Forms Resources


                                      Secure your business
                                      communication with Zoho Mail


                                      Mail on the move with
                                      Zoho Mail mobile application

                                        Stay on top of your schedule
                                        at all times


                                        Carry your calendar with you
                                        Anytime, anywhere




                                              Zoho Sign Resources

                                                Sign, Paperless!

                                                Sign and send business documents on the go!

                                                Get Started Now




                                                        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 with others: Go to ••• > Add People in the listing page or spreadsheet editor. Enter the email address of the desired people you want to share the file with, set the access permission, and tap Share. If you are using Zoho ...
                                                                                          • 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 ...
                                                                                          • Use Functions and Formulas

                                                                                            To use a predefined or custom function in your spreadsheet: Double-tap on the cell where you want the result to be displayed. Tap the = sign, then type the desired function's name. While typing, you can also choose from the function suggestions shown ...
                                                                                          • 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 ...
                                                                                          Wherever you are is as good as
                                                                                          your workplace

                                                                                            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