Linker IT Software
Order Home
menubar-top-links menubar-top-rechts
SQL*XL: Database to Excel bridge ExcelLock: Lock and secure your valuable Excel spreadsheets encOffice: Protect your Excel file easy and safe
Home Products litLIB Help Misc functions

Buy now

Download now

LITlib - Excel Power Functions Pack
 
Add-in for Excel that adds additional cell functions to Excel.

litLIB Help - ValidateVATNumber function
litLIB Help
Product pages :
litLIB
Quick links:
help index
forums

Misc - ValidateVATNumber

Syntax:
=ValidateVATNumber(Country, VATNumber)

Description:
Returns TRUE when the VAT registration number could be valid and FALSE otherwise.

Country : string to denote the country
VATNumber : the VAT registration number including the country code.

Example:
Could GB12345 be a valid VAT number?

=ValidateVATNumber("GB",GB12345)

litLIB