Conditional formulas Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/conditional-formulas/ Bestselling Excel and Power BI Courses Fri, 07 Mar 2025 09:48:37 +0000 en-US hourly 1 https://www.xelplus.com/wp-content/uploads/2022/10/cropped-site-icon-32x32.png Conditional formulas Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/conditional-formulas/ 32 32 COUNTIFS Function in Excel https://www.xelplus.com/excel-countifs-function/ Wed, 05 Jun 2024 06:22:14 +0000 https://www.xelplus.com/?p=24151 Master the COUNTIFS function in Excel. Count cells based on multiple criteria with this powerful tool. Free practice file included.

The post COUNTIFS Function in Excel appeared first on Xelplus - Leila Gharani.

]]> How to Create a Barcode 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 Create a Barcode in Excel appeared first on Xelplus - Leila Gharani.

]]> How to Use Excel MAXIFS & MINIFS Functions with Multiple Criteria https://www.xelplus.com/excel-maxifs-minifs-with-conditions/ Thu, 22 Aug 2019 09:00:00 +0000 https://www.xelplus.com/?p=12243 Is there an Excel MAX IF or MIN IF function? Yes. There is MAXIFS and MINIFS functions that allow you to get the MAX or MIN value based on criteria. IF you don't have these functions you have alternate ways of getting this done. One option is to use AGGREGATE function

The post How to Use Excel MAXIFS & MINIFS Functions with Multiple Criteria appeared first on Xelplus - Leila Gharani.

]]> Excel Function to Check IF Cell Contains Specific Text https://www.xelplus.com/if-function-with-wildcard-partial-text-match/ Sat, 01 Jun 2019 22:31:00 +0000 https://www.xelplus.com/?p=12327 How can you use wildcards in Excel's IF Function - with this method you can easily check for a partial text match. It's a clever method to get the IF function to check if the cell value contains a word.

The post Excel Function to Check IF Cell Contains Specific Text appeared first on Xelplus - Leila Gharani.

]]> How to Use the IF Function in Excel https://www.xelplus.com/if-function-excel/ 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 How to Use the IF Function in Excel appeared first on Xelplus - Leila Gharani.

]]> Excel SUMIFS Function https://www.xelplus.com/sumifs/ Fri, 10 Feb 2017 14:06:00 +0000 https://www.xelplus.com/?p=12652 Learn how to use the SUMIFS function in Excel to sum values based on multiple conditions. Free practice file included.

The post Excel SUMIFS Function appeared first on Xelplus - Leila Gharani.

]]>