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
FAQ: Zoho Writer Desktop App
General Q1. Is the desktop app free? Yes. The app itself is free to download and use. You only need a Zoho account if you want to sync, store, and share files in the cloud. Q2. How is the desktop app different from the web version? The desktop app ...How to Use the Tools in Zoho Writer
Overview This Article describes the various utility features available under the Tools tab in Zoho Writer. Among the highlighted capabilities are: Editing options: Features like Focus Typing (blurs other content so you can focus on the current ...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 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 can org admins add new fonts in Zoho Writer
Overview Zoho Writer allows you to add more fonts to it, enabling you to ensure brand consistency while creating documents or meet specific needs like creating research or scientific reports that mandate only a specific font. Zoho Writer offers the ...
New to Zoho LandingPage?
Zoho LandingPage Resources