{"id":2523,"date":"2015-04-14T10:23:00","date_gmt":"2015-04-14T10:23:00","guid":{"rendered":"http:\/\/www.microsofttraining.net\/b\/?p=2523"},"modified":"2023-12-31T01:41:48","modified_gmt":"2023-12-31T01:41:48","slug":"bodmas-using-brackets","status":"publish","type":"post","link":"https:\/\/www.stl-training.co.uk\/b\/bodmas-using-brackets\/","title":{"rendered":"BODMAS Using Brackets"},"content":{"rendered":"<h2>Save yourself from errors with the BODMAS rule<\/h2>\n<p>A question we often hear is \u201cWhy do we need to put Brackets in Excel Formulas?\u201d<\/p>\n<p>Some formulas that you use won&#8217;t need brackets.<\/p>\n<p>If you write the formula =5+2+10,<\/p>\n<p><a href=\"https:\/\/www.stl-training.co.uk\/b\/wp-content\/uploads\/2015\/04\/Bodmas1.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-2525\" src=\"https:\/\/www.stl-training.co.uk\/b\/wp-content\/uploads\/2015\/04\/Bodmas1.jpg\" alt=\"Bodmas1\" width=\"518\" height=\"81\" \/><\/a><\/p>\n<p>It will calculate the result as 17.<\/p>\n<p><a href=\"https:\/\/www.stl-training.co.uk\/b\/wp-content\/uploads\/2015\/04\/Bodmas-1b.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-2524\" src=\"https:\/\/www.stl-training.co.uk\/b\/wp-content\/uploads\/2015\/04\/Bodmas-1b.jpg\" alt=\"Bodmas 1b\" width=\"518\" height=\"79\" \/><\/a><\/p>\n<p>There were no brackets in that formula, and it still calculated the correct result.<\/p>\n<p>If we write the formula =5+2*5 we would expect the result of 5+2 which is 7, multiplied by 5 equalling 35.<\/p>\n<p><a href=\"https:\/\/www.stl-training.co.uk\/b\/wp-content\/uploads\/2015\/04\/Bodmas2.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-2526\" src=\"https:\/\/www.stl-training.co.uk\/b\/wp-content\/uploads\/2015\/04\/Bodmas2.jpg\" alt=\"Bodmas2\" width=\"523\" height=\"82\" \/><\/a><\/p>\n<p>When we write the formula, the calculation returns 15 not 35.<\/p>\n<p><a href=\"https:\/\/www.stl-training.co.uk\/b\/wp-content\/uploads\/2015\/04\/Bodmas3.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-2527\" src=\"https:\/\/www.stl-training.co.uk\/b\/wp-content\/uploads\/2015\/04\/Bodmas3.jpg\" alt=\"Bodmas3\" width=\"516\" height=\"83\" \/><\/a><\/p>\n<p>This has occurred because Excel doesn\u2019t calculate the formulas left to right, it follows another set of rules.<\/p>\n<p><a href=\"https:\/\/www.stl-training.co.uk\/b\/wp-content\/uploads\/2015\/04\/Bodmas4.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-2530\" src=\"https:\/\/www.stl-training.co.uk\/b\/wp-content\/uploads\/2015\/04\/Bodmas4.jpg\" alt=\"Bodmas4\" width=\"1460\" height=\"369\" \/><\/a><\/p>\n<p>The priority order is referred to as BODMAS. Exponent or Power classifies as an Order, hence the O. It\u2019s clear that Excel prioritises Divide and Multiplication over Addition and Subtraction. When we wrote =5+2*5, Excel calculated the 2*5 which is 10 and then lastly it added 5.<\/p>\n<p>A pair of brackets has the highest calculation priority. If you wanted to force Excel to calculate different parts of your formula first you could place it withing a set of Brackets.<\/p>\n<p>If we correct our formula by adding the brackets =(5+2)*5 we should now expect it to calculate the brackets first.<\/p>\n<p><a href=\"https:\/\/www.stl-training.co.uk\/b\/wp-content\/uploads\/2015\/04\/Bodmas5.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-2528\" src=\"https:\/\/www.stl-training.co.uk\/b\/wp-content\/uploads\/2015\/04\/Bodmas5.jpg\" alt=\"Bodmas5\" width=\"516\" height=\"79\" \/><\/a><\/p>\n<p><a href=\"https:\/\/www.stl-training.co.uk\/b\/wp-content\/uploads\/2015\/04\/Bodmas6.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-2529\" src=\"https:\/\/www.stl-training.co.uk\/b\/wp-content\/uploads\/2015\/04\/Bodmas6.jpg\" alt=\"Bodmas6\" width=\"520\" height=\"80\" \/><\/a><\/p>\n<p>Adding the brackets has worked!<\/p>\n<p>The 5+2 in the brackets was calculated first, and then it was multiplied by 5.<\/p>\n<p>This explains why people use Brackets in Excel Formulas:<\/p>\n<ul>\n<li>They are used to make Excel Calculate different parts of a formula in a specific order<\/li>\n<li>Brackets work in pairs, if you open a Bracket you must always close it to complete the pair<\/li>\n<\/ul>\n<h3>\u00a0Additional resources:<\/h3>\n<p><a title=\"Read more\" href=\"https:\/\/www.stl-training.co.uk\/fg-39\/what-is-bodmas-formula-and-how-use-it.html\">What is a Bodmas formula and how to use it<\/a><\/p>\n<p><a href=\"http:\/\/www.sqa.org.uk\/e-learning\/ITBSS01CD\/page_15.htm\">BODMAS<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Save yourself from errors with the BODMAS rule A question we often hear is \u201cWhy do we need to put Brackets in Excel Formulas?\u201d Some formulas that you use won&#8217;t need brackets. If you write the formula =5+2+10, It will calculate the result as 17. There were no brackets in that formula, and it still [&hellip;]<\/p>\n","protected":false},"author":5,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[4,6],"tags":[39,76,185,387,439],"class_list":["post-2523","post","type-post","status-publish","format-standard","hentry","category-excel-training","category-hints-tips","tag-adding-up-error-in-excel","tag-bodmas","tag-excel-bodmas","tag-not-adding-up-in-excel","tag-priority-order-excel"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/posts\/2523","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/comments?post=2523"}],"version-history":[{"count":1,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/posts\/2523\/revisions"}],"predecessor-version":[{"id":6889,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/posts\/2523\/revisions\/6889"}],"wp:attachment":[{"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/media?parent=2523"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/categories?post=2523"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/tags?post=2523"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}