{"id":5296,"date":"2017-10-17T23:31:30","date_gmt":"2017-10-17T21:31:30","guid":{"rendered":"https:\/\/www.itlektor.cz\/?p=5296"},"modified":"2017-10-17T23:38:57","modified_gmt":"2017-10-17T21:38:57","slug":"prevod-textu-na-vzorec-v-excelu-funkci-evaluate","status":"publish","type":"post","link":"https:\/\/www.itlektor.cz\/en\/prevod-textu-na-vzorec-v-excelu-funkci-evaluate\/","title":{"rendered":"Convert text to formula using EVALUATE"},"content":{"rendered":"<p>If you need to convert a text expression to a formula in Excel, there is a way even without programming, using the hidden EVALUATE function. In this manual we will look at how to use it. If this guide has helped you, become a fan on <a href=\"http:\/\/www.facebook.com\/itlektorcz\" target=\"_blank\" rel=\"noopener\">Facebook<\/a> and recommend this site to your friends, it\u00a0can be useful for them too.<\/p>\n<h2>Prepare data<\/h2>\n<p>In column A, we place text expressions representing future formulas. These texts must have the exact addresses or other used functions, but without the = at the beginning. We will want to calculate, based on text-based formulas, the results from the values in column B.<\/p>\n<h2>Define name<\/h2>\n<p>In order to use the hidden EVALUATE function to convert a text expression to a formula, we need to use it in the defined name.<\/p>\n<ol>\n<li>Click inside C2<\/li>\n<li>Go to FORMULAS&gt; Define name<\/li>\n<li>Fill the window\n<ul>\n<li>name eg. &#8220;eval&#8221;<\/li>\n<li>referes to =EVALUATE($A2)<\/li>\n<\/ul>\n<\/li>\n<li>Then go to C2 and write formula\u00a0<strong>=eval<\/strong> , you can copy formula down to other cells in a column.<\/li>\n<\/ol>\n<p><\/p>\n<!-- AddThis Advanced Settings generic via filter on the_content --><!-- AddThis Share Buttons generic via filter on the_content -->","protected":false},"excerpt":{"rendered":"<p>If you need to convert a text expression to a formula in Excel, there is a way even without programming, using the hidden EVALUATE function. In this manual we will look at how to use it. If this guide has helped you, become a fan on Facebook and recommend this site to your friends, it\u00a0can [&hellip;]<!-- AddThis Advanced Settings generic via filter on get_the_excerpt --><!-- AddThis Share Buttons generic via filter on get_the_excerpt --><\/p>\n","protected":false},"author":1,"featured_media":5301,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"footnotes":""},"categories":[3],"tags":[10,49,58,50],"_links":{"self":[{"href":"https:\/\/www.itlektor.cz\/en\/wp-json\/wp\/v2\/posts\/5296"}],"collection":[{"href":"https:\/\/www.itlektor.cz\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.itlektor.cz\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.itlektor.cz\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.itlektor.cz\/en\/wp-json\/wp\/v2\/comments?post=5296"}],"version-history":[{"count":0,"href":"https:\/\/www.itlektor.cz\/en\/wp-json\/wp\/v2\/posts\/5296\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.itlektor.cz\/en\/wp-json\/wp\/v2\/media\/5301"}],"wp:attachment":[{"href":"https:\/\/www.itlektor.cz\/en\/wp-json\/wp\/v2\/media?parent=5296"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.itlektor.cz\/en\/wp-json\/wp\/v2\/categories?post=5296"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.itlektor.cz\/en\/wp-json\/wp\/v2\/tags?post=5296"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}