If function

[Salsero]

Hi there,
I have data sheet consisting of multiple columns, in column C I have text data as well as numbers data. I need a formula that will depict the following:
If the contents of C:2 (Sick Leave) is a text return No O/T and - Sick leave
If the contents of C:2 (27) is a number that is smaller than 57 return Under Cap - 30
If the contents of C:2 (67) is a number that is greater or equal to 57 return No O/T Over Cap -10
Am having a hard time figuring this formula out, thanks in advance.

[vlady]

try

Please Login or Register  to view this content.

[Salsero]

Hi Vladimir, thank you so much it worked perfectly, love this forum very informative.