IF Statement Query
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")))
|