# Nested IF(AND) and OR formulas

Topic Labels: Formulas
Solved
566 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
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(
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
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(
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!!