Understanding formulae supported in Zoho Writer
Zoho Writer supports a wide range of formulas to perform calculations in your documents. You can add formulas in paragraphs, tables, and merge and fillable templates in Zoho Writer.
List of formula categories supported in Zoho Writer:
Array formulas
Zoho Writer allows you to calculate the sum of the products of corresponding entries in two equal-sized arrays or ranges.
Function | Description | Input Value | Result | ||||||||||||
SUMPRODUCT | Multiplies the arrays together and returns the sum of the products. | =SUMPRODUCT(A1:A3,B1:B3) | Sum product = 56 (10+18+28) 2*5 =10 3*6 = 18 4*7 = 28 | ||||||||||||
SUMPRODUCT and IF | Multiplies the arrays together and returns the sum of products if the specified condition is satisfied. | =SUMPRODUCT(if(B2:B4>10,1,0),B2:B4,C2:C4) | Sample table
Result: 135 |
Aggregate formulas
Zoho Writer allows you to perform aggregate operations such as Average, Count, Minimum, Maximum, and Sum.
| Function | Description | Input Value | Result |
| AVERAGE | Calculates the average of the arguments | =AVERAGE(385, 455, 675, 225) | 435 |
| COUNT | Counts the number of items given as arguments | =COUNT(385, 455, 675, 225) | 4 |
| MAX | Maximum value in the given range | =MAX(385, 455, 675, 225) | 675 |
| MIN | Minimum value in the given range | =MIN(385, 455, 675, 225) | 225 |
| SUM | Sum of all the numbers in the range | =SUM(140,456) | 596 |
Conditional logic formulas
Zoho Writer allows you to perform conditional operations based on logic.
| Function | Description | Input Value | Result | |||||||||||||||
| AND | Returns 1 if all arguments are TRUE and 0 if FALSE | =AND(SUM(456,140) > 600) =AND(SUM(456,140)<600) | 1 0 | |||||||||||||||
| IF | Returns value with respect to a specific condition. | =IF((B2>50),20,0) | If B2's value is greater than 50, then 20 will be returned. If B2's value is lesser than 50, then 0 will be returned. | |||||||||||||||
| NOT | Evaluates to 0 if argument is TRUE and evaluates to 1 if argument is FALSE | =NOT(SUM(456,140) > 600)=NOT(SUM(456,140) < 600) | 1 0 | |||||||||||||||
| OR | Evaluates to 1 if at least one of the arguments is TRUE and 0 if both arguments are FALSE | =OR(10>1, 1>10) =OR(10<1, 11<10) | 1 0 | |||||||||||||||
| SUMIF | Returns a sum of all the numbers in a range based on a condition. | =SUMIF(B2:B5, 5, C2:C5) | Sample table
Output: 9,000 |
Date formulas
Zoho Writer allows you to perform operations on the date values in your documents.
Function | Description | Input Value | Result |
DATEDIF | Calculate the difference between two dates in days, months, or years. | =DATEDIF(start_date, end_date, unit) |
Financial formulas
Zoho Writer lets you perform financial calculations in your documents.
Function | Description | Input Value | Result |
NPV | Calculate the present value of a series of cash flows over a period of time, considering a discount rate | =NPV(discount_rate, cashflow1, [cashflow2, ...]) | |
PV | Calculate the present value of a future amount, considering an interest rate and number of periods | =PV(rate, number_of_periods, payment_amount, future_value, end_or_beginning) | |
FV | Calculate the future value of an investment based on a series of periodic payments, considering an interest rate and number of periods | =FV(rate, number_of_periods, payment_amount, present_value, end_or_beginning) |
Math formulas
Zoho Writer allows you to perform advanced mathematical operations such as rounding the number, sum of all the numbers based on a condition, calculating the absolute value of an expression, and more.
| Function | Description | Input Value | Result |
| ABS | Calculates the absolute value of the expression given in parentheses | =ABS(456-596) | 140 |
| INT | Rounds the argument down to the nearest integer | =INT(10.69) | 10 |
| MOD | Returns the remainder of the first argument divided by the second | =MOD(5, 2) | 1 |
| POWER | Returns a number raised to a power | =POWER(2,6) | 64 |
| PRODUCT | Returns the product of the numbers in the given range | =PRODUCT(78,89) | 6942 |
| ROUND | Rounds the argument to the nearest integer | =ROUND(10.69) | 11 |
| SIGN | Returns -1 if the argument evaluates to a number less than 0, 0 if the argument evaluates to zero, 1 if the argument evaluates to a positive number | =SIGN(456-596) =SIGN(656-656) =SIGN(596-456 | -1 0 1 |
| SQRT | Returns the square root of a positive number | =SQRT(25) | 5 |
Related Articles
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:
New to Zoho Writer?
Create. Review. Publish.
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Zoho Marketing Plus?
Everything you need to run your marketing
New to Zoho Marketing Plus?
Everything you need to run your marketing
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.
New to Zoho Survey?
Zoho Sheet Resources
Zoho Forms Resources
New to Zoho Sign?
Zoho Sign Resources
Sign, Paperless!
New to Zoho TeamInbox?
Zoho TeamInbox Resources
New to Zoho ZeptoMail?
Design. Discuss. Deliver.
New to Zoho Workerly?
New to Zoho Recruit?
New to Zoho CRM?
New to Zoho Projects?
New to Zoho Sprints?
New to Zoho Assist?
New to Bigin?
Related Articles
Zoho Writer merge templates: understanding supported merge data sources and its limits
Overview This table provides a consolidated comparison of data source limits in Zoho Writer, organized by app, and includes details on image support, record limits, and subform (table) constraints for the supported data sources Supported Data Sources ...Configure workflow in Zoho Books with Writer's mail merge
With the Zoho Books and Zoho Writer merge integration, you can easily generate customized documents, like shipping labels or invoices, directly from your Zoho Books data. For instance, if you need to create labels for customer orders that include ...How to customize lists in Zoho Writer
Overview Lists are a great way to organize content in your documents. In Zoho Writer, you can do more than just create simple bulleted or numbered lists. You can fully customize them. From setting your preferred list style as default to using images ...How to trigger document merge in Zoho Writer
Overview Zoho Writer document merge can be triggered in four ways: manually, on a schedule, on form submission, or via an incoming webhook. This flexibility allows you to choose the most suitable automation method—whether you want to merge documents ...How to send Writer documents for signing
Overview Zoho Writer is integrated with leading e-signature solutions such as Zoho Sign, Adobe Sign, DocuSign, and SignEasy. This removes the need for scanning software, signature pads, or digital certificates, allowing you to send and collect ...
New to Zoho LandingPage?
Zoho LandingPage Resources