Operators functions
All 14 functions in this category
AMPERSANDCombines two text values into a single string; use AMPERSAND to join customer names, plan types, or any text fragments into one field.PLUSPLUS returns the sum of two numbers, making it ideal for combining values in retail calculations and data analysis.MINUSSubtracts the second number from the first number and returns the resulting difference, commonly used to find gaps between values.MULTIPLYMULTIPLY returns the product of two numbers, commonly used to calculate total inventory value, costs, or other scalar quantities in spreadsheets.DIVIDEDIVIDE returns the quotient of one number divided by another, with support for error handling to prevent division-by-zero crashes.EQEQ returns TRUE if two values are exactly equal, FALSE otherwise. Use it to compare values in spreadsheet logic.NENE returns TRUE if two values are not equal, FALSE if they match. Use it to find mismatches, filter data by inequality, or flag exceptions.GTGT tests whether the first value is strictly greater than the second value, returning TRUE if so and FALSE if not.GTEGTE returns TRUE when the first value is greater than or equal to the second, useful for filtering maintenance records by cost thresholds or mileage milestones.LTReturns TRUE if the first value is strictly less than the second, FALSE otherwise; useful for conditional logic and filtering.LTELTE checks if one value is less than or equal to another, returning TRUE or FALSE; use it to test spend, thresholds, or any numeric comparison.UPLUSUPLUS coerces its argument to a number, converting text-formatted numbers and other numeric values to true numeric format.UMINUSReturns the negative of a number, converting positive values to negative and vice versa; use it for accounting entries or reversing numeric signs.POWPOW returns a base number raised to the power of an exponent, used for scaling calculations, growth rates, and exponential effects.