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

/Ander

--
a94andw
-----------------------------------------------------------------------
a94andwi's Profile: http://www.excelforum.com/member.php...fo&userid=2107
View this thread: http://www.excelforum.com/showthread.php?threadid=47300

why are there semi-colons instead of commas?

--


Gary


"a94andwi" wrote in
message ...

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

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 ,
"Gary Keramidas" wrote:

why are there semi-colons instead of commas?

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 ,
a94andwi
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

i was wondering if that might be the case, thanks

--


Gary


"JE McGimpsey" wrote in message
...
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 ,
"Gary Keramidas" wrote:

why are there semi-colons instead of commas?

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 issu
here really. I know that the function above works if there are inputs i
the fields I'm using.

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

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


/Ander

--
a94andw
-----------------------------------------------------------------------
a94andwi's Profile: http://www.excelforum.com/member.php...fo&userid=2107
View this thread: http://www.excelforum.com/showthread.php?threadid=47300

Hello.

I finally did it.

Thanks for your help

--
a94andw
-----------------------------------------------------------------------
a94andwi's Profile: http://www.excelforum.com/member.php...fo&userid=2107
View this thread: http://www.excelforum.com/showthread.php?threadid=47300

would you post your solution please?


--
rnrss
------------------------------------------------------------------------
rnrss's Profile: http://www.excelforum.com/member.php...o&userid=27823
View this thread: http://www.excelforum.com/showthread...hreadid=473000