• Mathematical and Financial Functions
  • 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