# INVERSE macro

The `INVERSE` macro is available only in Unica Campaign.

## Syntax

`INVERSE(data)`

## Parameters

`data`

The numerical values to compute the inverse of. This can be a constant value, a column, a cell range, or an expression evaluating to any of the above. For the format definition of `data`, see the "Macro Function Parameters" section in the chapter in this guide for your product.

## Description

`INVERSE` calculates the negative of the values in the specified data range. It returns -x (that is, negative values are returned as positive values, and positive values are returned as negative values). `INVERSE` returns one new column for each input column, each containing the inverse of the values in the corresponding input column.

Note: To invert a value or a column, precede it with a minus sign (`-`). For example, `V2` `=` `-V1` is the same as `V2` `=` `INVERSE(V1)`.

## Examples

 `TEMP = INVERSE(3.2)` Creates a new column named `TEMP` containing the value `-3.2`. `TEMP = INVERSE(V1)` Creates a new column named `TEMP`, where each value is the negative of the values in column `V1`. `TEMP = INVERSE(V1:V3)` Creates three new columns named `TEMP`, `VX`, and `VY`. The values in the `TEMP` column are the negatives of values in column `V1`, the values of the `VX` column are the negatives of the values in column `V2`, and the values of the `VY` column are the negatives of the values in column `V3`. `TEMP = INVERSE(V1[10:20])` Creates a new column named `TEMP`, where the first 11 cells contain the negatives of the values of the values in rows 10-20 of column `V1`. The other cells in `TEMP` are empty. `TEMP = INVERSE(V1[1:5]:V2)` Creates two new columns named `TEMP` and `VX`, each with values in rows 1-5 (the other cells are empty). The values in column `TEMP` are the negatives of the values of the corresponding rows of column `V1`, and the values in column `VX` are the negatives of the values of the corresponding rows of column `V2`.

## Related functions

Function Description
`ABS` Computes the absolute value of the contents of the specified data range
`NOT` Computes the logical NOT of the contents of the specified data range
`SIGN` Computes the sign (positive or negative) of the values in the specified data range