pwrISCREDITCARDNUMBER

PowerUp Description

The pwrISCREDITCARDNUMBER PowerUp function determines whether the value or reference matches the expected pattern of a credit card number. The function also goes a step further and performs a Luhn validation to test whether the value could potentially be a credit card number.

PowerUp Syntax

pwrISCREDITCARDNUMBER(value)

The pwrISCREDITCARDNUMBER PowerUp function has the following arguments:

value – Required. This is the value or reference to a value to be evaluated for a credit card number pattern.

Return Value

pwrISCREDITCARDNUMBER will return TRUE if the value matches the pattern for a credit card.

Remarks

The value is not validated to be an actual, functioning number or account. The pattern is checked to verify that it is a potential credit card number.

Example

=pwrISCREDITCARDNUMBER("1234567890123456")

Leave a Reply

Your email address will not be published. Required fields are marked *