• ABS Function
• AVERAGE Function
• CGROUP Function
• CGROUPT Function
• COLCOUNT Function
• COUNTIF function
• EXP Function
• FV Function
• LOG Function
• Mathematical and Financial Functions
• MAX Function
• MEDIAN Function
• MIN Function
• MKDEC Function
• MKINT Function
• MOD Function
• POS Function
• PV Function
• R Function
• RATIO Function
• RC Function
• RCNV Function
• RCR Function
• RCTOTAL Function
• ROUND Function
• ROWCOUNT Function
• RR Function
• RRTOTAL Function
• STDDEV Function
• SUM Function
• TOTAL Function

RATIO Function

The RATIO function calculates the ratio between two cells.

Syntax

RATIO(expression1,expression2)

Example 1

RATIO(c1,c2)

Returns c1 as a percentage of c2.

Example 2

RATIO(c1,c1+c2)

Returns c1 as a percentage of the sum of cells c1 and c2.

Related Topics

• Mathematical and Financial Functions