Skip to main content

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

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

 

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

Reply


Terms & Conditions