Hi - Columns G & H both contain Date Diff calculations based on dates in
Columns E & F.


"Pete_UK" wrote:

I presume that H18 does actually contain numbers, and not text values
that look like numbers? And what is in G18?

Pete

On May 23, 3:36 pm, MissV wrote:
hello! thanks for replying so quick.
i tried it and get #VALUE! in those fields. have tried it with and without
a space between " weeks
MissV



"Pete_UK" wrote:
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"))) - Hide quoted text -

- Show quoted text -