AND function Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/and-function/ Bestselling Excel and Power BI Courses Thu, 14 Dec 2023 22:28:58 +0000 en-US hourly 1 https://www.xelplus.com/wp-content/uploads/2022/10/cropped-site-icon-32x32.png AND function Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/and-function/ 32 32 How to Read and Create Barcodes in Excel https://www.xelplus.com/generate-barcodes-excel/ Thu, 06 Feb 2020 10:00:00 +0000 https://www.xelplus.com/?p=11492 Find out how you can generate UPC barcodes in Excel that work! I tested it with a scanner and the Excel barcodes could be scanned. The solution uses a combination of Excel VBA, formulas and conditional formatting.

The post How to Read and Create Barcodes in Excel appeared first on Xelplus - Leila Gharani.

]]> Excel Custom Data Validation https://www.xelplus.com/excel-custom-data-validation/ Thu, 24 May 2018 06:49:00 +0000 https://www.xelplus.com/?p=10518 Learn how to create data validation rules with formulas for custom conditions, such as alphanumeric codes or ids that have to follow a specific pattern. With formula, you can check for text, numbers & length of the entered text.

The post Excel Custom Data Validation appeared first on Xelplus - Leila Gharani.

]]> Excel IF Formula: Simple to Advanced https://www.xelplus.com/excel-if-formula-simple-to-advanced/ Thu, 01 Feb 2018 12:16:00 +0000 https://www.xelplus.com/?p=11128 Learn how to use Excel's IF formula in your Excel reports. We start with a simple example, followed by using IF with multiple criteria. You also learn how to use AND / OR conditions inside the IF function. Download the workbook to practice along.

The post Excel IF Formula: Simple to Advanced appeared first on Xelplus - Leila Gharani.

]]>