Simple IF thing?

[a94andwi]

Hello I try to make IF-statement that do this:

IF( GETWORKDAYS(Installningar!$A$2;(DATE(200&(LEFT(N2;1));1;-5)+(MID(N2;2;2)*7)+RIGHT(N2;1))-1)="#VALUE!", not a value, GETWORKDAYS(Inställningar!$A$2;(DATE(200&(LEFT(N2;1));1;-5)+(MID(N2;2;2)*7)+RIGHT(N2;1))-1))
but it don't work.

Can anyone here see what is missing?

In the cell Installningar A2 it says : 2005-10-04

Please help

/Anders

[Gary Keramidas]

why are there semi-colons instead of commas?

--


Gary


"a94andwi" <[email protected]> wrote in
message news:[email protected]...
>
> Hello I try to make IF-statement that do this:
>
> IF(
> GETWORKDAYS(Installningar!$A$2;(DATE(200&(LEFT(N2;1));1;-5)+(MID(N2;2;2)*7)+RIGHT(N2;1))-1)="#VALUE!",
> not a value,
> GETWORKDAYS(Inställningar!$A$2;(DATE(200&(LEFT(N2;1));1;-5)+(MID(N2;2;2)*7)+RIGHT(N2;1))-1))
> but it don't work.
>
> Can anyone here see what is missing?
>
> In the cell Installningar A2 it says : 2005-10-04
>
> Please help
>
> /Anders
>
>
> --
> a94andwi
> ------------------------------------------------------------------------
> a94andwi's Profile:
> http://www.excelforum.com/member.php...o&userid=21077
> View this thread: http://www.excelforum.com/showthread...hreadid=473000
>

[JE McGimpsey]

Probably because he's using a European version of XL, where the argument
separators are semicolons, and the decimal separator is a comma.


In article <[email protected]>,
"Gary Keramidas" <[email protected]> wrote:

> why are there semi-colons instead of commas?

[JE McGimpsey]

It's hard to tell from your post.

What's in N2?

Is A2 a string or a date?

"not a value" should, I think, be in quotes

If your conditional evaluates to an error, it won't evaluate to a string
(e.g., "#VALUE!"). Instead, try

=IF(ISERR(GETWORKDAYS...),"not a value", GETWORKDAYS(...))

Is GETWORKDAYS the equivalent of the English NETWORKDAYS?

In article <[email protected]>,
a94andwi <[email protected]>
wrote:

> Hello I try to make IF-statement that do this:
>
> IF(
> GETWORKDAYS(Installningar!$A$2;(DATE(200&(LEFT(N2;1));1;-5)+(MID(N2;2;2)*7)+RI
> GHT(N2;1))-1)="#VALUE!",
> not a value,
> GETWORKDAYS(Inställningar!$A$2;(DATE(200&(LEFT(N2;1));1;-5)+(MID(N2;2;2)*7)+RI
> GHT(N2;1))-1))
> but it don't work.
>
> Can anyone here see what is missing?
>
> In the cell Installningar A2 it says : 2005-10-04
>
> Please help
>
> /Anders

[Gary Keramidas]

i was wondering if that might be the case, thanks

--


Gary


"JE McGimpsey" <[email protected]> wrote in message
news:[email protected]...
> Probably because he's using a European version of XL, where the argument
> separators are semicolons, and the decimal separator is a comma.
>
>
> In article <[email protected]>,
> "Gary Keramidas" <[email protected]> wrote:
>
>> why are there semi-colons instead of commas?

[a94andwi]

Hello and thanx already.

I'll try to help out here with some more info.
The XL is a european version, yes.

This is the function that I'm using:

=GETWORKDAYS(Inställningar!$A$2;(DATE(200&(LEFT(N2;1));1;-5)+(MID(N2;2;2)*7)+RIGHT(N2;1))-1)

In Cell N2 there is the value: 2005321 year:2005, week:32, Day: 1
In the cell Installningar!$A$2 it says : 2005-10-04 This isn't an issue here really. I know that the function above works if there are inputs in the fields I'm using.

The problem is that I get the value = #VALUE! in the cell that do the counting above. I don't think that is very nice so I wanted an IF-funktion that checks if it returns #VALUE! or not.
If it does return #VALUE!, don't do anything (Blank cell), otherwise do the counting.
I can't make this work.

If you can help me, please use commas instead of semicolons.


/Anders

[a94andwi]

Hello.

I finally did it.

Thanks for your help!

[rnrss]

would you post your solution please?