• 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

POS Function

The POS function returns a value if the value is positive, otherwise it returns zero.

Syntax

POS(value)

Example

Assume the following:

BANK1 = c1 = 500

BANK2 = c2 = -500

BANK3 = c3 = 1000

Then:

POS(c1) = 500 and POS(-c1) = 0

POS(c2) = 0 and POS(-c2) = 500

POS(c3) = 1000 and POS(-c3) = 0

Therefore:

Bank Balance = POS(c1)+POS(c2)+POS(c3) = 1500

Bank Overdraft = POS(-c1)+POS(-c2)+POS(-c3) = 500

Related Topics

• Mathematical and Financial Functions