Re: [Skate] Excel errors.

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)&","&RIGHT(Q2;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
> 
> 
> 


------------------------------------
Posted by: Tim Wolfkamp <[email protected]>
------------------------------------