How do I use Percent() Function?

The percent function allows you to execute one or more statements only a certain percentage of the time. Used in an IF…THEN statement, the function returns a TRUE or FALSE.

To use the percent function, enter PERCENT(n) where n is the percentage of the time that the statement will return a TRUE condition in an IF…THEN statement.

Example

In the first example, logic following the THEN statement is executed 21.5% of the time. In the second, logic following the THEN statement is executed 35% of the time and the logic following the ELSE statement is executed 65% of the time.

1) IF PERCENT(21.5) THEN…
2) IF PERCENT(35) THEN…

ELSE…

Functions

Was this article helpful?

Need Support?

Can't find the answer you're looking for?
Contact Support
Go to Top