{"id":84,"date":"2012-01-26T05:41:49","date_gmt":"2012-01-26T11:41:49","guid":{"rendered":"http:\/\/xlfxs.com\/?p=84"},"modified":"2012-01-26T05:41:49","modified_gmt":"2012-01-26T11:41:49","slug":"tally-chart-in-functions","status":"publish","type":"post","link":"https:\/\/xlfxs.com\/?p=84","title":{"rendered":"Tally chart in functions"},"content":{"rendered":"<p>Using a single function can make a graphical view to your number<\/p>\n<p>Function is <em><strong>REPT<\/strong><\/em> along with <em><strong>IF<\/strong><\/em> and <em><strong>INT<\/strong><\/em> to show that number in graphical view, formula used here is:<\/p>\n<pre>\n=IF(B4&lt;5,REPT(\"|\",B4),REPT(REPT(\"|\",5)&amp;\"-\",INT(B4\/5))&amp;REPT(\"|\",B4-INT(B4\/5)*5))<\/pre>\n<p><a href=\"http:\/\/xlfxs.com\/wp-content\/uploads\/2012\/01\/TallyFX.zip\"><img decoding=\"async\" class=\"aligncenter\" src=\"\/wp-content\/uploads\/2014\/12\/Download1.png\" alt=\"\" \/><\/a><\/p>\n\n","protected":false},"excerpt":{"rendered":"<p>Using a single function can make a graphical view to your number Function is REPT along with IF and INT to show that number in graphical view, formula used here is: =IF(B4&lt;5,REPT(&#8220;|&#8221;,B4),REPT(REPT(&#8220;|&#8221;,5)&amp;&#8221;-&#8220;,INT(B4\/5))&amp;REPT(&#8220;|&#8221;,B4-INT(B4\/5)*5))<\/p>\n","protected":false},"author":1,"featured_media":85,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3,80,86,35,38,49,6,8],"tags":[],"class_list":["post-84","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-formulas","category-if","category-int","category-logical","category-math-and-trig","category-rept","category-standard_functions","category-texts-and-strings"],"_links":{"self":[{"href":"https:\/\/xlfxs.com\/index.php?rest_route=\/wp\/v2\/posts\/84","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/xlfxs.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/xlfxs.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/xlfxs.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/xlfxs.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=84"}],"version-history":[{"count":0,"href":"https:\/\/xlfxs.com\/index.php?rest_route=\/wp\/v2\/posts\/84\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/xlfxs.com\/index.php?rest_route=\/wp\/v2\/media\/85"}],"wp:attachment":[{"href":"https:\/\/xlfxs.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=84"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/xlfxs.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=84"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/xlfxs.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=84"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}