Nested If Then Else Statement

[msawyer]

Is it possible to create an If Then Else statement that allows for more than three conditions?  For example, I need to create an If Then Else statement that looks at a number and determines if it falls in the following buckets; late, on-time, within 30 days, between 31 and 60 days, between 61 and 90 days, and greater than 90 days.

Thanks!!

[vmanika8]

Thanks a lot Thomas... It works for me. But what about if the Days open field has blank cell.

I need to get the result field as "closed" for the blank cell items. How to do that?

Eg:

Days open     Result

30                   30-40

                       Closed

60                   60-90

[thomas_vdb]

This is a clause like another:

IF [Days Open] >= 30 THEN "30-40"
Elseif [Days Open] > 60 THEN "60-90"
Elseif IsEmpty([Days Open]) THEN "Closed"
ELSE [Days Open] ENDIF

😉