Help

Nested IF(AND) and OR formulas

Topic Labels: Formulas
Solved
Jump to Solution
440 2
cancel
Showing results for 
Search instead for 
Did you mean: 
kjutzi
4 - Data Explorer
4 - Data Explorer

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"
)
)
)
)
 
 
1 Solution

Accepted Solutions
Ben_Young1
11 - Venus
11 - Venus

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"
                )
            )
        )
    )
)

 

See Solution in Thread

2 Replies 2
Ben_Young1
11 - Venus
11 - Venus

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!!