Re: [Skate] Excel errors.
| Newsgroups | gmane.sports.speedskating |
|---|---|
| Message-ID | <[email protected]> |
As long if you do not try to divide a string by 3. If the left-right-mid formula is seen as a string... > Op 16 mrt. 2018 om 13:55 heeft Steinar Vissebråten [email protected] [Speed_skating] <[email protected]> het volgende geschreven: > > 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]> > ------------------------------------ > > > ------------------------------------ > > Yahoo Groups Links > > > ------------------------------------ Posted by: Tim <[email protected]> ------------------------------------