# IF AND Statement Help

Topic Labels: Formulas
Solved
175 2
cancel
Showing results for
Did you mean:  6 - Interface Innovator

Here is my formula which I need to add a few more statements too.

IF(AND({LOS2} >= .0, {LOS2} <.26), "First 3 Months", IF(AND({LOS2} > .25, {LOS2} < 1.00), "Within 1 Year", IF(AND({LOS2} >= 1.00, {LOS2} < 2.00), "1 - 2 Years", IF(AND({LOS2} >= 2.00, {LOS2} < 3.00),"2 - 3 Years",  IF(AND({LOS2} >= 3.00,{LOS2} < 4.00,"3 - 4 Years"))))))

Here is a screen shot of the table.  It isn't capturing the last statement in the formula; it is returning nothing. It should return 3-4 Years.  What am I missing? 1 Solution

Accepted Solutions  10 - Mercury

Hey @Wendy_Yelsik

Try this:

``````IF(
AND(
{LOS2} >= .0,
{LOS2} <.26
),
"First 3 Months",
IF(
AND(
{LOS2} > .25,
{LOS2} < 1.00
),
"Within 1 Year",
IF(
AND(
{LOS2} >= 1.00,
{LOS2} < 2.00
),
"1 - 2 Years",
IF(
AND(
{LOS2} >= 2.00,
{LOS2} < 3.00
),
"2 - 3 Years",
IF(
AND(
{LOS2} >= 3.00,
{LOS2} < 4.00
),
"3 - 4 Years"
)
)
)
)
)
)``````

Your very last AND() function was missing the necessary closing parentheses that would isolate the desired return value.

Here's what the snippet looked like:

``````IF(
AND(
{LOS2} >= 3.00,
{LOS2} < 4.00,
"3 - 4 Years"
)
)``````

Here's what it looks like corrected:

``````IF(
AND(
{LOS2} >= 3.00,
{LOS2} < 4.00
),
"3 - 4 Years"
)``````
2 Replies 2  10 - Mercury

Hey @Wendy_Yelsik

Try this:

``````IF(
AND(
{LOS2} >= .0,
{LOS2} <.26
),
"First 3 Months",
IF(
AND(
{LOS2} > .25,
{LOS2} < 1.00
),
"Within 1 Year",
IF(
AND(
{LOS2} >= 1.00,
{LOS2} < 2.00
),
"1 - 2 Years",
IF(
AND(
{LOS2} >= 2.00,
{LOS2} < 3.00
),
"2 - 3 Years",
IF(
AND(
{LOS2} >= 3.00,
{LOS2} < 4.00
),
"3 - 4 Years"
)
)
)
)
)
)``````

Your very last AND() function was missing the necessary closing parentheses that would isolate the desired return value.

Here's what the snippet looked like:

``````IF(
AND(
{LOS2} >= 3.00,
{LOS2} < 4.00,
"3 - 4 Years"
)
)``````

Here's what it looks like corrected:

``````IF(
AND(
{LOS2} >= 3.00,
{LOS2} < 4.00
),
"3 - 4 Years"
)``````  6 - Interface Innovator

Thanks.  I will give it a try.   - Wendy 