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")))

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"))) * *

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")))

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 -

Hi - both cells contain a Date Diff formula based on dates in E18 and F18.
G18 calculates full calendar years and H18 calcuates full calendar months.
The other Ifs in the statement work fine, it is just the insertion of the
word 'weeks' causing the problem.

"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 -

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 -