Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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"))) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
If statement query | Excel Worksheet Functions | |||
IF statement query | Excel Discussion (Misc queries) | |||
IF statement query | Excel Worksheet Functions | |||
Anyone Else Use Database Query to Query Another Sheet in the Same Excel Workbook? | Excel Discussion (Misc queries) | |||
How to use a Access Query that as a parameter into Excel database query | Excel Discussion (Misc queries) |