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.

    Access your files securely from anywhere

      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





                          Quick Links Workflow Automation Data Collection
                          Web Forms Enterprise Begin Data Collection
                          Interactive Forms Workplace Data Collection App
                          CRM Forms Customer Service Accessible Forms
                          Digital Forms Marketing Forms for Small Business
                          HTML Forms Education Forms for Enterprise
                          Contact Forms E-commerce Forms for any business
                          Lead Generation Forms Healthcare Forms for Startups
                          Wordpress Forms Customer onboarding Order Forms for Small Business
                          No Code Forms Construction RSVP tool for holidays
                          Free Forms Travel
                          Prefill Forms Non-Profit

                          Intake Forms Legal
                          Mobile App
                          Form Designer HR
                          Mobile Forms
                          Card Forms Food Offline Forms
                          Assign Forms Photography
                          Mobile Forms Features
                          Translate Forms Real Estate Kiosk in Mobile Forms
                          Electronic Forms

                          Notification Emails for Forms Alternatives Security & Compliance
                          Holiday Forms Google Forms alternative  GDPR
                          Form to PDF Jotform alternative HIPAA Forms
                          Email Forms
                          Encrypted Forms
                          Embeddable Forms
                          Secure Forms
                          Drag and Drop form builder
                          WCAG


                                            You are currently viewing the help pages of Qntrl’s earlier version. Click here to view our latest version—Qntrl 3.0's help articles.




                                                Manage your brands on social media

                                                  Zoho Desk Resources

                                                  • Desk Community Learning Series


                                                  • Digest


                                                  • Functions


                                                  • Meetups


                                                  • Kbase


                                                  • Resources


                                                  • Glossary


                                                  • Desk Marketplace


                                                  • MVP Corner


                                                  • Word of the Day


                                                    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 ...
                                                                                                              • 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 ...
                                                                                                              • 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 ...
                                                                                                                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