Forum Discussion

Copper Contributor

Mar 06, 2020

Excel Formula help, IFS function

I am trying to write an IFS statement to determine if a date falls within a certain date range. Date Range: is in Sheet 2 (see below) A B C 1 FY18 7/1/2017 6/30/2018 2 FY19 7/...

Formulas and Functions

MisterE

Copper Contributor

Mar 07, 2020

MSTwork

Upon analyzing your formula, I believe you need an AND statement in your if statement. For example for row 1, your formula would look like:

=IF(AND(I22>=Sheet2!B1,I22<=Sheet2!C1),Sheet2!A1," ")

Basically, it displays the value FY18 if true, else display space(" ") if false.