If function

[sparrow1]

Hi all,

I have several cell's (5).

After the calculating the number of years working, then I want to show in another cell a number.

To calculate de number of years working like this:

=Year(C4)-Year(C3) : this code is working perfectly

To calculate the equal number of working I'm using this code:

=IF(C9>17;"585";"580") : is also working perfectly

The problems began when I want to add another function:

=IF(ISNUMBER(C7);"430") : this code works alone

What I want is to create one function like this:

=IF(ISNUMBER(C7);"430");IF(C9>17;"585";"580") : this function doesn't work.

Thanks in advance,

[rcm]

you are missing a closing parenthesis

=IF(ISNUMBER(C7);"430");IF(C9>17;"585";"580")) <-

[sparrow1]

Hi,

I've tried this before without luck.
Gives a fault between the last parentheses:

=IF(ISNUMBER(C7);"430");IF(C9>17;"585";"580")|)

[Fotis1991]

This works for me. For you?

=IF(ISNUMBER(C7);430;IF(C9>17;585;580))

[sparrow1]

Thanks Fotis1991 that's working.
I thoud that I needed parenthesis for that, but i was wrong.

[Fotis1991]

.................