Skip to main content

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?   
 

 

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" )

Thanks.  I will give it a try.   - Wendy

Terms & ConditionsAccessibility statement