Understanding formulae supported in Zoho Writer

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:
  1. Array
  2. Aggregate
  3. Conditional logic
  4. Date
  5. Financial
  6. Math

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
Product
Quantity
Price
Apple
10
6
Banana
15
5
Orange
6
7

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
SUMIFReturns a sum of all the numbers in a range based on a condition.=SUMIF(B2:B5, 5, C2:C5)Sample table
Item
Units in Stock
Inventory Value
Chairs
5
5,000
Tables
10
3,000
Cabinets
5
4,000
Lamps
3
1,500


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
POWERReturns 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
SQRTReturns the square root of a positive number=SQRT(25)5
How to use formula in Zoho Writer Document
How to format the formula's output
How to refer a formula's output in a document
How to use circular formula reference in formulas