{"id":5508,"date":"2015-03-18T21:06:08","date_gmt":"2015-03-18T21:06:08","guid":{"rendered":"http:\/\/www.markwilson.co.uk\/blog\/?p=5508"},"modified":"2015-03-18T21:06:08","modified_gmt":"2015-03-18T21:06:08","slug":"excel-formula-for-calculating-a-price-based-on-a-known-cost-and-margin-percentage","status":"publish","type":"post","link":"https:\/\/www.markwilson.co.uk\/blog\/2015\/03\/excel-formula-for-calculating-a-price-based-on-a-known-cost-and-margin-percentage.htm","title":{"rendered":"Excel formula for calculating a price, based on a known cost and margin percentage"},"content":{"rendered":"<p>A couple of years ago, I blogged about <a href=\"https:\/\/www.markwilson.co.uk\/blog\/2013\/07\/margin-or-markup.htm\">the difference between margin and markup<\/a>. Since then, there have been a number of occasions when I&#8217;ve wanted to know the formula to take two cells in Excel, one with a cost and the other with a margin\u00a0percentage, and then calculate the price. I&#8217;m sure I&#8217;ve blogged that too, but I can&#8217;t find it now &#8211; so here it is (after I worked it out again this afternoon)&#8230;<\/p>\n<p><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" class=\"alignnone\" src=\"https:\/\/i0.wp.com\/www.markwilson.co.uk\/blog\/images\/excel-margin.png?resize=215%2C153&#038;ssl=1\" alt=\"\" width=\"215\" height=\"153\" \/><\/p>\n<p>Using the example above, the formula to calculate the price in cell C2,\u00a0based on cost in A2 and margin in B2 is\u00a0<code>=A2\/(1-B2)<\/code>.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>A couple of years ago, I blogged about the difference between margin and markup. Since then, there have been a number of occasions when I&#8217;ve wanted to know the formula to take two cells in Excel, one with a cost and the other with a margin\u00a0percentage, and then calculate the price. I&#8217;m sure I&#8217;ve blogged &hellip; <a href=\"https:\/\/www.markwilson.co.uk\/blog\/2015\/03\/excel-formula-for-calculating-a-price-based-on-a-known-cost-and-margin-percentage.htm\" class=\"more-link\">Continue reading <span class=\"screen-reader-text\">Excel formula for calculating a price, based on a known cost and margin percentage<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_exactmetrics_skip_tracking":false,"_exactmetrics_sitenote_active":false,"_exactmetrics_sitenote_note":"","_exactmetrics_sitenote_category":0,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_feature_clip_id":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_post_was_ever_published":false},"categories":[38],"tags":[546,188],"class_list":["post-5508","post","type-post","status-publish","format-standard","hentry","category-inane-waffle","tag-business-management","tag-excel"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.8 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Excel formula for calculating a price, based on a known cost and margin percentage - markwilson.it<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.markwilson.co.uk\/blog\/2015\/03\/excel-formula-for-calculating-a-price-based-on-a-known-cost-and-margin-percentage.htm\" \/>\n<meta property=\"og:locale\" content=\"en_GB\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel formula for calculating a price, based on a known cost and margin percentage - markwilson.it\" \/>\n<meta property=\"og:description\" content=\"A couple of years ago, I blogged about the difference between margin and markup. Since then, there have been a number of occasions when I&#8217;ve wanted to know the formula to take two cells in Excel, one with a cost and the other with a margin\u00a0percentage, and then calculate the price. I&#8217;m sure I&#8217;ve blogged &hellip; Continue reading Excel formula for calculating a price, based on a known cost and margin percentage\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.markwilson.co.uk\/blog\/2015\/03\/excel-formula-for-calculating-a-price-based-on-a-known-cost-and-margin-percentage.htm\" \/>\n<meta property=\"og:site_name\" content=\"markwilson.it\" \/>\n<meta property=\"article:published_time\" content=\"2015-03-18T21:06:08+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.markwilson.co.uk\/blog\/images\/excel-margin.png\" \/>\n<meta name=\"author\" content=\"Mark Wilson\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@markwilsonit\" \/>\n<meta name=\"twitter:site\" content=\"@markwilsonit\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Mark Wilson\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimated reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/2015\\\/03\\\/excel-formula-for-calculating-a-price-based-on-a-known-cost-and-margin-percentage.htm#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/2015\\\/03\\\/excel-formula-for-calculating-a-price-based-on-a-known-cost-and-margin-percentage.htm\"},\"author\":{\"name\":\"Mark Wilson\",\"@id\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/#\\\/schema\\\/person\\\/98f61365e7c39d6be942174b8c4de468\"},\"headline\":\"Excel formula for calculating a price, based on a known cost and margin percentage\",\"datePublished\":\"2015-03-18T21:06:08+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/2015\\\/03\\\/excel-formula-for-calculating-a-price-based-on-a-known-cost-and-margin-percentage.htm\"},\"wordCount\":118,\"commentCount\":3,\"publisher\":{\"@id\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/#\\\/schema\\\/person\\\/98f61365e7c39d6be942174b8c4de468\"},\"image\":{\"@id\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/2015\\\/03\\\/excel-formula-for-calculating-a-price-based-on-a-known-cost-and-margin-percentage.htm#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/images\\\/excel-margin.png\",\"keywords\":[\"Business management\",\"Microsoft Excel\"],\"articleSection\":[\"Waffle and randomness\"],\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/2015\\\/03\\\/excel-formula-for-calculating-a-price-based-on-a-known-cost-and-margin-percentage.htm#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/2015\\\/03\\\/excel-formula-for-calculating-a-price-based-on-a-known-cost-and-margin-percentage.htm\",\"url\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/2015\\\/03\\\/excel-formula-for-calculating-a-price-based-on-a-known-cost-and-margin-percentage.htm\",\"name\":\"Excel formula for calculating a price, based on a known cost and margin percentage - markwilson.it\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/2015\\\/03\\\/excel-formula-for-calculating-a-price-based-on-a-known-cost-and-margin-percentage.htm#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/2015\\\/03\\\/excel-formula-for-calculating-a-price-based-on-a-known-cost-and-margin-percentage.htm#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/images\\\/excel-margin.png\",\"datePublished\":\"2015-03-18T21:06:08+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/2015\\\/03\\\/excel-formula-for-calculating-a-price-based-on-a-known-cost-and-margin-percentage.htm#breadcrumb\"},\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/2015\\\/03\\\/excel-formula-for-calculating-a-price-based-on-a-known-cost-and-margin-percentage.htm\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/2015\\\/03\\\/excel-formula-for-calculating-a-price-based-on-a-known-cost-and-margin-percentage.htm#primaryimage\",\"url\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/images\\\/excel-margin.png\",\"contentUrl\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/images\\\/excel-margin.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/2015\\\/03\\\/excel-formula-for-calculating-a-price-based-on-a-known-cost-and-margin-percentage.htm#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel formula for calculating a price, based on a known cost and margin percentage\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/\",\"name\":\"markwilson.it\",\"description\":\"get-info -class technology | write-output &gt; \\\/dev\\\/web\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/#\\\/schema\\\/person\\\/98f61365e7c39d6be942174b8c4de468\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-GB\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/#\\\/schema\\\/person\\\/98f61365e7c39d6be942174b8c4de468\",\"name\":\"Mark Wilson\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\\\/\\\/i0.wp.com\\\/www.markwilson.co.uk\\\/blog\\\/uploads\\\/image-4.png?fit=800%2C800&ssl=1\",\"url\":\"https:\\\/\\\/i0.wp.com\\\/www.markwilson.co.uk\\\/blog\\\/uploads\\\/image-4.png?fit=800%2C800&ssl=1\",\"contentUrl\":\"https:\\\/\\\/i0.wp.com\\\/www.markwilson.co.uk\\\/blog\\\/uploads\\\/image-4.png?fit=800%2C800&ssl=1\",\"width\":800,\"height\":800,\"caption\":\"Mark Wilson\"},\"logo\":{\"@id\":\"https:\\\/\\\/i0.wp.com\\\/www.markwilson.co.uk\\\/blog\\\/uploads\\\/image-4.png?fit=800%2C800&ssl=1\"},\"description\":\"A Chartered IT Professional, with recent experience in technology leadership, IT strategy and practice management roles, Mark Wilson is an Enterprise Architect in the Advisory and Management Group at risual. During a career spanning more than two decades, Mark has gained widespread recognition as an expert in his field including both industry and national press exposure. In addition to certifications from Microsoft, VMware, Red Hat, The Open Group and Axelos, Mark held a Microsoft Most Valuable Professional (MVP) award for three years and is now part of the MVP Reconnect programme. Mark is also well-known on social media and maintains an award-winning blog.\",\"sameAs\":[\"http:\\\/\\\/www.markwilson.co.uk\\\/\",\"https:\\\/\\\/www.instagram.com\\\/markwilsonuk\\\/\",\"https:\\\/\\\/www.linkedin.com\\\/in\\\/markawilson\\\/\",\"https:\\\/\\\/x.com\\\/markwilsonit\",\"https:\\\/\\\/www.youtube.com\\\/channel\\\/UCWHlZCoHRTocdvtrOJ2IL4A\"],\"url\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/author\\\/mark-wilson\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Excel formula for calculating a price, based on a known cost and margin percentage - markwilson.it","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:\/\/www.markwilson.co.uk\/blog\/2015\/03\/excel-formula-for-calculating-a-price-based-on-a-known-cost-and-margin-percentage.htm","og_locale":"en_GB","og_type":"article","og_title":"Excel formula for calculating a price, based on a known cost and margin percentage - markwilson.it","og_description":"A couple of years ago, I blogged about the difference between margin and markup. Since then, there have been a number of occasions when I&#8217;ve wanted to know the formula to take two cells in Excel, one with a cost and the other with a margin\u00a0percentage, and then calculate the price. I&#8217;m sure I&#8217;ve blogged &hellip; Continue reading Excel formula for calculating a price, based on a known cost and margin percentage","og_url":"https:\/\/www.markwilson.co.uk\/blog\/2015\/03\/excel-formula-for-calculating-a-price-based-on-a-known-cost-and-margin-percentage.htm","og_site_name":"markwilson.it","article_published_time":"2015-03-18T21:06:08+00:00","og_image":[{"url":"https:\/\/www.markwilson.co.uk\/blog\/images\/excel-margin.png","type":"","width":"","height":""}],"author":"Mark Wilson","twitter_card":"summary_large_image","twitter_creator":"@markwilsonit","twitter_site":"@markwilsonit","twitter_misc":{"Written by":"Mark Wilson","Estimated reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.markwilson.co.uk\/blog\/2015\/03\/excel-formula-for-calculating-a-price-based-on-a-known-cost-and-margin-percentage.htm#article","isPartOf":{"@id":"https:\/\/www.markwilson.co.uk\/blog\/2015\/03\/excel-formula-for-calculating-a-price-based-on-a-known-cost-and-margin-percentage.htm"},"author":{"name":"Mark Wilson","@id":"https:\/\/www.markwilson.co.uk\/blog\/#\/schema\/person\/98f61365e7c39d6be942174b8c4de468"},"headline":"Excel formula for calculating a price, based on a known cost and margin percentage","datePublished":"2015-03-18T21:06:08+00:00","mainEntityOfPage":{"@id":"https:\/\/www.markwilson.co.uk\/blog\/2015\/03\/excel-formula-for-calculating-a-price-based-on-a-known-cost-and-margin-percentage.htm"},"wordCount":118,"commentCount":3,"publisher":{"@id":"https:\/\/www.markwilson.co.uk\/blog\/#\/schema\/person\/98f61365e7c39d6be942174b8c4de468"},"image":{"@id":"https:\/\/www.markwilson.co.uk\/blog\/2015\/03\/excel-formula-for-calculating-a-price-based-on-a-known-cost-and-margin-percentage.htm#primaryimage"},"thumbnailUrl":"https:\/\/www.markwilson.co.uk\/blog\/images\/excel-margin.png","keywords":["Business management","Microsoft Excel"],"articleSection":["Waffle and randomness"],"inLanguage":"en-GB","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.markwilson.co.uk\/blog\/2015\/03\/excel-formula-for-calculating-a-price-based-on-a-known-cost-and-margin-percentage.htm#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.markwilson.co.uk\/blog\/2015\/03\/excel-formula-for-calculating-a-price-based-on-a-known-cost-and-margin-percentage.htm","url":"https:\/\/www.markwilson.co.uk\/blog\/2015\/03\/excel-formula-for-calculating-a-price-based-on-a-known-cost-and-margin-percentage.htm","name":"Excel formula for calculating a price, based on a known cost and margin percentage - markwilson.it","isPartOf":{"@id":"https:\/\/www.markwilson.co.uk\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.markwilson.co.uk\/blog\/2015\/03\/excel-formula-for-calculating-a-price-based-on-a-known-cost-and-margin-percentage.htm#primaryimage"},"image":{"@id":"https:\/\/www.markwilson.co.uk\/blog\/2015\/03\/excel-formula-for-calculating-a-price-based-on-a-known-cost-and-margin-percentage.htm#primaryimage"},"thumbnailUrl":"https:\/\/www.markwilson.co.uk\/blog\/images\/excel-margin.png","datePublished":"2015-03-18T21:06:08+00:00","breadcrumb":{"@id":"https:\/\/www.markwilson.co.uk\/blog\/2015\/03\/excel-formula-for-calculating-a-price-based-on-a-known-cost-and-margin-percentage.htm#breadcrumb"},"inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.markwilson.co.uk\/blog\/2015\/03\/excel-formula-for-calculating-a-price-based-on-a-known-cost-and-margin-percentage.htm"]}]},{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/www.markwilson.co.uk\/blog\/2015\/03\/excel-formula-for-calculating-a-price-based-on-a-known-cost-and-margin-percentage.htm#primaryimage","url":"https:\/\/www.markwilson.co.uk\/blog\/images\/excel-margin.png","contentUrl":"https:\/\/www.markwilson.co.uk\/blog\/images\/excel-margin.png"},{"@type":"BreadcrumbList","@id":"https:\/\/www.markwilson.co.uk\/blog\/2015\/03\/excel-formula-for-calculating-a-price-based-on-a-known-cost-and-margin-percentage.htm#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.markwilson.co.uk\/blog"},{"@type":"ListItem","position":2,"name":"Excel formula for calculating a price, based on a known cost and margin percentage"}]},{"@type":"WebSite","@id":"https:\/\/www.markwilson.co.uk\/blog\/#website","url":"https:\/\/www.markwilson.co.uk\/blog\/","name":"markwilson.it","description":"get-info -class technology | write-output &gt; \/dev\/web","publisher":{"@id":"https:\/\/www.markwilson.co.uk\/blog\/#\/schema\/person\/98f61365e7c39d6be942174b8c4de468"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.markwilson.co.uk\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-GB"},{"@type":["Person","Organization"],"@id":"https:\/\/www.markwilson.co.uk\/blog\/#\/schema\/person\/98f61365e7c39d6be942174b8c4de468","name":"Mark Wilson","image":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/i0.wp.com\/www.markwilson.co.uk\/blog\/uploads\/image-4.png?fit=800%2C800&ssl=1","url":"https:\/\/i0.wp.com\/www.markwilson.co.uk\/blog\/uploads\/image-4.png?fit=800%2C800&ssl=1","contentUrl":"https:\/\/i0.wp.com\/www.markwilson.co.uk\/blog\/uploads\/image-4.png?fit=800%2C800&ssl=1","width":800,"height":800,"caption":"Mark Wilson"},"logo":{"@id":"https:\/\/i0.wp.com\/www.markwilson.co.uk\/blog\/uploads\/image-4.png?fit=800%2C800&ssl=1"},"description":"A Chartered IT Professional, with recent experience in technology leadership, IT strategy and practice management roles, Mark Wilson is an Enterprise Architect in the Advisory and Management Group at risual. During a career spanning more than two decades, Mark has gained widespread recognition as an expert in his field including both industry and national press exposure. In addition to certifications from Microsoft, VMware, Red Hat, The Open Group and Axelos, Mark held a Microsoft Most Valuable Professional (MVP) award for three years and is now part of the MVP Reconnect programme. Mark is also well-known on social media and maintains an award-winning blog.","sameAs":["http:\/\/www.markwilson.co.uk\/","https:\/\/www.instagram.com\/markwilsonuk\/","https:\/\/www.linkedin.com\/in\/markawilson\/","https:\/\/x.com\/markwilsonit","https:\/\/www.youtube.com\/channel\/UCWHlZCoHRTocdvtrOJ2IL4A"],"url":"https:\/\/www.markwilson.co.uk\/blog\/author\/mark-wilson"}]}},"jetpack_featured_media_url":"","jetpack-related-posts":[{"id":4965,"url":"https:\/\/www.markwilson.co.uk\/blog\/2013\/07\/business-intelligence-required.htm","url_meta":{"origin":5508,"position":0},"title":"Business intelligence required&#8230;","author":"Mark Wilson","date":"Tuesday 16 July 2013","format":false,"excerpt":"Up and down the country, businesses are running on Excel, instead of using a proper business intelligence (or even management information) system. The one I look after is no different but, as I pieced together yet another spreadsheet last weekend, I learned a few Excel tips that might be useful\u2026","rel":"","context":"In &quot;Technology&quot;","block_context":{"text":"Technology","link":"https:\/\/www.markwilson.co.uk\/blog\/topic\/technology"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":4682,"url":"https:\/\/www.markwilson.co.uk\/blog\/2013\/01\/formulas-shown-in-excel-instead-of-the-results.htm","url_meta":{"origin":5508,"position":1},"title":"Formulas shown in Excel, instead of their results","author":"Mark Wilson","date":"Wednesday 2 January 2013","format":false,"excerpt":"Every month or so, I have to create a report which is extracted from SharePoint to Excel, and then a couple of extra columns are added with information required by a colleague. The additional columns simply present existing information in a different format but, for some reason, after pasting in\u2026","rel":"","context":"In &quot;Technology&quot;","block_context":{"text":"Technology","link":"https:\/\/www.markwilson.co.uk\/blog\/topic\/technology"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":4956,"url":"https:\/\/www.markwilson.co.uk\/blog\/2013\/07\/margin-or-markup.htm","url_meta":{"origin":5508,"position":2},"title":"Margin, or markup?","author":"Mark Wilson","date":"Thursday 11 July 2013","format":false,"excerpt":"A big chunk of my current role involves trying to convert a capability unit (with some great skills in the team, it has to be said) into a profitable business. That's not necessarily easy - changing a culture created over years where utilisation was king - as long as we\u2026","rel":"","context":"In &quot;Waffle and randomness&quot;","block_context":{"text":"Waffle and randomness","link":"https:\/\/www.markwilson.co.uk\/blog\/topic\/inane-waffle"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":5192,"url":"https:\/\/www.markwilson.co.uk\/blog\/2014\/04\/fighting-with-formulae-in-excel.htm","url_meta":{"origin":5508,"position":3},"title":"Fighting with formulae in Excel","author":"Mark Wilson","date":"Tuesday 22 April 2014","format":false,"excerpt":"Excel. Love it, or hate it, there are few of us in white collar jobs who don't have to grapple with it from time to time and, earlier this evening, after OneNote had yet again decided that syncing shared notebooks via our ageing SharePoint platform as not going to work,\u2026","rel":"","context":"In &quot;Technology&quot;","block_context":{"text":"Technology","link":"https:\/\/www.markwilson.co.uk\/blog\/topic\/technology"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":8502,"url":"https:\/\/www.markwilson.co.uk\/blog\/2023\/01\/formatting-cells-in-excel-if-they-match-a-value-in-another-column.htm","url_meta":{"origin":5508,"position":4},"title":"Formatting cells in Excel if they match a value in another column","author":"Mark Wilson","date":"Thursday 12 January 2023","format":false,"excerpt":"A few months ago, I wrote about using Excel to sort a table of names that had been created in Word. And last year, I mentioned a dynamic report I'd created with a colleague, stringing together a few formulae, some data validation and some conditionally formatted cells. Well, today, that\u2026","rel":"","context":"In &quot;Technology&quot;","block_context":{"text":"Technology","link":"https:\/\/www.markwilson.co.uk\/blog\/topic\/technology"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/www.markwilson.co.uk\/blog\/uploads\/Screenshot-2023-01-12-175952.png?fit=771%2C553&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/www.markwilson.co.uk\/blog\/uploads\/Screenshot-2023-01-12-175952.png?fit=771%2C553&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/www.markwilson.co.uk\/blog\/uploads\/Screenshot-2023-01-12-175952.png?fit=771%2C553&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/www.markwilson.co.uk\/blog\/uploads\/Screenshot-2023-01-12-175952.png?fit=771%2C553&ssl=1&resize=700%2C400 2x"},"classes":[]},{"id":5649,"url":"https:\/\/www.markwilson.co.uk\/blog\/2015\/05\/short-takes-symbols-in-office-applications-and-converting-numbers-to-text-in-excel.htm","url_meta":{"origin":5508,"position":5},"title":"Short takes: Symbols in Office applications and converting numbers to text in Excel","author":"Mark Wilson","date":"Sunday 17 May 2015","format":false,"excerpt":"A few snippets I found on scraps of paper whilst sorting\u00a0out my office this\u00a0week... Shortcuts to\u00a0symbols in Office applications Many people will be familiar with typing (c) to generate a \u00a9 symbol in Microsoft Office applications but you can also use (R) or (TM) for trademark symbols \u00ae and \u2122.\u2026","rel":"","context":"In &quot;Technology&quot;","block_context":{"text":"Technology","link":"https:\/\/www.markwilson.co.uk\/blog\/topic\/technology"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.markwilson.co.uk\/blog\/wp-json\/wp\/v2\/posts\/5508","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.markwilson.co.uk\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.markwilson.co.uk\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.markwilson.co.uk\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.markwilson.co.uk\/blog\/wp-json\/wp\/v2\/comments?post=5508"}],"version-history":[{"count":1,"href":"https:\/\/www.markwilson.co.uk\/blog\/wp-json\/wp\/v2\/posts\/5508\/revisions"}],"predecessor-version":[{"id":5509,"href":"https:\/\/www.markwilson.co.uk\/blog\/wp-json\/wp\/v2\/posts\/5508\/revisions\/5509"}],"wp:attachment":[{"href":"https:\/\/www.markwilson.co.uk\/blog\/wp-json\/wp\/v2\/media?parent=5508"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.markwilson.co.uk\/blog\/wp-json\/wp\/v2\/categories?post=5508"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.markwilson.co.uk\/blog\/wp-json\/wp\/v2\/tags?post=5508"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}