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?
Best answer by Ben_Young1
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"
)
