pound() Function

Function

pound( number, decimals, no_commas )

Converts the number into pounds by effectively adding a pound symbol (£), a decimal point, and one comma for every three digits preceding the decimal.

Parameters

Keyword Type Description

number

Decimal

The number of pounds to be returned as text.

decimals

Decimal

The number of digits after the decimal to display.

no_commas

Integer

An optional flag value indicating whether commas are used as number separators. It accepts 0 or 1. The default value is 0.

Returns

Text

Usage considerations

Understanding results

If no arguments are passed, the pound symbol itself is returned as text.

If no decimals value is passed, the function uses 2 by default.

Examples

You can experiment with this function in the test box below.

Test Input

pound(3213.43,2) returns £3,213.43

Open in Github Built: Thu, Oct 14, 2021 (02:44:31 PM)

On This Page

FEEDBACK