Expressing a number as an ordinal Get link Facebook X Pinterest Email Other Apps June 24, 2014 =A1&IF(OR(VALUE(RIGHT(A1,2))={11,12,13}),”th”,IF(OR(VALUE(RIGHT(A1))={1,2,3}), CHOOSE(RIGHT(A1),”st”,”nd”,”rd”),”th”)) Read more