[Skate] Excel errors.
"Steinar Vissebråten [email protected] [Speed_skating]" <[email protected]> Thu, 15 Mar 2018 22:57:30 +0100
| Newsgroups | gmane.sports.speedskating |
|---|---|
| Message-ID | <[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]> ------------------------------------