回答編集履歴
1
ブランクの時にも対応
test
CHANGED
|
@@ -2,4 +2,4 @@
|
|
|
2
2
|
|
|
3
3
|
|
|
4
4
|
|
|
5
|
-
=SPARKLINE({IF(O2<0,IF(O2<-10000,0,10000+O2),10000),IF(O2<0,IF(O2<-10000,10000,-O2),IF(O2>10000,10000,O2)),IF(O2>0,if(O2>10000,0,10000-O2),10000)},{"charttype","bar";"max",20000;"color1","#d9d9d9";"color2",IF(O2>0,"#8fcf75","#dd9696")})
|
|
5
|
+
=SPARKLINE({IF(O2<0,IF(O2<-10000,0,10000+O2),10000),IF(O2<0,IF(O2<-10000,10000,-O2),IF(O2>10000,10000,IF(O2,O2,0))),IF(O2>0,if(O2>10000,0,10000-O2),10000)},{"charttype","bar";"max",20000;"color1","#d9d9d9";"color2",IF(O2>0,"#8fcf75","#dd9696")})
|