# Supported arithmetic operators

Operator | Meaning | Example |

+ (plus sign) | Addition | 3+3 |

- (minus sign) | Subtraction | 3-1 |

* (asterisk) | Multiplication | 3*3 |

X (upper- or lowercase) | Multiplication | 3x3 |

/ (forward slash) | Division | 3/3 |

% (percent sign) | Percent | 20% |

^ (caret) | Exponentiation | 3^2 |

! (exclamation) | Factorial computation | 5! |

## Supported math and trigonometry functions

Function | Description | Syntax |

ABS | Returns the absolute value of a number | ABS(number) |

ACOS | Returns the arccosine of a number | ACOS(number) |

ASIN | Returns the arcsine of a number | ASIN(number) |

ATAN | Returns the arctangent of a number | ATAN(number) |

COS | Returns the cosine of a number | COS(number) |

DEG | Converts an angle (in radians) to degrees | DEG(angle) |

LN | Returns the natural logarithm of a number | LN(number) |

LOG | Returns the natural logarithm of a number | LOG(number) |

LOG2 | Returns the base-2 logarithm of a number | LOG2(number) |

LOG10 | Returns the base-10 logarithm of a number | LOG10(number) |

MOD | Returns the remainder of a division operation | (number)MOD(number) |

PI | Returns the value of π as a constant | PI |

PHI | Returns the value of Φ (the golden ratio) | PHI |

PMT | Calculates a loan payment based on a constant interest rate, a constant number of payments, and the present value of the total amount | PMT(rate;nper;pv) |

RAD | Converts an angle (in degrees) to radians | RAD(angle) |

SIN | Returns the sine of the given angle | SIN(angle) |

SQRT | Returns a positive square root | SQRT(number) |

TAN | Returns the tangent of a number | TAN(number) |

## No comments:

## Post a Comment