Computer Training & Application Solutions made Simple
Contact us for a free consultation
  • Click to send us an email. We'd love to hear from you!   Ottawa       613-656-4229
  • Click to send us an email. We'd love to hear from you!   Montreal    514-342-9494

MICROSOFT EXCEL IFS FUNCTION

Courtesy of
DJH Training & Application Solutions Inc.

Use the IFS function instead of nested IF to test for multiple conditions

Available in 365 version of Excel, the IFS function checks whether one or more conditions are met, and returns a value that corresponds to the first TRUE condition

IFS can take the place of nested IF statements and is much easier to construct and read when testing for multiple conditions.

 IFS can also be used with other functions, such as OR and AND.

Let’s break down the IFS function formula in the Status column below. Notice that if none of the conditions evaluate to TRUE, we simply add the TRUE condition to the end of the IFS formula as a catch-all to avoid an #N/A error.


 

Status Column Formula:      =IFS(E4="Y","Paid",D4<$B$1,$B$1-D4,TRUE,"Not Yet Due")

1. If column E contains Y, "Paid" should be returned

2. If Due Date is less than the report date, return the difference between the report date and the due date

3. If neither condition is true, "Not Yet Due" should be returned

 

Would you like to learn more about IFS or any other Excel function? Contact us!

 

 

 

 

 

 



More Newsletter Articles

© 2022 DJH Training & Application Solutions Inc.

WOULD YOU LIKE TO USE THIS ARTICLE IN YOUR NEWSLETTER, EZINE OR WEB SITE? You can, as long as you include this complete blurb with it: An entrepreneur at heart, Deborah J. Sparks established DJH Training & Application Solutions Inc. over 25 years ago, realizing her dream of creating a company known for providing high quality computer software training, application development and support and exercising her passion for teaching. To learn more and to register for DJH's free newsletter, Innovations, please visit www.djhsolutions.ca.