Apr 04, 2023 09:56 AM
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!!
Solved! Go to Solution.
Apr 04, 2023 11:55 AM
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"
)
)
)
)
)
Apr 04, 2023 11:55 AM
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"
)
)
)
)
)
Apr 04, 2023 11:59 AM
thank you so much!!