Nested IF(AND) and OR formulas

Question

Thanks to this community I learned how to create nested IF(AND) formulas, but I want to add an additional rule that if another column is No, then it will exclude the amount. Here is my formula. I want to add "IF({PD/PC/PoP Stipend?} = "No", ), "0"), but how would I do that? - thank you!!

IF(

AND(

{New/Refresh} = "New",

{GR/UG} = "Undergraduate"

),

"3,000",

IF(

AND(

{New/Refresh} = "Refresh",

{GR/UG} = "Undergraduate"

),

"1,500",

IF(

AND(

{New/Refresh} = "New",

{GR/UG} = "Graduate"

),

"5,000",

IF(

AND(

{New/Refresh} = "Refresh",

{GR/UG} = "Graduate"

),

"2,500"

)

Ben_Young1 · Accepted Answer

Hey @kjutzi!

I'm assuming that the condition you want to add to the formula should be the first thing evaluated in the formula.
If that's correct, then you can use this formula:

IF(
    {PD/PC/PoP Stipend?} = "No",
    "0",
    IF(
        {GR/UG} = "Undergraduate",
        IF(
            {New/Refresh} = "New",
            "3,000",
            IF(
                {New/Refresh} = "Refresh",
                "1,500"
            )
        ),
        IF(
            {GR/UG} = "Graduate",
            IF(
                {New/Refresh} = "New",
                "5,000",
                IF(
                    {New/Refresh} = "Refresh",
                    "2,500"
                )
            )
        )
    )
)

thank you so much!!

kjutzi · Answer

Hey @kjutzi!

I'm assuming that the condition you want to add to the formula should be the first thing evaluated in the formula.
If that's correct, then you can use this formula:

IF(
    {PD/PC/PoP Stipend?} = "No",
    "0",
    IF(
        {GR/UG} = "Undergraduate",
        IF(
            {New/Refresh} = "New",
            "3,000",
            IF(
                {New/Refresh} = "Refresh",
                "1,500"
            )
        ),
        IF(
            {GR/UG} = "Graduate",
            IF(
                {New/Refresh} = "New",
                "5,000",
                IF(
                    {New/Refresh} = "Refresh",
                    "2,500"
                )
            )
        )
    )
)

thank you so much!!

Sign up

Login to the community

Scanning file for viruses.

This file cannot be downloaded