• Mathematical and Financial Functions
  • Mathematical and Financial Functions
  • ABS function
  • AVERAGE function
  • CGROUP function
  • CGROUPT function
  • COLCOUNT function
  • COUNTIF function
  • EXP function
  • FV function
  • LOG function
  • 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