• So the equivalent in Excel is:

    =IF(Type1="RFS",

    IF(Type2="RFS",

    IF(Type3="RFS",

    IF(Type4="RFS","ALL",Detail4),

    Detail3),

    Detail2),

    Detail1)

    Sorry for format, I'm a little unfamiliar with the forum layout