{"id":15545,"date":"2023-04-19T18:24:15","date_gmt":"2023-04-19T18:24:15","guid":{"rendered":"https:\/\/officetuts.net\/excel\/?p=15545"},"modified":"2024-02-19T14:52:12","modified_gmt":"2024-02-19T14:52:12","slug":"target-formula-in-excel","status":"publish","type":"post","link":"https:\/\/officetuts.net\/excel\/formulas\/target-formula-in-excel\/","title":{"rendered":"Target Formula in Excel"},"content":{"rendered":"\n<div class=\"wp-block-file\"><a id=\"wp-block-file--media-e3622188-4404-46ca-ad01-5ab80c362c25\" href=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2023\/04\/Target-Formula-in-Excel.xlsx\">Target-Formula-in-Excel<\/a><a href=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2023\/04\/Target-Formula-in-Excel.xlsx\" class=\"wp-block-file__button wp-element-button\" download aria-describedby=\"wp-block-file--media-e3622188-4404-46ca-ad01-5ab80c362c25\">Download File<\/a><\/div>\n\n\n\n<p>We can always use Excel formulas for their initial purposes, but we can also deploy them for different purposes. If we are working in any company that targets profit (so, basically, for any company) and want to set targets, we can use existing Excel formulas to calculate them.<\/p>\n\n\n\n<p>In the example below, we will do just that.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Target Formula in Excel<\/h2>\n\n\n\n<p>For this formula to work, we need to have a <strong>specific target value<\/strong> that is based on some input values. We will have a list of salespersons and their sales figures for the first quarter by month:<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"396\" height=\"244\" src=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2023\/04\/word-image-15545-1.png\" alt=\"\" class=\"wp-image-15546\" srcset=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2023\/04\/word-image-15545-1.png 396w, https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2023\/04\/word-image-15545-1-300x185.png 300w\" sizes=\"(max-width: 396px) 100vw, 396px\" \/><\/figure>\n\n\n\n<p>We will add the <strong>AVERAGE<\/strong> for the first three months (by simply putting the =AVERAGE(B2:D2) in the <strong>cell E2<\/strong>, and then dragging the formula till the end of the table:<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"488\" height=\"295\" src=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2023\/04\/word-image-15545-2.png\" alt=\"\" class=\"wp-image-15547\" srcset=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2023\/04\/word-image-15545-2.png 488w, https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2023\/04\/word-image-15545-2-300x181.png 300w\" sizes=\"(max-width: 488px) 100vw, 488px\" \/><\/figure>\n\n\n\n<p>And our target for April will be <strong>10 percent higher<\/strong> than that figure. We will calculate the <strong>TARGET<\/strong> by using the following formula in <strong>cell F2<\/strong>:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>=E2+(E2*0.1)<\/code><\/pre>\n\n\n\n<p>We will drag the formula till the end of our range, and will end up with the following results:<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"570\" height=\"296\" src=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2023\/04\/word-image-15545-3.png\" alt=\"\" class=\"wp-image-15548\" srcset=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2023\/04\/word-image-15545-3.png 570w, https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2023\/04\/word-image-15545-3-300x156.png 300w\" sizes=\"(max-width: 570px) 100vw, 570px\" \/><\/figure>\n\n\n\n<p>We last need to get <strong>April numbers<\/strong> and compare them with the <strong>Target figures<\/strong>. We will do that by subtracting the two, and get the following results:<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"783\" height=\"296\" src=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2023\/04\/word-image-15545-4.png\" alt=\"\" class=\"wp-image-15549\" srcset=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2023\/04\/word-image-15545-4.png 783w, https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2023\/04\/word-image-15545-4-300x113.png 300w, https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2023\/04\/word-image-15545-4-768x290.png 768w\" sizes=\"(max-width: 783px) 100vw, 783px\" \/><\/figure>\n\n\n\n<p>This way, we get to see who achieved the results and who did not.<\/p>\n\n\n\n<p>So, although the integrated formula for <strong>Target does not exist<\/strong> in Excel, we can combine existing formulas to compare the target figures with the ones that were actually achieved.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>We can always use Excel formulas for their initial purposes, but we can also deploy them for different purposes. If we are working&#8230;<\/p>\n","protected":false},"author":4,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[23],"tags":[170],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v22.3 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Target Formula in Excel<\/title>\n<meta name=\"description\" content=\"Learn how to use existing Excel formulas to calculate targets based on input values. Download the &quot;Target Formula in Excel&quot; file here.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/officetuts.net\/excel\/formulas\/target-formula-in-excel\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Target Formula in Excel\" \/>\n<meta property=\"og:description\" content=\"Learn how to use existing Excel formulas to calculate targets based on input values. Download the &quot;Target Formula in Excel&quot; file here.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/officetuts.net\/excel\/formulas\/target-formula-in-excel\/\" \/>\n<meta property=\"article:published_time\" content=\"2023-04-19T18:24:15+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-02-19T14:52:12+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2023\/04\/word-image-15545-1.png\" \/>\n<meta name=\"author\" content=\"Harun Spahic\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Harun Spahic\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/officetuts.net\/excel\/formulas\/target-formula-in-excel\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/officetuts.net\/excel\/formulas\/target-formula-in-excel\/\"},\"author\":{\"name\":\"Harun Spahic\",\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/694491c70f776081acdac4ae41f222a2\"},\"headline\":\"Target Formula in Excel\",\"datePublished\":\"2023-04-19T18:24:15+00:00\",\"dateModified\":\"2024-02-19T14:52:12+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/officetuts.net\/excel\/formulas\/target-formula-in-excel\/\"},\"wordCount\":251,\"publisher\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\"},\"image\":{\"@id\":\"https:\/\/officetuts.net\/excel\/formulas\/target-formula-in-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2023\/04\/word-image-15545-1.png\",\"keywords\":[\"file\"],\"articleSection\":[\"formulas\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/officetuts.net\/excel\/formulas\/target-formula-in-excel\/\",\"url\":\"https:\/\/officetuts.net\/excel\/formulas\/target-formula-in-excel\/\",\"name\":\"Target Formula in Excel\",\"isPartOf\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/officetuts.net\/excel\/formulas\/target-formula-in-excel\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/officetuts.net\/excel\/formulas\/target-formula-in-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2023\/04\/word-image-15545-1.png\",\"datePublished\":\"2023-04-19T18:24:15+00:00\",\"dateModified\":\"2024-02-19T14:52:12+00:00\",\"description\":\"Learn how to use existing Excel formulas to calculate targets based on input values. Download the \\\"Target Formula in Excel\\\" file here.\",\"breadcrumb\":{\"@id\":\"https:\/\/officetuts.net\/excel\/formulas\/target-formula-in-excel\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/officetuts.net\/excel\/formulas\/target-formula-in-excel\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/officetuts.net\/excel\/formulas\/target-formula-in-excel\/#primaryimage\",\"url\":\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2023\/04\/word-image-15545-1.png\",\"contentUrl\":\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2023\/04\/word-image-15545-1.png\",\"width\":396,\"height\":244},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/officetuts.net\/excel\/formulas\/target-formula-in-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/officetuts.net\/excel\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Target Formula in Excel\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/officetuts.net\/excel\/#website\",\"url\":\"https:\/\/officetuts.net\/excel\/\",\"name\":\"\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/officetuts.net\/excel\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\",\"name\":\"Tomasz Decker\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g\",\"caption\":\"Tomasz Decker\"},\"logo\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/\"},\"description\":\"Spreadsheet and Python enthusiast.\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/694491c70f776081acdac4ae41f222a2\",\"name\":\"Harun Spahic\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/b7b887a2249679182be5550a4421a7a9?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/b7b887a2249679182be5550a4421a7a9?s=96&d=mm&r=g\",\"caption\":\"Harun Spahic\"},\"sameAs\":[\"http:\/\/human.bsru.ac.th\/\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Target Formula in Excel","description":"Learn how to use existing Excel formulas to calculate targets based on input values. Download the \"Target Formula in Excel\" file here.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/officetuts.net\/excel\/formulas\/target-formula-in-excel\/","og_locale":"en_US","og_type":"article","og_title":"Target Formula in Excel","og_description":"Learn how to use existing Excel formulas to calculate targets based on input values. Download the \"Target Formula in Excel\" file here.","og_url":"https:\/\/officetuts.net\/excel\/formulas\/target-formula-in-excel\/","article_published_time":"2023-04-19T18:24:15+00:00","article_modified_time":"2024-02-19T14:52:12+00:00","og_image":[{"url":"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2023\/04\/word-image-15545-1.png"}],"author":"Harun Spahic","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Harun Spahic","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/officetuts.net\/excel\/formulas\/target-formula-in-excel\/#article","isPartOf":{"@id":"https:\/\/officetuts.net\/excel\/formulas\/target-formula-in-excel\/"},"author":{"name":"Harun Spahic","@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/694491c70f776081acdac4ae41f222a2"},"headline":"Target Formula in Excel","datePublished":"2023-04-19T18:24:15+00:00","dateModified":"2024-02-19T14:52:12+00:00","mainEntityOfPage":{"@id":"https:\/\/officetuts.net\/excel\/formulas\/target-formula-in-excel\/"},"wordCount":251,"publisher":{"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42"},"image":{"@id":"https:\/\/officetuts.net\/excel\/formulas\/target-formula-in-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2023\/04\/word-image-15545-1.png","keywords":["file"],"articleSection":["formulas"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/officetuts.net\/excel\/formulas\/target-formula-in-excel\/","url":"https:\/\/officetuts.net\/excel\/formulas\/target-formula-in-excel\/","name":"Target Formula in Excel","isPartOf":{"@id":"https:\/\/officetuts.net\/excel\/#website"},"primaryImageOfPage":{"@id":"https:\/\/officetuts.net\/excel\/formulas\/target-formula-in-excel\/#primaryimage"},"image":{"@id":"https:\/\/officetuts.net\/excel\/formulas\/target-formula-in-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2023\/04\/word-image-15545-1.png","datePublished":"2023-04-19T18:24:15+00:00","dateModified":"2024-02-19T14:52:12+00:00","description":"Learn how to use existing Excel formulas to calculate targets based on input values. Download the \"Target Formula in Excel\" file here.","breadcrumb":{"@id":"https:\/\/officetuts.net\/excel\/formulas\/target-formula-in-excel\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/officetuts.net\/excel\/formulas\/target-formula-in-excel\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/officetuts.net\/excel\/formulas\/target-formula-in-excel\/#primaryimage","url":"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2023\/04\/word-image-15545-1.png","contentUrl":"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2023\/04\/word-image-15545-1.png","width":396,"height":244},{"@type":"BreadcrumbList","@id":"https:\/\/officetuts.net\/excel\/formulas\/target-formula-in-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/officetuts.net\/excel\/"},{"@type":"ListItem","position":2,"name":"Target Formula in Excel"}]},{"@type":"WebSite","@id":"https:\/\/officetuts.net\/excel\/#website","url":"https:\/\/officetuts.net\/excel\/","name":"","description":"","publisher":{"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/officetuts.net\/excel\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42","name":"Tomasz Decker","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g","caption":"Tomasz Decker"},"logo":{"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/"},"description":"Spreadsheet and Python enthusiast."},{"@type":"Person","@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/694491c70f776081acdac4ae41f222a2","name":"Harun Spahic","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/b7b887a2249679182be5550a4421a7a9?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/b7b887a2249679182be5550a4421a7a9?s=96&d=mm&r=g","caption":"Harun Spahic"},"sameAs":["http:\/\/human.bsru.ac.th\/"]}]}},"_links":{"self":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/15545"}],"collection":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/comments?post=15545"}],"version-history":[{"count":2,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/15545\/revisions"}],"predecessor-version":[{"id":15552,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/15545\/revisions\/15552"}],"wp:attachment":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/media?parent=15545"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/categories?post=15545"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/tags?post=15545"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}