@@ -33,37 +33,40 @@ function myExcelFuns() {
33
33
var numberArr = numberStr . split ( " " ) ;
34
34
var result = 0 ;
35
35
36
- if ( document . getElementById ( "arrSum" ) . checked ) {
36
+ if ( numberArr != "" ) {
37
+ if ( document . getElementById ( "arrSum" ) . checked ) {
37
38
38
- for ( var i = 0 ; i < numberArr . length ; i ++ )
39
- if ( numberArr [ i ] != "" ) {
40
- result = result + parseFloat ( numberArr [ i ] ) ;
41
- }
42
- } else if ( document . getElementById ( "arrAvg" ) . checked ) {
39
+ for ( var i = 0 ; i < numberArr . length ; i ++ )
40
+ if ( numberArr [ i ] != "" ) {
41
+ result = result + parseFloat ( numberArr [ i ] ) ;
42
+ }
43
+ } else if ( document . getElementById ( "arrAvg" ) . checked ) {
43
44
44
- for ( var i = 0 ; i < numberArr . length ; i ++ )
45
- if ( numberArr [ i ] != "" ) {
46
- result = result + parseFloat ( numberArr [ i ] ) ;
47
- }
48
- result = result / numberArr . length ;
49
- } else if ( document . getElementById ( "arrMax" ) . checked ) {
45
+ for ( var i = 0 ; i < numberArr . length ; i ++ )
46
+ if ( numberArr [ i ] != "" ) {
47
+ result = result + parseFloat ( numberArr [ i ] ) ;
48
+ }
49
+ result = result / numberArr . length ;
50
+ } else if ( document . getElementById ( "arrMax" ) . checked ) {
50
51
51
- for ( var i = 0 ; i < numberArr . length ; i ++ )
52
- if ( numberArr [ i ] != "" ) {
53
- result = Math . max ( ...numberArr ) ;
54
- }
55
- } else if ( document . getElementById ( "arrMin" ) . checked ) {
52
+ for ( var i = 0 ; i < numberArr . length ; i ++ )
53
+ if ( numberArr [ i ] != "" ) {
54
+ result = Math . max ( ...numberArr ) ;
55
+ }
56
+ } else if ( document . getElementById ( "arrMin" ) . checked ) {
56
57
57
- for ( var i = 0 ; i < numberArr . length ; i ++ )
58
- if ( numberArr [ i ] != "" ) {
59
- result = Math . min ( ...numberArr ) ;
60
- }
61
- } else {
58
+ for ( var i = 0 ; i < numberArr . length ; i ++ )
59
+ if ( numberArr [ i ] != "" ) {
60
+ result = Math . min ( ...numberArr ) ;
61
+ }
62
+ } else {
62
63
63
- return 0 ;
64
+ return 0 ;
65
+ }
66
+ document . getElementById ( "result" ) . innerHTML = result ;
67
+ } else {
68
+ alert ( "Please enter a numeric value with spaces to proceed." ) ;
64
69
}
65
- document . getElementById ( "result" ) . innerHTML = result ;
66
-
67
70
return false ;
68
71
} ;
69
72
0 commit comments