Re: [Skate] Excel errors.

Hi Steinar

Was this message meant for me?
Because i recongise code from my old speedskating Excel sheets ;)
/http://www.wcsc.nl/fillin.html

Kees

Op 15/03/2018 om 22:57 schreef Steinar Vissebråten 
[email protected] [Speed_skating]:
> 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
> 


------------------------------------
Posted by: Heyakeessie <[email protected]>
------------------------------------