Functions
IFS
In its basic usage, the Excel IFS function runs multiple tests and returns a value correspondence to the first TRUE. Use the IFS function to evaluate multiple conditions without multiple nested IF statements. IFS allows shorter, easier to read formulas.
Simplified syntax:
| =IFS (Condition1, if Condition1 is True ,Condition2, if Condition2 is True…….. ) |
The syntax are a bit different from the traditional IF function and may take a awhile to get used to. We hope the following examples help in grasping the power in this new function.
This page is still in draft form, ignore the notes below for now.
=IF(E6>30,IF(E6<61,C6,0),0)
This page presents the IF function using very basic scenarios. More advanced examples are presented elsewhere on this site.
The technical syntax:
This is the Syntax as presented by Excel. The Simplified Syntax at the top of the page is the “English” version of the Syntax.
| =IF (logical_test, [value_if_true], [value_if_false]) |
Author: Jim Colville
Date: 7/18/1997 – Updated: 9/4/2019