Nested IF AND arguments

I'm trying to write a nested IF formula that can return text values based on multiple arguments. I have a column with dates and I need to know if the date is today, within the next week or within...

excel

Formulas and Functions

SergeiBaklan

Apr 28, 2023

FarmBio2909

With nested IF value_if_false is next IF. In your case like

=IF(
    AND($J79 = TODAY(), $H79 = "With client for approval"),
    "Due today",
    IF(
        AND(
            $J79 - TODAY() <= 7,
            $H79 = "With client for approval"
        ),
        "Due this week",
        ""
    )
)

SergeiBaklan

Diamond Contributor

Apr 28, 2023

FarmBio2909

With nested IF value_if_false is next IF. In your case like

=IF(
    AND($J79 = TODAY(), $H79 = "With client for approval"),
    "Due today",
    IF(
        AND(
            $J79 - TODAY() <= 7,
            $H79 = "With client for approval"
        ),
        "Due this week",
        ""
    )
)

FarmBio2909

Copper Contributor

Apr 28, 2023

SergeiBaklan Fantastic, thanks so much - got it!

SergeiBaklan
Diamond Contributor
Apr 28, 2023
FarmBio2909 , glad to help

Forum Discussion

Nested IF AND arguments

Resources