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 above the keypad.
In the function syntax that appears, enter the input values or choose the input cell ranges and tap ✓ to get the result.
You can also use the Insert > Function option to add a function.
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 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 Workerly Home
- Forums
- Connect With Us:
- Zoho Recruit Home
- Forums
- Connect With Us:
Create. Review. Publish.
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.
Zoho Sheet Resources
Zoho Forms Resources
Zoho Sign Resources
Sign, Paperless!
Zoho TeamInbox Resources
Design. Discuss. Deliver.
Related Articles
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. Start with an equal sign (=), then type the desired function's name. While typing, you can also choose from the function ...Insert functions and formulas
To insert functions or formulas: Enter = in any desired cell and type in the formula or function. Alternatively, go to the menu bar and tap Insert. Under the Insert menu, choose Function. Zoho Sheet supports 400+ functions and you can choose the ...Wildcard characters in formulas
Wildcard characters help you search for terms with iterations of single or multiple characters. Wildcards can be used in formulas such as XLOOKUP to include relevant terms in match. Below is the list of wildcard characters and their use cases: ...Custom functions in Zoho Sheet
Though Zoho Sheet supports around 400 functions by default, for simple and complex calculations, we understand that our users have their own business logic that requires personalized functions. Additionally, Zoho Sheet also allows you to bring in ...Regular expressions in formulas
Regular expressions are patterns that can be used to include single or multiple characters in search. While Wildcards can be used for simple searches, regular expressions can be applied for advanced use cases. The patterns used in regular ...