IF function Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/if-function/ Bestselling Excel and Power BI Courses Wed, 29 Mar 2023 16:04:58 +0000 en-US hourly 1 https://www.xelplus.com/wp-content/uploads/2022/10/cropped-site-icon-32x32.png IF function Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/if-function/ 32 32 Top Excel Functions for Engineers https://www.xelplus.com/excel-for-engineers/ Thu, 23 Dec 2021 10:00:00 +0000 https://www.xelplus.com/?p=9605 If you're a Mechanical Engineer, make sure you know these 10 Excel functions. Your work-life will become much easier once you learn these Excel formula combinations.

The post Top Excel Functions for Engineers appeared first on Xelplus - Leila Gharani.

]]> Best 10 Excel Functions for Accountants https://www.xelplus.com/excel-functions-for-accounting/ Thu, 25 Feb 2021 10:00:00 +0000 https://www.xelplus.com/?p=10260 Make sure you know these Excel functions if you work in Accounting, Finance or you are a Data Analyst. They'll make your work life a LOT easier and they work in all Excel versions (such as AGGREGATE, TRIM, ROUND & more)

The post Best 10 Excel Functions for Accountants appeared first on Xelplus - Leila Gharani.

]]> How to Use Excel IFS Function https://www.xelplus.com/excel-ifs-function/ Thu, 09 Jul 2020 10:48:00 +0000 https://www.xelplus.com/?p=10875 The IF function is one of the most popular functions in Excel. But what about the IFS function? Does it really make writing nested IF functions easier? Let's find out.

The post How to Use Excel IFS Function appeared first on Xelplus - Leila Gharani.

]]> Top 5 Excel Interview Questions https://www.xelplus.com/top-5-excel-interview-questions/ Thu, 10 Oct 2019 09:00:00 +0000 https://www.xelplus.com/?p=12068 Make sure you know the answers to these Excel Interview questions before you go to your next interview. These are asked specially if you're applying for data analyst jobs.

The post Top 5 Excel Interview Questions 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 a 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 a Cell Contains Specific Text 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.

]]> Excel Conditional Formatting Symbols https://www.xelplus.com/excel-conditional-formatting-symbols/ Thu, 29 Jun 2017 09:47:00 +0000 https://www.xelplus.com/?p=12194 If the conditional formatting icon selection doesn't meet your needs, you can customize your design and still make it dynamic with the help of the IF function and symbols. Explore the example of a project planning dashboard tracking overdue tasks.

The post Excel Conditional Formatting Symbols appeared first on Xelplus - Leila Gharani.

]]>