Try it like this:

=IF(H18143,"12 WEEKS",IF(H1859,G18&" weeks",IF(H185,"1 MONTH","1
WEEK")))

Hope this helps.

Pete

On May 23, 3:11*pm, MissV wrote:
i have an employee list and need to calculate notice periods based on length
of service. col G is length of service in years, col H is length of service
in months. *i've figured most of them but having problems with getting a text
output in addition to the numeric value. *for example, employee with length
of service 59 mths get 1 week for each complete year of service which is in
col G, but i just get the numeric value in the return, what i need is the
numeric value folowed by the text WEEKS. *i've tried adding the text in
inverted commas, brackets, and nothing works. *can anyone help? *my statement
is as follows;

=IF(H18143,"12 WEEKS",IF(H1859,G18,IF(H185,"1 MONTH","1 WEEK"))) * *