SAT Function

Office 2013 and later

Last modified: March 09, 2015

Applies to: Office 2013 | Visio 2013

In this article
Syntax
Remarks
Example 1
Example 2
Example 3

Returns the value of a color's saturation component.

SAT(expression)

Parameters

Name

Required/Optional

Data Type

Description

expression

Required

Varies

An index of a color in the document's color table, an expression that resolves to a custom color (like RGB or HSL), or a reference to a cell that contains a color index or color result.

Return Value

Numeric

The return value is a number in the range 0 to 240, inclusive. The function returns 0 for invalid input.

SAT(Sheet.4!FillForegnd)

Returns the saturation of Sheet.4's fill foreground color.

SAT(8)

Returns 240 if the document uses the default Visio color palette, where dark red is the color at index 8.

SAT(HSL(10, 20, 30))

Returns 20.

Show: