Skip to main content
Solved

Nested IF(AND) and OR formulas

Forum|alt.badge.img+1

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

Best answer by Ben_Young1

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

 

View original
This topic has been closed for replies.

2 replies

Ben_Young1
Forum|alt.badge.img+22

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

 

    Forum|alt.badge.img+1
    • kjutzi
    • Author
    • New Participant
    • April 4, 2023

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

    Terms & ConditionsAccessibility statement