Hi All,

I have a spread sheet with a series of staff numbers (e.g 11234134), at the end of some of the numbers, there can be either -2, -3, -4, -5, -6 (e.g. 1123134-3)

I want to create a formula which will look at the number and if the number has -2 return 'Leave 2' if not 'Leave 1', or if it is -3 return 'Leave 3' if not 'Leave 1' and so on, except for -6, i want it to return 'Leave 1'

Could any one advise how i could go about this?

Thanks,

Luke.