# Nested IF(AND) and OR formulas

Topic Labels: Formulas
Solved
325 2
cancel
Showing results for
Did you mean:  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",
),
"3,000",
IF(
AND(
{New/Refresh} = "Refresh",
),
"1,500",
IF(
AND(
{New/Refresh} = "New",
),
"5,000",
IF(
AND(
{New/Refresh} = "Refresh",
),
"2,500"
)
)
)
)

1 Solution

Accepted Solutions  10 - Mercury

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(
IF(
{New/Refresh} = "New",
"3,000",
IF(
{New/Refresh} = "Refresh",
"1,500"
)
),
IF(
IF(
{New/Refresh} = "New",
"5,000",
IF(
{New/Refresh} = "Refresh",
"2,500"
)
)
)
)
)``````

2 Replies 2  10 - Mercury

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(
IF(
{New/Refresh} = "New",
"3,000",
IF(
{New/Refresh} = "Refresh",
"1,500"
)
),
IF(
IF(
{New/Refresh} = "New",
"5,000",
IF(
{New/Refresh} = "Refresh",
"2,500"
)
)
)
)
)``````  4 - Data Explorer

thank you so much!! 