Re: [Skate] Excel errors.

At 10:21 16.03.2018, you wrote:
Hi Tim.

I have tried this. But the error is still there. 
I need to fix it on another computer and find out 
what is wrong instead. I think Win10 change 
something in the setup and this is causing my old 
setup to something new. I feel there is the setup 
I need to do some changements. If not I have to start all over again. <:-|
Regards
Steinar

>
>
>Hi Steinar,
>
>Replace the ,"& by ."& (comma setting)
>
>kind regards
>
>Tim
>
> > Op 15 maart 2018 om 22:57 schreef "Steinar 
> VissebrÃ¥ten [email protected] 
> [Speed_skating]" <[email protected]>:
> >
> > Why does my calculation in excel like this return an error like this:
> > =IF(Q2="";"";(IF(LEN(Q2)=5;Q2;LEFT(Q2;2)*60+MID(Q2;3;2) ," 2)))/3)
> >
> > Error:
> >
> > #VALUE!
> > The calculation is like this:
> >
> > #VALUE!
> > Furmula >=IF(Q2="";"";TRUNC(X2;3))
> >
> > Is there anything I am missing in the setup?
> >
> > It all happened after WIN10 update followed with a main PC failure.
> >
> > Thank for using your bains.
> > Steinar
> >
> > --
> >
> > Steinar Vissebråten, Liavegen 149,
> > N-3540 Nesbyen,NORWAY
> >
> > ------------------------------------
> >
> > Posted by: =?UTF-8?Q?Steinar_Vissebr=c3=a5ten?= <[email protected]>
> >
> > ------------------------------------
> >
> > ------------------------------------
> >
> > Yahoo Groups Links
> >
> >
> >
>

Bratt og Ulent .....Snekkeri og høvleri.

Steinar Vissebråten, Liavegen 149,
N-3540 Nesbyen,NORWAY

Phone: +47 32068733..............Mobil: +47 9069 3540

Internet:
http://www.vissebraaten.no/
http://www.rukkedalen.com/ 

[Non-text portions of this message have been removed]



------------------------------------
Posted by: Steinar =?iso-8859-1?Q?Vissebr=E5ten?= <[email protected]>
------------------------------------