CLAMP
Limits a value to a specified minimum and maximum value range. If the specified value is below the minimum value or above the maximum value, the minimum value or maximum value, respectively, is returned.
Syntax
=CLAMP(value, min, max)
Arguments
| Argument | Type | Description |
|---|---|---|
| value | Number | The value to clamp |
| min | Number | The minimum value |
| max | Number | The maximum value |
Examples
=CLAMP(3.14159, 0, 10)→3.14159
Restricts the value 3.14159 to the range 0 - 10
=CLAMP(-3.14159, 0, 10)→0
Restricts the value -3.14159 to the range 0 - 10
=CLAMP(3.14159, 0, 1)→1
Restricts the value 3.14159 to the range 0 - 1
=CLAMP(3, 1.5, 2.5)→2.5
Restricts the value 3 to the range 1.5 - 2.5
=CLAMP(1, 1.5, 2.5)→1.5
Restricts the value 1 to the range 1.5 - 2.5
=CLAMP(2, 1.5, 2.5)→2
Restricts the value 2 to the range 1.5 - 2.5
Updated 10 months ago