View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
MissV MissV is offline
external usenet poster
 
Posts: 7
Default 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")))