{"id":151,"date":"2013-02-07T11:05:35","date_gmt":"2013-02-07T11:05:35","guid":{"rendered":"https:\/\/blogs.glowscotland.org.uk\/nl\/ColtnessHS-ComputingScience\/?p=151"},"modified":"2013-02-07T11:05:35","modified_gmt":"2013-02-07T11:05:35","slug":"spreadsheet-formula","status":"publish","type":"post","link":"https:\/\/blogs.glowscotland.org.uk\/nl\/ColtnessHS-ComputingScience\/2013\/02\/07\/spreadsheet-formula\/","title":{"rendered":"Spreadsheet Formula"},"content":{"rendered":"<p>Today we looked at how spreadsheets use formula. Every spreadsheet formula must start with an equals sign (=), this tells the spreadsheet application to treat the cell contents as a formula.<\/p>\n<p>We use the following\u00a0mathematical\u00a0formula in spreadsheets<\/p>\n<ul>\n<li>Add +<\/li>\n<li>Subtract &#8211;<\/li>\n<li>Multiply *<\/li>\n<li>Divide \/<\/li>\n<\/ul>\n<p>The rules of BODMAS apply for complex\u00a0mathematical\u00a0conditions<\/p>\n<ul>\n<li>=A1*A5<\/li>\n<li>=A1*A5 + 5<\/li>\n<li>=A1*(A5+5)<\/li>\n<\/ul>\n<p><!--more--><\/p>\n<div data-carousel-extra='{&quot;blog_id&quot;:12638,&quot;permalink&quot;:&quot;https:\/\/blogs.glowscotland.org.uk\/nl\/ColtnessHS-ComputingScience\/2013\/02\/07\/spreadsheet-formula\/&quot;}' id='gallery-1' class='gallery galleryid-151 gallery-columns-2 gallery-size-thumbnail'><figure class='gallery-item'>\n\t\t\t<div class='gallery-icon landscape'>\n\t\t\t\t<a href='https:\/\/blogs.glowscotland.org.uk\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2013\/02\/Slide123.png'><img decoding=\"async\" width=\"150\" height=\"112\" src=\"https:\/\/glow-prod-nl.s3.eu-west-1.amazonaws.com\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2013\/02\/Slide123-150x112.png?X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&amp;X-Amz-Security-Token=IQoJb3JpZ2luX2VjEKb%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJGMEQCICLN6euxLm0t6cByhB24RRtzPX1O38VvYaZqO9mgVUxiAiB%2BXrTSe0U7cL2%2F0If5iG6eTfMap4Ri%2FXy65PFpUPBWcyq5BQhvEAUaDDI3MzU3MDE5NTQzMyIMMKChVqIGmoXYBx4cKpYFRl4UxzNyhQiU8oCpkHCj5jq9nIMO0DSnYcTzUw6zsQ3N7zIjJIkC5edR8JrIw%2Fo5wrD1WhpfUfD7UWr0QvjuSjMRqKg3Cmxs237BK6LjgddLJNYezEqtdoA3bVJgxZ0YUgvpIkAutb7hYRDf9iNFa%2FcKlM3v9QTXclLUOZxxdz7S7ov%2FIpa%2B3DQYKzk%2FJf4%2BC5lr0y9uzS9XcARdhxmW45Dqkj4qmjEMX9Jzu1eWE3Zp4lRh9y9XlrgrLFAWj5CxpslfJHGXmOBd9qRY7z8pnbfpDR0GjrvKtg2wPC9X6oNygwsQEYxwcHGqfxw%2BkAR2rjz%2FdzgRxfxgzz%2FlpWET7zHAJiZa%2FBMpyZ0X2vWKIaZ%2FToDDax2fqgbiwfZy3YTwI6dkdMxtjTIVsKH4rLkkNgwoXW7F4YxMWnFTYLkYCdgPlHYUCHRpP%2FIumJPOimyoDqpm7KA5FpvZ5ktKvKT7pkeLCVWhlOuCT0%2FAEV7uhUKCWIz8iGCnNUo38Bjp69%2ByAph0pZbJRpTA9ROxQKC8cj8UESZKKK4jBnbTcnWx%2Fm9bdO%2B7ifZpAtO%2FgcMfzCkKWftoL3Dn4Si2iX4gpr1KQ8uq4uf7JTt1YbrCfFiCqe0n0E%2Bb4znUp3Gjxa4Dmsw8PysLiGQEzy0LgCkDnnYxEyISODuApSWnB8Vzh5%2FheILWruZbnNCvFDr5yyf9GsRmiSKmMKYpDxsoqYp5oehml5A3FAGTLF%2FSM9a0wiGeFaOPsfG6XdsHH2H4ex7LXib1xDJEZpbnF1gPSYDVlE5W9SkM9ybMbhx2ZC0NaxNH1PYg1lda%2BujMzAecHzWWBhP%2FRo3%2F3oJI94CPueubfOCiVB7zdyXX27lQstTJ%2FvEJiVIwO6DUh%2FAw463N1AY6sgHWOpIapB8zJpwudKlC1GSjASc8jUiXvJSf88th2cejqHgOr%2Bdb7JqiVpi3Xn9AK6sb%2BDbU4ci8hD84aXWpiIIjKdPaFS4TgHyuLVS7NN8o0kO8Nyn%2FhiLQ6aqKRx%2B0o691XF8pGtqDxk3g2tJLi4fDhFjCgjr%2B4C5vSnkNZjW1u3K0Gh%2FVpw3hc%2BApFfY%2BV2QBEWpbtP8Vcl7DparLj845dITvO%2Fl9Vs6lpU7o892Anqzh&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47U4QYJLMLX%2F20260829%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260829T220402Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=11051792995ee8f7908d606aa641c0749031e8ab67b7e34641b651df8835dea2\" class=\"attachment-thumbnail size-thumbnail\" alt=\"\" srcset=\"https:\/\/glow-prod-nl.s3.eu-west-1.amazonaws.com\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2013\/02\/Slide123-150x112.png?X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&amp;X-Amz-Security-Token=IQoJb3JpZ2luX2VjEKb%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJGMEQCICLN6euxLm0t6cByhB24RRtzPX1O38VvYaZqO9mgVUxiAiB%2BXrTSe0U7cL2%2F0If5iG6eTfMap4Ri%2FXy65PFpUPBWcyq5BQhvEAUaDDI3MzU3MDE5NTQzMyIMMKChVqIGmoXYBx4cKpYFRl4UxzNyhQiU8oCpkHCj5jq9nIMO0DSnYcTzUw6zsQ3N7zIjJIkC5edR8JrIw%2Fo5wrD1WhpfUfD7UWr0QvjuSjMRqKg3Cmxs237BK6LjgddLJNYezEqtdoA3bVJgxZ0YUgvpIkAutb7hYRDf9iNFa%2FcKlM3v9QTXclLUOZxxdz7S7ov%2FIpa%2B3DQYKzk%2FJf4%2BC5lr0y9uzS9XcARdhxmW45Dqkj4qmjEMX9Jzu1eWE3Zp4lRh9y9XlrgrLFAWj5CxpslfJHGXmOBd9qRY7z8pnbfpDR0GjrvKtg2wPC9X6oNygwsQEYxwcHGqfxw%2BkAR2rjz%2FdzgRxfxgzz%2FlpWET7zHAJiZa%2FBMpyZ0X2vWKIaZ%2FToDDax2fqgbiwfZy3YTwI6dkdMxtjTIVsKH4rLkkNgwoXW7F4YxMWnFTYLkYCdgPlHYUCHRpP%2FIumJPOimyoDqpm7KA5FpvZ5ktKvKT7pkeLCVWhlOuCT0%2FAEV7uhUKCWIz8iGCnNUo38Bjp69%2ByAph0pZbJRpTA9ROxQKC8cj8UESZKKK4jBnbTcnWx%2Fm9bdO%2B7ifZpAtO%2FgcMfzCkKWftoL3Dn4Si2iX4gpr1KQ8uq4uf7JTt1YbrCfFiCqe0n0E%2Bb4znUp3Gjxa4Dmsw8PysLiGQEzy0LgCkDnnYxEyISODuApSWnB8Vzh5%2FheILWruZbnNCvFDr5yyf9GsRmiSKmMKYpDxsoqYp5oehml5A3FAGTLF%2FSM9a0wiGeFaOPsfG6XdsHH2H4ex7LXib1xDJEZpbnF1gPSYDVlE5W9SkM9ybMbhx2ZC0NaxNH1PYg1lda%2BujMzAecHzWWBhP%2FRo3%2F3oJI94CPueubfOCiVB7zdyXX27lQstTJ%2FvEJiVIwO6DUh%2FAw463N1AY6sgHWOpIapB8zJpwudKlC1GSjASc8jUiXvJSf88th2cejqHgOr%2Bdb7JqiVpi3Xn9AK6sb%2BDbU4ci8hD84aXWpiIIjKdPaFS4TgHyuLVS7NN8o0kO8Nyn%2FhiLQ6aqKRx%2B0o691XF8pGtqDxk3g2tJLi4fDhFjCgjr%2B4C5vSnkNZjW1u3K0Gh%2FVpw3hc%2BApFfY%2BV2QBEWpbtP8Vcl7DparLj845dITvO%2Fl9Vs6lpU7o892Anqzh&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47U4QYJLMLX%2F20260829%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260829T220402Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=11051792995ee8f7908d606aa641c0749031e8ab67b7e34641b651df8835dea2 150w, https:\/\/glow-prod-nl.s3.eu-west-1.amazonaws.com\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2013\/02\/Slide123-300x225.png?X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&amp;X-Amz-Security-Token=IQoJb3JpZ2luX2VjEKb%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJGMEQCICLN6euxLm0t6cByhB24RRtzPX1O38VvYaZqO9mgVUxiAiB%2BXrTSe0U7cL2%2F0If5iG6eTfMap4Ri%2FXy65PFpUPBWcyq5BQhvEAUaDDI3MzU3MDE5NTQzMyIMMKChVqIGmoXYBx4cKpYFRl4UxzNyhQiU8oCpkHCj5jq9nIMO0DSnYcTzUw6zsQ3N7zIjJIkC5edR8JrIw%2Fo5wrD1WhpfUfD7UWr0QvjuSjMRqKg3Cmxs237BK6LjgddLJNYezEqtdoA3bVJgxZ0YUgvpIkAutb7hYRDf9iNFa%2FcKlM3v9QTXclLUOZxxdz7S7ov%2FIpa%2B3DQYKzk%2FJf4%2BC5lr0y9uzS9XcARdhxmW45Dqkj4qmjEMX9Jzu1eWE3Zp4lRh9y9XlrgrLFAWj5CxpslfJHGXmOBd9qRY7z8pnbfpDR0GjrvKtg2wPC9X6oNygwsQEYxwcHGqfxw%2BkAR2rjz%2FdzgRxfxgzz%2FlpWET7zHAJiZa%2FBMpyZ0X2vWKIaZ%2FToDDax2fqgbiwfZy3YTwI6dkdMxtjTIVsKH4rLkkNgwoXW7F4YxMWnFTYLkYCdgPlHYUCHRpP%2FIumJPOimyoDqpm7KA5FpvZ5ktKvKT7pkeLCVWhlOuCT0%2FAEV7uhUKCWIz8iGCnNUo38Bjp69%2ByAph0pZbJRpTA9ROxQKC8cj8UESZKKK4jBnbTcnWx%2Fm9bdO%2B7ifZpAtO%2FgcMfzCkKWftoL3Dn4Si2iX4gpr1KQ8uq4uf7JTt1YbrCfFiCqe0n0E%2Bb4znUp3Gjxa4Dmsw8PysLiGQEzy0LgCkDnnYxEyISODuApSWnB8Vzh5%2FheILWruZbnNCvFDr5yyf9GsRmiSKmMKYpDxsoqYp5oehml5A3FAGTLF%2FSM9a0wiGeFaOPsfG6XdsHH2H4ex7LXib1xDJEZpbnF1gPSYDVlE5W9SkM9ybMbhx2ZC0NaxNH1PYg1lda%2BujMzAecHzWWBhP%2FRo3%2F3oJI94CPueubfOCiVB7zdyXX27lQstTJ%2FvEJiVIwO6DUh%2FAw463N1AY6sgHWOpIapB8zJpwudKlC1GSjASc8jUiXvJSf88th2cejqHgOr%2Bdb7JqiVpi3Xn9AK6sb%2BDbU4ci8hD84aXWpiIIjKdPaFS4TgHyuLVS7NN8o0kO8Nyn%2FhiLQ6aqKRx%2B0o691XF8pGtqDxk3g2tJLi4fDhFjCgjr%2B4C5vSnkNZjW1u3K0Gh%2FVpw3hc%2BApFfY%2BV2QBEWpbtP8Vcl7DparLj845dITvO%2Fl9Vs6lpU7o892Anqzh&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47U4QYJLMLX%2F20260829%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260829T220402Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=56c6f4d11a38fd23db6610febafb5ef4476660efdf7c1f57058d673091a8a0f0 300w, https:\/\/blogs.glowscotland.org.uk\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2013\/02\/Slide123.png 600w\" sizes=\"(max-width: 150px) 100vw, 150px\" data-attachment-id=\"152\" data-permalink=\"https:\/\/blogs.glowscotland.org.uk\/nl\/ColtnessHS-ComputingScience\/2013\/02\/07\/spreadsheet-formula\/slide12-4\/\" data-orig-file=\"https:\/\/blogs.glowscotland.org.uk\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2013\/02\/Slide123.png\" data-orig-size=\"600,450\" data-comments-opened=\"1\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;}\" data-image-title=\"Slide12\" data-image-description=\"\" data-image-caption=\"\" data-medium-file=\"https:\/\/glow-prod-nl.s3.eu-west-1.amazonaws.com\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2013\/02\/Slide123-300x225.png?X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&amp;X-Amz-Security-Token=IQoJb3JpZ2luX2VjEKb%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJGMEQCICLN6euxLm0t6cByhB24RRtzPX1O38VvYaZqO9mgVUxiAiB%2BXrTSe0U7cL2%2F0If5iG6eTfMap4Ri%2FXy65PFpUPBWcyq5BQhvEAUaDDI3MzU3MDE5NTQzMyIMMKChVqIGmoXYBx4cKpYFRl4UxzNyhQiU8oCpkHCj5jq9nIMO0DSnYcTzUw6zsQ3N7zIjJIkC5edR8JrIw%2Fo5wrD1WhpfUfD7UWr0QvjuSjMRqKg3Cmxs237BK6LjgddLJNYezEqtdoA3bVJgxZ0YUgvpIkAutb7hYRDf9iNFa%2FcKlM3v9QTXclLUOZxxdz7S7ov%2FIpa%2B3DQYKzk%2FJf4%2BC5lr0y9uzS9XcARdhxmW45Dqkj4qmjEMX9Jzu1eWE3Zp4lRh9y9XlrgrLFAWj5CxpslfJHGXmOBd9qRY7z8pnbfpDR0GjrvKtg2wPC9X6oNygwsQEYxwcHGqfxw%2BkAR2rjz%2FdzgRxfxgzz%2FlpWET7zHAJiZa%2FBMpyZ0X2vWKIaZ%2FToDDax2fqgbiwfZy3YTwI6dkdMxtjTIVsKH4rLkkNgwoXW7F4YxMWnFTYLkYCdgPlHYUCHRpP%2FIumJPOimyoDqpm7KA5FpvZ5ktKvKT7pkeLCVWhlOuCT0%2FAEV7uhUKCWIz8iGCnNUo38Bjp69%2ByAph0pZbJRpTA9ROxQKC8cj8UESZKKK4jBnbTcnWx%2Fm9bdO%2B7ifZpAtO%2FgcMfzCkKWftoL3Dn4Si2iX4gpr1KQ8uq4uf7JTt1YbrCfFiCqe0n0E%2Bb4znUp3Gjxa4Dmsw8PysLiGQEzy0LgCkDnnYxEyISODuApSWnB8Vzh5%2FheILWruZbnNCvFDr5yyf9GsRmiSKmMKYpDxsoqYp5oehml5A3FAGTLF%2FSM9a0wiGeFaOPsfG6XdsHH2H4ex7LXib1xDJEZpbnF1gPSYDVlE5W9SkM9ybMbhx2ZC0NaxNH1PYg1lda%2BujMzAecHzWWBhP%2FRo3%2F3oJI94CPueubfOCiVB7zdyXX27lQstTJ%2FvEJiVIwO6DUh%2FAw463N1AY6sgHWOpIapB8zJpwudKlC1GSjASc8jUiXvJSf88th2cejqHgOr%2Bdb7JqiVpi3Xn9AK6sb%2BDbU4ci8hD84aXWpiIIjKdPaFS4TgHyuLVS7NN8o0kO8Nyn%2FhiLQ6aqKRx%2B0o691XF8pGtqDxk3g2tJLi4fDhFjCgjr%2B4C5vSnkNZjW1u3K0Gh%2FVpw3hc%2BApFfY%2BV2QBEWpbtP8Vcl7DparLj845dITvO%2Fl9Vs6lpU7o892Anqzh&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47U4QYJLMLX%2F20260829%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260829T220402Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=56c6f4d11a38fd23db6610febafb5ef4476660efdf7c1f57058d673091a8a0f0\" data-large-file=\"https:\/\/blogs.glowscotland.org.uk\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2013\/02\/Slide123.png\" \/><\/a>\n\t\t\t<\/div><\/figure><figure class='gallery-item'>\n\t\t\t<div class='gallery-icon landscape'>\n\t\t\t\t<a href='https:\/\/blogs.glowscotland.org.uk\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2013\/02\/Slide133.png'><img decoding=\"async\" width=\"150\" height=\"112\" src=\"https:\/\/glow-prod-nl.s3.eu-west-1.amazonaws.com\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2013\/02\/Slide133-150x112.png?X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&amp;X-Amz-Security-Token=IQoJb3JpZ2luX2VjEKb%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJGMEQCICLN6euxLm0t6cByhB24RRtzPX1O38VvYaZqO9mgVUxiAiB%2BXrTSe0U7cL2%2F0If5iG6eTfMap4Ri%2FXy65PFpUPBWcyq5BQhvEAUaDDI3MzU3MDE5NTQzMyIMMKChVqIGmoXYBx4cKpYFRl4UxzNyhQiU8oCpkHCj5jq9nIMO0DSnYcTzUw6zsQ3N7zIjJIkC5edR8JrIw%2Fo5wrD1WhpfUfD7UWr0QvjuSjMRqKg3Cmxs237BK6LjgddLJNYezEqtdoA3bVJgxZ0YUgvpIkAutb7hYRDf9iNFa%2FcKlM3v9QTXclLUOZxxdz7S7ov%2FIpa%2B3DQYKzk%2FJf4%2BC5lr0y9uzS9XcARdhxmW45Dqkj4qmjEMX9Jzu1eWE3Zp4lRh9y9XlrgrLFAWj5CxpslfJHGXmOBd9qRY7z8pnbfpDR0GjrvKtg2wPC9X6oNygwsQEYxwcHGqfxw%2BkAR2rjz%2FdzgRxfxgzz%2FlpWET7zHAJiZa%2FBMpyZ0X2vWKIaZ%2FToDDax2fqgbiwfZy3YTwI6dkdMxtjTIVsKH4rLkkNgwoXW7F4YxMWnFTYLkYCdgPlHYUCHRpP%2FIumJPOimyoDqpm7KA5FpvZ5ktKvKT7pkeLCVWhlOuCT0%2FAEV7uhUKCWIz8iGCnNUo38Bjp69%2ByAph0pZbJRpTA9ROxQKC8cj8UESZKKK4jBnbTcnWx%2Fm9bdO%2B7ifZpAtO%2FgcMfzCkKWftoL3Dn4Si2iX4gpr1KQ8uq4uf7JTt1YbrCfFiCqe0n0E%2Bb4znUp3Gjxa4Dmsw8PysLiGQEzy0LgCkDnnYxEyISODuApSWnB8Vzh5%2FheILWruZbnNCvFDr5yyf9GsRmiSKmMKYpDxsoqYp5oehml5A3FAGTLF%2FSM9a0wiGeFaOPsfG6XdsHH2H4ex7LXib1xDJEZpbnF1gPSYDVlE5W9SkM9ybMbhx2ZC0NaxNH1PYg1lda%2BujMzAecHzWWBhP%2FRo3%2F3oJI94CPueubfOCiVB7zdyXX27lQstTJ%2FvEJiVIwO6DUh%2FAw463N1AY6sgHWOpIapB8zJpwudKlC1GSjASc8jUiXvJSf88th2cejqHgOr%2Bdb7JqiVpi3Xn9AK6sb%2BDbU4ci8hD84aXWpiIIjKdPaFS4TgHyuLVS7NN8o0kO8Nyn%2FhiLQ6aqKRx%2B0o691XF8pGtqDxk3g2tJLi4fDhFjCgjr%2B4C5vSnkNZjW1u3K0Gh%2FVpw3hc%2BApFfY%2BV2QBEWpbtP8Vcl7DparLj845dITvO%2Fl9Vs6lpU7o892Anqzh&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47U4QYJLMLX%2F20260829%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260829T220402Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=572dc20ada859de17ac2cf74c31361f236ceadbc78ff385dcb289421ee13ab59\" class=\"attachment-thumbnail size-thumbnail\" alt=\"\" srcset=\"https:\/\/glow-prod-nl.s3.eu-west-1.amazonaws.com\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2013\/02\/Slide133-150x112.png?X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&amp;X-Amz-Security-Token=IQoJb3JpZ2luX2VjEKb%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJGMEQCICLN6euxLm0t6cByhB24RRtzPX1O38VvYaZqO9mgVUxiAiB%2BXrTSe0U7cL2%2F0If5iG6eTfMap4Ri%2FXy65PFpUPBWcyq5BQhvEAUaDDI3MzU3MDE5NTQzMyIMMKChVqIGmoXYBx4cKpYFRl4UxzNyhQiU8oCpkHCj5jq9nIMO0DSnYcTzUw6zsQ3N7zIjJIkC5edR8JrIw%2Fo5wrD1WhpfUfD7UWr0QvjuSjMRqKg3Cmxs237BK6LjgddLJNYezEqtdoA3bVJgxZ0YUgvpIkAutb7hYRDf9iNFa%2FcKlM3v9QTXclLUOZxxdz7S7ov%2FIpa%2B3DQYKzk%2FJf4%2BC5lr0y9uzS9XcARdhxmW45Dqkj4qmjEMX9Jzu1eWE3Zp4lRh9y9XlrgrLFAWj5CxpslfJHGXmOBd9qRY7z8pnbfpDR0GjrvKtg2wPC9X6oNygwsQEYxwcHGqfxw%2BkAR2rjz%2FdzgRxfxgzz%2FlpWET7zHAJiZa%2FBMpyZ0X2vWKIaZ%2FToDDax2fqgbiwfZy3YTwI6dkdMxtjTIVsKH4rLkkNgwoXW7F4YxMWnFTYLkYCdgPlHYUCHRpP%2FIumJPOimyoDqpm7KA5FpvZ5ktKvKT7pkeLCVWhlOuCT0%2FAEV7uhUKCWIz8iGCnNUo38Bjp69%2ByAph0pZbJRpTA9ROxQKC8cj8UESZKKK4jBnbTcnWx%2Fm9bdO%2B7ifZpAtO%2FgcMfzCkKWftoL3Dn4Si2iX4gpr1KQ8uq4uf7JTt1YbrCfFiCqe0n0E%2Bb4znUp3Gjxa4Dmsw8PysLiGQEzy0LgCkDnnYxEyISODuApSWnB8Vzh5%2FheILWruZbnNCvFDr5yyf9GsRmiSKmMKYpDxsoqYp5oehml5A3FAGTLF%2FSM9a0wiGeFaOPsfG6XdsHH2H4ex7LXib1xDJEZpbnF1gPSYDVlE5W9SkM9ybMbhx2ZC0NaxNH1PYg1lda%2BujMzAecHzWWBhP%2FRo3%2F3oJI94CPueubfOCiVB7zdyXX27lQstTJ%2FvEJiVIwO6DUh%2FAw463N1AY6sgHWOpIapB8zJpwudKlC1GSjASc8jUiXvJSf88th2cejqHgOr%2Bdb7JqiVpi3Xn9AK6sb%2BDbU4ci8hD84aXWpiIIjKdPaFS4TgHyuLVS7NN8o0kO8Nyn%2FhiLQ6aqKRx%2B0o691XF8pGtqDxk3g2tJLi4fDhFjCgjr%2B4C5vSnkNZjW1u3K0Gh%2FVpw3hc%2BApFfY%2BV2QBEWpbtP8Vcl7DparLj845dITvO%2Fl9Vs6lpU7o892Anqzh&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47U4QYJLMLX%2F20260829%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260829T220402Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=572dc20ada859de17ac2cf74c31361f236ceadbc78ff385dcb289421ee13ab59 150w, https:\/\/glow-prod-nl.s3.eu-west-1.amazonaws.com\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2013\/02\/Slide133-300x225.png?X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&amp;X-Amz-Security-Token=IQoJb3JpZ2luX2VjEKb%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJGMEQCICLN6euxLm0t6cByhB24RRtzPX1O38VvYaZqO9mgVUxiAiB%2BXrTSe0U7cL2%2F0If5iG6eTfMap4Ri%2FXy65PFpUPBWcyq5BQhvEAUaDDI3MzU3MDE5NTQzMyIMMKChVqIGmoXYBx4cKpYFRl4UxzNyhQiU8oCpkHCj5jq9nIMO0DSnYcTzUw6zsQ3N7zIjJIkC5edR8JrIw%2Fo5wrD1WhpfUfD7UWr0QvjuSjMRqKg3Cmxs237BK6LjgddLJNYezEqtdoA3bVJgxZ0YUgvpIkAutb7hYRDf9iNFa%2FcKlM3v9QTXclLUOZxxdz7S7ov%2FIpa%2B3DQYKzk%2FJf4%2BC5lr0y9uzS9XcARdhxmW45Dqkj4qmjEMX9Jzu1eWE3Zp4lRh9y9XlrgrLFAWj5CxpslfJHGXmOBd9qRY7z8pnbfpDR0GjrvKtg2wPC9X6oNygwsQEYxwcHGqfxw%2BkAR2rjz%2FdzgRxfxgzz%2FlpWET7zHAJiZa%2FBMpyZ0X2vWKIaZ%2FToDDax2fqgbiwfZy3YTwI6dkdMxtjTIVsKH4rLkkNgwoXW7F4YxMWnFTYLkYCdgPlHYUCHRpP%2FIumJPOimyoDqpm7KA5FpvZ5ktKvKT7pkeLCVWhlOuCT0%2FAEV7uhUKCWIz8iGCnNUo38Bjp69%2ByAph0pZbJRpTA9ROxQKC8cj8UESZKKK4jBnbTcnWx%2Fm9bdO%2B7ifZpAtO%2FgcMfzCkKWftoL3Dn4Si2iX4gpr1KQ8uq4uf7JTt1YbrCfFiCqe0n0E%2Bb4znUp3Gjxa4Dmsw8PysLiGQEzy0LgCkDnnYxEyISODuApSWnB8Vzh5%2FheILWruZbnNCvFDr5yyf9GsRmiSKmMKYpDxsoqYp5oehml5A3FAGTLF%2FSM9a0wiGeFaOPsfG6XdsHH2H4ex7LXib1xDJEZpbnF1gPSYDVlE5W9SkM9ybMbhx2ZC0NaxNH1PYg1lda%2BujMzAecHzWWBhP%2FRo3%2F3oJI94CPueubfOCiVB7zdyXX27lQstTJ%2FvEJiVIwO6DUh%2FAw463N1AY6sgHWOpIapB8zJpwudKlC1GSjASc8jUiXvJSf88th2cejqHgOr%2Bdb7JqiVpi3Xn9AK6sb%2BDbU4ci8hD84aXWpiIIjKdPaFS4TgHyuLVS7NN8o0kO8Nyn%2FhiLQ6aqKRx%2B0o691XF8pGtqDxk3g2tJLi4fDhFjCgjr%2B4C5vSnkNZjW1u3K0Gh%2FVpw3hc%2BApFfY%2BV2QBEWpbtP8Vcl7DparLj845dITvO%2Fl9Vs6lpU7o892Anqzh&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47U4QYJLMLX%2F20260829%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260829T220402Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=d351a018dd70d9f216d9c7060237700624f20434e39fd0ae06fb57a369c3d380 300w, https:\/\/blogs.glowscotland.org.uk\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2013\/02\/Slide133.png 600w\" sizes=\"(max-width: 150px) 100vw, 150px\" data-attachment-id=\"153\" data-permalink=\"https:\/\/blogs.glowscotland.org.uk\/nl\/ColtnessHS-ComputingScience\/2013\/02\/07\/spreadsheet-formula\/slide13-4\/\" data-orig-file=\"https:\/\/blogs.glowscotland.org.uk\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2013\/02\/Slide133.png\" data-orig-size=\"600,450\" data-comments-opened=\"1\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;}\" data-image-title=\"Slide13\" data-image-description=\"\" data-image-caption=\"\" data-medium-file=\"https:\/\/glow-prod-nl.s3.eu-west-1.amazonaws.com\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2013\/02\/Slide133-300x225.png?X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&amp;X-Amz-Security-Token=IQoJb3JpZ2luX2VjEKb%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJGMEQCICLN6euxLm0t6cByhB24RRtzPX1O38VvYaZqO9mgVUxiAiB%2BXrTSe0U7cL2%2F0If5iG6eTfMap4Ri%2FXy65PFpUPBWcyq5BQhvEAUaDDI3MzU3MDE5NTQzMyIMMKChVqIGmoXYBx4cKpYFRl4UxzNyhQiU8oCpkHCj5jq9nIMO0DSnYcTzUw6zsQ3N7zIjJIkC5edR8JrIw%2Fo5wrD1WhpfUfD7UWr0QvjuSjMRqKg3Cmxs237BK6LjgddLJNYezEqtdoA3bVJgxZ0YUgvpIkAutb7hYRDf9iNFa%2FcKlM3v9QTXclLUOZxxdz7S7ov%2FIpa%2B3DQYKzk%2FJf4%2BC5lr0y9uzS9XcARdhxmW45Dqkj4qmjEMX9Jzu1eWE3Zp4lRh9y9XlrgrLFAWj5CxpslfJHGXmOBd9qRY7z8pnbfpDR0GjrvKtg2wPC9X6oNygwsQEYxwcHGqfxw%2BkAR2rjz%2FdzgRxfxgzz%2FlpWET7zHAJiZa%2FBMpyZ0X2vWKIaZ%2FToDDax2fqgbiwfZy3YTwI6dkdMxtjTIVsKH4rLkkNgwoXW7F4YxMWnFTYLkYCdgPlHYUCHRpP%2FIumJPOimyoDqpm7KA5FpvZ5ktKvKT7pkeLCVWhlOuCT0%2FAEV7uhUKCWIz8iGCnNUo38Bjp69%2ByAph0pZbJRpTA9ROxQKC8cj8UESZKKK4jBnbTcnWx%2Fm9bdO%2B7ifZpAtO%2FgcMfzCkKWftoL3Dn4Si2iX4gpr1KQ8uq4uf7JTt1YbrCfFiCqe0n0E%2Bb4znUp3Gjxa4Dmsw8PysLiGQEzy0LgCkDnnYxEyISODuApSWnB8Vzh5%2FheILWruZbnNCvFDr5yyf9GsRmiSKmMKYpDxsoqYp5oehml5A3FAGTLF%2FSM9a0wiGeFaOPsfG6XdsHH2H4ex7LXib1xDJEZpbnF1gPSYDVlE5W9SkM9ybMbhx2ZC0NaxNH1PYg1lda%2BujMzAecHzWWBhP%2FRo3%2F3oJI94CPueubfOCiVB7zdyXX27lQstTJ%2FvEJiVIwO6DUh%2FAw463N1AY6sgHWOpIapB8zJpwudKlC1GSjASc8jUiXvJSf88th2cejqHgOr%2Bdb7JqiVpi3Xn9AK6sb%2BDbU4ci8hD84aXWpiIIjKdPaFS4TgHyuLVS7NN8o0kO8Nyn%2FhiLQ6aqKRx%2B0o691XF8pGtqDxk3g2tJLi4fDhFjCgjr%2B4C5vSnkNZjW1u3K0Gh%2FVpw3hc%2BApFfY%2BV2QBEWpbtP8Vcl7DparLj845dITvO%2Fl9Vs6lpU7o892Anqzh&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47U4QYJLMLX%2F20260829%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260829T220402Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=d351a018dd70d9f216d9c7060237700624f20434e39fd0ae06fb57a369c3d380\" data-large-file=\"https:\/\/blogs.glowscotland.org.uk\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2013\/02\/Slide133.png\" \/><\/a>\n\t\t\t<\/div><\/figure><figure class='gallery-item'>\n\t\t\t<div class='gallery-icon landscape'>\n\t\t\t\t<a href='https:\/\/blogs.glowscotland.org.uk\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2013\/02\/Slide143.png'><img decoding=\"async\" width=\"150\" height=\"112\" src=\"https:\/\/glow-prod-nl.s3.eu-west-1.amazonaws.com\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2013\/02\/Slide143-150x112.png?X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&amp;X-Amz-Security-Token=IQoJb3JpZ2luX2VjEKb%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJGMEQCICLN6euxLm0t6cByhB24RRtzPX1O38VvYaZqO9mgVUxiAiB%2BXrTSe0U7cL2%2F0If5iG6eTfMap4Ri%2FXy65PFpUPBWcyq5BQhvEAUaDDI3MzU3MDE5NTQzMyIMMKChVqIGmoXYBx4cKpYFRl4UxzNyhQiU8oCpkHCj5jq9nIMO0DSnYcTzUw6zsQ3N7zIjJIkC5edR8JrIw%2Fo5wrD1WhpfUfD7UWr0QvjuSjMRqKg3Cmxs237BK6LjgddLJNYezEqtdoA3bVJgxZ0YUgvpIkAutb7hYRDf9iNFa%2FcKlM3v9QTXclLUOZxxdz7S7ov%2FIpa%2B3DQYKzk%2FJf4%2BC5lr0y9uzS9XcARdhxmW45Dqkj4qmjEMX9Jzu1eWE3Zp4lRh9y9XlrgrLFAWj5CxpslfJHGXmOBd9qRY7z8pnbfpDR0GjrvKtg2wPC9X6oNygwsQEYxwcHGqfxw%2BkAR2rjz%2FdzgRxfxgzz%2FlpWET7zHAJiZa%2FBMpyZ0X2vWKIaZ%2FToDDax2fqgbiwfZy3YTwI6dkdMxtjTIVsKH4rLkkNgwoXW7F4YxMWnFTYLkYCdgPlHYUCHRpP%2FIumJPOimyoDqpm7KA5FpvZ5ktKvKT7pkeLCVWhlOuCT0%2FAEV7uhUKCWIz8iGCnNUo38Bjp69%2ByAph0pZbJRpTA9ROxQKC8cj8UESZKKK4jBnbTcnWx%2Fm9bdO%2B7ifZpAtO%2FgcMfzCkKWftoL3Dn4Si2iX4gpr1KQ8uq4uf7JTt1YbrCfFiCqe0n0E%2Bb4znUp3Gjxa4Dmsw8PysLiGQEzy0LgCkDnnYxEyISODuApSWnB8Vzh5%2FheILWruZbnNCvFDr5yyf9GsRmiSKmMKYpDxsoqYp5oehml5A3FAGTLF%2FSM9a0wiGeFaOPsfG6XdsHH2H4ex7LXib1xDJEZpbnF1gPSYDVlE5W9SkM9ybMbhx2ZC0NaxNH1PYg1lda%2BujMzAecHzWWBhP%2FRo3%2F3oJI94CPueubfOCiVB7zdyXX27lQstTJ%2FvEJiVIwO6DUh%2FAw463N1AY6sgHWOpIapB8zJpwudKlC1GSjASc8jUiXvJSf88th2cejqHgOr%2Bdb7JqiVpi3Xn9AK6sb%2BDbU4ci8hD84aXWpiIIjKdPaFS4TgHyuLVS7NN8o0kO8Nyn%2FhiLQ6aqKRx%2B0o691XF8pGtqDxk3g2tJLi4fDhFjCgjr%2B4C5vSnkNZjW1u3K0Gh%2FVpw3hc%2BApFfY%2BV2QBEWpbtP8Vcl7DparLj845dITvO%2Fl9Vs6lpU7o892Anqzh&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47U4QYJLMLX%2F20260829%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260829T220402Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=4ecfe2af03050d9c4c227131719d918364dc2d65f43aebfba578cce884514010\" class=\"attachment-thumbnail size-thumbnail\" alt=\"\" srcset=\"https:\/\/glow-prod-nl.s3.eu-west-1.amazonaws.com\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2013\/02\/Slide143-150x112.png?X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&amp;X-Amz-Security-Token=IQoJb3JpZ2luX2VjEKb%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJGMEQCICLN6euxLm0t6cByhB24RRtzPX1O38VvYaZqO9mgVUxiAiB%2BXrTSe0U7cL2%2F0If5iG6eTfMap4Ri%2FXy65PFpUPBWcyq5BQhvEAUaDDI3MzU3MDE5NTQzMyIMMKChVqIGmoXYBx4cKpYFRl4UxzNyhQiU8oCpkHCj5jq9nIMO0DSnYcTzUw6zsQ3N7zIjJIkC5edR8JrIw%2Fo5wrD1WhpfUfD7UWr0QvjuSjMRqKg3Cmxs237BK6LjgddLJNYezEqtdoA3bVJgxZ0YUgvpIkAutb7hYRDf9iNFa%2FcKlM3v9QTXclLUOZxxdz7S7ov%2FIpa%2B3DQYKzk%2FJf4%2BC5lr0y9uzS9XcARdhxmW45Dqkj4qmjEMX9Jzu1eWE3Zp4lRh9y9XlrgrLFAWj5CxpslfJHGXmOBd9qRY7z8pnbfpDR0GjrvKtg2wPC9X6oNygwsQEYxwcHGqfxw%2BkAR2rjz%2FdzgRxfxgzz%2FlpWET7zHAJiZa%2FBMpyZ0X2vWKIaZ%2FToDDax2fqgbiwfZy3YTwI6dkdMxtjTIVsKH4rLkkNgwoXW7F4YxMWnFTYLkYCdgPlHYUCHRpP%2FIumJPOimyoDqpm7KA5FpvZ5ktKvKT7pkeLCVWhlOuCT0%2FAEV7uhUKCWIz8iGCnNUo38Bjp69%2ByAph0pZbJRpTA9ROxQKC8cj8UESZKKK4jBnbTcnWx%2Fm9bdO%2B7ifZpAtO%2FgcMfzCkKWftoL3Dn4Si2iX4gpr1KQ8uq4uf7JTt1YbrCfFiCqe0n0E%2Bb4znUp3Gjxa4Dmsw8PysLiGQEzy0LgCkDnnYxEyISODuApSWnB8Vzh5%2FheILWruZbnNCvFDr5yyf9GsRmiSKmMKYpDxsoqYp5oehml5A3FAGTLF%2FSM9a0wiGeFaOPsfG6XdsHH2H4ex7LXib1xDJEZpbnF1gPSYDVlE5W9SkM9ybMbhx2ZC0NaxNH1PYg1lda%2BujMzAecHzWWBhP%2FRo3%2F3oJI94CPueubfOCiVB7zdyXX27lQstTJ%2FvEJiVIwO6DUh%2FAw463N1AY6sgHWOpIapB8zJpwudKlC1GSjASc8jUiXvJSf88th2cejqHgOr%2Bdb7JqiVpi3Xn9AK6sb%2BDbU4ci8hD84aXWpiIIjKdPaFS4TgHyuLVS7NN8o0kO8Nyn%2FhiLQ6aqKRx%2B0o691XF8pGtqDxk3g2tJLi4fDhFjCgjr%2B4C5vSnkNZjW1u3K0Gh%2FVpw3hc%2BApFfY%2BV2QBEWpbtP8Vcl7DparLj845dITvO%2Fl9Vs6lpU7o892Anqzh&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47U4QYJLMLX%2F20260829%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260829T220402Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=4ecfe2af03050d9c4c227131719d918364dc2d65f43aebfba578cce884514010 150w, https:\/\/glow-prod-nl.s3.eu-west-1.amazonaws.com\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2013\/02\/Slide143-300x225.png?X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&amp;X-Amz-Security-Token=IQoJb3JpZ2luX2VjEKb%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJGMEQCICLN6euxLm0t6cByhB24RRtzPX1O38VvYaZqO9mgVUxiAiB%2BXrTSe0U7cL2%2F0If5iG6eTfMap4Ri%2FXy65PFpUPBWcyq5BQhvEAUaDDI3MzU3MDE5NTQzMyIMMKChVqIGmoXYBx4cKpYFRl4UxzNyhQiU8oCpkHCj5jq9nIMO0DSnYcTzUw6zsQ3N7zIjJIkC5edR8JrIw%2Fo5wrD1WhpfUfD7UWr0QvjuSjMRqKg3Cmxs237BK6LjgddLJNYezEqtdoA3bVJgxZ0YUgvpIkAutb7hYRDf9iNFa%2FcKlM3v9QTXclLUOZxxdz7S7ov%2FIpa%2B3DQYKzk%2FJf4%2BC5lr0y9uzS9XcARdhxmW45Dqkj4qmjEMX9Jzu1eWE3Zp4lRh9y9XlrgrLFAWj5CxpslfJHGXmOBd9qRY7z8pnbfpDR0GjrvKtg2wPC9X6oNygwsQEYxwcHGqfxw%2BkAR2rjz%2FdzgRxfxgzz%2FlpWET7zHAJiZa%2FBMpyZ0X2vWKIaZ%2FToDDax2fqgbiwfZy3YTwI6dkdMxtjTIVsKH4rLkkNgwoXW7F4YxMWnFTYLkYCdgPlHYUCHRpP%2FIumJPOimyoDqpm7KA5FpvZ5ktKvKT7pkeLCVWhlOuCT0%2FAEV7uhUKCWIz8iGCnNUo38Bjp69%2ByAph0pZbJRpTA9ROxQKC8cj8UESZKKK4jBnbTcnWx%2Fm9bdO%2B7ifZpAtO%2FgcMfzCkKWftoL3Dn4Si2iX4gpr1KQ8uq4uf7JTt1YbrCfFiCqe0n0E%2Bb4znUp3Gjxa4Dmsw8PysLiGQEzy0LgCkDnnYxEyISODuApSWnB8Vzh5%2FheILWruZbnNCvFDr5yyf9GsRmiSKmMKYpDxsoqYp5oehml5A3FAGTLF%2FSM9a0wiGeFaOPsfG6XdsHH2H4ex7LXib1xDJEZpbnF1gPSYDVlE5W9SkM9ybMbhx2ZC0NaxNH1PYg1lda%2BujMzAecHzWWBhP%2FRo3%2F3oJI94CPueubfOCiVB7zdyXX27lQstTJ%2FvEJiVIwO6DUh%2FAw463N1AY6sgHWOpIapB8zJpwudKlC1GSjASc8jUiXvJSf88th2cejqHgOr%2Bdb7JqiVpi3Xn9AK6sb%2BDbU4ci8hD84aXWpiIIjKdPaFS4TgHyuLVS7NN8o0kO8Nyn%2FhiLQ6aqKRx%2B0o691XF8pGtqDxk3g2tJLi4fDhFjCgjr%2B4C5vSnkNZjW1u3K0Gh%2FVpw3hc%2BApFfY%2BV2QBEWpbtP8Vcl7DparLj845dITvO%2Fl9Vs6lpU7o892Anqzh&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47U4QYJLMLX%2F20260829%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260829T220402Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=e5f58c1c1a30dca0412ea50a85afb6627d94b82c243d0726f483d5ef0ac07400 300w, https:\/\/blogs.glowscotland.org.uk\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2013\/02\/Slide143.png 600w\" sizes=\"(max-width: 150px) 100vw, 150px\" data-attachment-id=\"154\" data-permalink=\"https:\/\/blogs.glowscotland.org.uk\/nl\/ColtnessHS-ComputingScience\/2013\/02\/07\/spreadsheet-formula\/slide14-4\/\" data-orig-file=\"https:\/\/blogs.glowscotland.org.uk\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2013\/02\/Slide143.png\" data-orig-size=\"600,450\" data-comments-opened=\"1\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;}\" data-image-title=\"Slide14\" data-image-description=\"\" data-image-caption=\"\" data-medium-file=\"https:\/\/glow-prod-nl.s3.eu-west-1.amazonaws.com\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2013\/02\/Slide143-300x225.png?X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&amp;X-Amz-Security-Token=IQoJb3JpZ2luX2VjEKb%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJGMEQCICLN6euxLm0t6cByhB24RRtzPX1O38VvYaZqO9mgVUxiAiB%2BXrTSe0U7cL2%2F0If5iG6eTfMap4Ri%2FXy65PFpUPBWcyq5BQhvEAUaDDI3MzU3MDE5NTQzMyIMMKChVqIGmoXYBx4cKpYFRl4UxzNyhQiU8oCpkHCj5jq9nIMO0DSnYcTzUw6zsQ3N7zIjJIkC5edR8JrIw%2Fo5wrD1WhpfUfD7UWr0QvjuSjMRqKg3Cmxs237BK6LjgddLJNYezEqtdoA3bVJgxZ0YUgvpIkAutb7hYRDf9iNFa%2FcKlM3v9QTXclLUOZxxdz7S7ov%2FIpa%2B3DQYKzk%2FJf4%2BC5lr0y9uzS9XcARdhxmW45Dqkj4qmjEMX9Jzu1eWE3Zp4lRh9y9XlrgrLFAWj5CxpslfJHGXmOBd9qRY7z8pnbfpDR0GjrvKtg2wPC9X6oNygwsQEYxwcHGqfxw%2BkAR2rjz%2FdzgRxfxgzz%2FlpWET7zHAJiZa%2FBMpyZ0X2vWKIaZ%2FToDDax2fqgbiwfZy3YTwI6dkdMxtjTIVsKH4rLkkNgwoXW7F4YxMWnFTYLkYCdgPlHYUCHRpP%2FIumJPOimyoDqpm7KA5FpvZ5ktKvKT7pkeLCVWhlOuCT0%2FAEV7uhUKCWIz8iGCnNUo38Bjp69%2ByAph0pZbJRpTA9ROxQKC8cj8UESZKKK4jBnbTcnWx%2Fm9bdO%2B7ifZpAtO%2FgcMfzCkKWftoL3Dn4Si2iX4gpr1KQ8uq4uf7JTt1YbrCfFiCqe0n0E%2Bb4znUp3Gjxa4Dmsw8PysLiGQEzy0LgCkDnnYxEyISODuApSWnB8Vzh5%2FheILWruZbnNCvFDr5yyf9GsRmiSKmMKYpDxsoqYp5oehml5A3FAGTLF%2FSM9a0wiGeFaOPsfG6XdsHH2H4ex7LXib1xDJEZpbnF1gPSYDVlE5W9SkM9ybMbhx2ZC0NaxNH1PYg1lda%2BujMzAecHzWWBhP%2FRo3%2F3oJI94CPueubfOCiVB7zdyXX27lQstTJ%2FvEJiVIwO6DUh%2FAw463N1AY6sgHWOpIapB8zJpwudKlC1GSjASc8jUiXvJSf88th2cejqHgOr%2Bdb7JqiVpi3Xn9AK6sb%2BDbU4ci8hD84aXWpiIIjKdPaFS4TgHyuLVS7NN8o0kO8Nyn%2FhiLQ6aqKRx%2B0o691XF8pGtqDxk3g2tJLi4fDhFjCgjr%2B4C5vSnkNZjW1u3K0Gh%2FVpw3hc%2BApFfY%2BV2QBEWpbtP8Vcl7DparLj845dITvO%2Fl9Vs6lpU7o892Anqzh&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47U4QYJLMLX%2F20260829%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260829T220402Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=e5f58c1c1a30dca0412ea50a85afb6627d94b82c243d0726f483d5ef0ac07400\" data-large-file=\"https:\/\/blogs.glowscotland.org.uk\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2013\/02\/Slide143.png\" \/><\/a>\n\t\t\t<\/div><\/figure><figure class='gallery-item'>\n\t\t\t<div class='gallery-icon landscape'>\n\t\t\t\t<a href='https:\/\/blogs.glowscotland.org.uk\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2013\/02\/Slide153.png'><img decoding=\"async\" width=\"150\" height=\"112\" src=\"https:\/\/glow-prod-nl.s3.eu-west-1.amazonaws.com\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2013\/02\/Slide153-150x112.png?X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&amp;X-Amz-Security-Token=IQoJb3JpZ2luX2VjEKb%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJGMEQCICLN6euxLm0t6cByhB24RRtzPX1O38VvYaZqO9mgVUxiAiB%2BXrTSe0U7cL2%2F0If5iG6eTfMap4Ri%2FXy65PFpUPBWcyq5BQhvEAUaDDI3MzU3MDE5NTQzMyIMMKChVqIGmoXYBx4cKpYFRl4UxzNyhQiU8oCpkHCj5jq9nIMO0DSnYcTzUw6zsQ3N7zIjJIkC5edR8JrIw%2Fo5wrD1WhpfUfD7UWr0QvjuSjMRqKg3Cmxs237BK6LjgddLJNYezEqtdoA3bVJgxZ0YUgvpIkAutb7hYRDf9iNFa%2FcKlM3v9QTXclLUOZxxdz7S7ov%2FIpa%2B3DQYKzk%2FJf4%2BC5lr0y9uzS9XcARdhxmW45Dqkj4qmjEMX9Jzu1eWE3Zp4lRh9y9XlrgrLFAWj5CxpslfJHGXmOBd9qRY7z8pnbfpDR0GjrvKtg2wPC9X6oNygwsQEYxwcHGqfxw%2BkAR2rjz%2FdzgRxfxgzz%2FlpWET7zHAJiZa%2FBMpyZ0X2vWKIaZ%2FToDDax2fqgbiwfZy3YTwI6dkdMxtjTIVsKH4rLkkNgwoXW7F4YxMWnFTYLkYCdgPlHYUCHRpP%2FIumJPOimyoDqpm7KA5FpvZ5ktKvKT7pkeLCVWhlOuCT0%2FAEV7uhUKCWIz8iGCnNUo38Bjp69%2ByAph0pZbJRpTA9ROxQKC8cj8UESZKKK4jBnbTcnWx%2Fm9bdO%2B7ifZpAtO%2FgcMfzCkKWftoL3Dn4Si2iX4gpr1KQ8uq4uf7JTt1YbrCfFiCqe0n0E%2Bb4znUp3Gjxa4Dmsw8PysLiGQEzy0LgCkDnnYxEyISODuApSWnB8Vzh5%2FheILWruZbnNCvFDr5yyf9GsRmiSKmMKYpDxsoqYp5oehml5A3FAGTLF%2FSM9a0wiGeFaOPsfG6XdsHH2H4ex7LXib1xDJEZpbnF1gPSYDVlE5W9SkM9ybMbhx2ZC0NaxNH1PYg1lda%2BujMzAecHzWWBhP%2FRo3%2F3oJI94CPueubfOCiVB7zdyXX27lQstTJ%2FvEJiVIwO6DUh%2FAw463N1AY6sgHWOpIapB8zJpwudKlC1GSjASc8jUiXvJSf88th2cejqHgOr%2Bdb7JqiVpi3Xn9AK6sb%2BDbU4ci8hD84aXWpiIIjKdPaFS4TgHyuLVS7NN8o0kO8Nyn%2FhiLQ6aqKRx%2B0o691XF8pGtqDxk3g2tJLi4fDhFjCgjr%2B4C5vSnkNZjW1u3K0Gh%2FVpw3hc%2BApFfY%2BV2QBEWpbtP8Vcl7DparLj845dITvO%2Fl9Vs6lpU7o892Anqzh&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47U4QYJLMLX%2F20260829%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260829T220402Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=8eb7690dab8482ee38b27bfad06094e4b8b55f76620348a41f80732e3ff18047\" class=\"attachment-thumbnail size-thumbnail\" alt=\"\" srcset=\"https:\/\/glow-prod-nl.s3.eu-west-1.amazonaws.com\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2013\/02\/Slide153-150x112.png?X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&amp;X-Amz-Security-Token=IQoJb3JpZ2luX2VjEKb%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJGMEQCICLN6euxLm0t6cByhB24RRtzPX1O38VvYaZqO9mgVUxiAiB%2BXrTSe0U7cL2%2F0If5iG6eTfMap4Ri%2FXy65PFpUPBWcyq5BQhvEAUaDDI3MzU3MDE5NTQzMyIMMKChVqIGmoXYBx4cKpYFRl4UxzNyhQiU8oCpkHCj5jq9nIMO0DSnYcTzUw6zsQ3N7zIjJIkC5edR8JrIw%2Fo5wrD1WhpfUfD7UWr0QvjuSjMRqKg3Cmxs237BK6LjgddLJNYezEqtdoA3bVJgxZ0YUgvpIkAutb7hYRDf9iNFa%2FcKlM3v9QTXclLUOZxxdz7S7ov%2FIpa%2B3DQYKzk%2FJf4%2BC5lr0y9uzS9XcARdhxmW45Dqkj4qmjEMX9Jzu1eWE3Zp4lRh9y9XlrgrLFAWj5CxpslfJHGXmOBd9qRY7z8pnbfpDR0GjrvKtg2wPC9X6oNygwsQEYxwcHGqfxw%2BkAR2rjz%2FdzgRxfxgzz%2FlpWET7zHAJiZa%2FBMpyZ0X2vWKIaZ%2FToDDax2fqgbiwfZy3YTwI6dkdMxtjTIVsKH4rLkkNgwoXW7F4YxMWnFTYLkYCdgPlHYUCHRpP%2FIumJPOimyoDqpm7KA5FpvZ5ktKvKT7pkeLCVWhlOuCT0%2FAEV7uhUKCWIz8iGCnNUo38Bjp69%2ByAph0pZbJRpTA9ROxQKC8cj8UESZKKK4jBnbTcnWx%2Fm9bdO%2B7ifZpAtO%2FgcMfzCkKWftoL3Dn4Si2iX4gpr1KQ8uq4uf7JTt1YbrCfFiCqe0n0E%2Bb4znUp3Gjxa4Dmsw8PysLiGQEzy0LgCkDnnYxEyISODuApSWnB8Vzh5%2FheILWruZbnNCvFDr5yyf9GsRmiSKmMKYpDxsoqYp5oehml5A3FAGTLF%2FSM9a0wiGeFaOPsfG6XdsHH2H4ex7LXib1xDJEZpbnF1gPSYDVlE5W9SkM9ybMbhx2ZC0NaxNH1PYg1lda%2BujMzAecHzWWBhP%2FRo3%2F3oJI94CPueubfOCiVB7zdyXX27lQstTJ%2FvEJiVIwO6DUh%2FAw463N1AY6sgHWOpIapB8zJpwudKlC1GSjASc8jUiXvJSf88th2cejqHgOr%2Bdb7JqiVpi3Xn9AK6sb%2BDbU4ci8hD84aXWpiIIjKdPaFS4TgHyuLVS7NN8o0kO8Nyn%2FhiLQ6aqKRx%2B0o691XF8pGtqDxk3g2tJLi4fDhFjCgjr%2B4C5vSnkNZjW1u3K0Gh%2FVpw3hc%2BApFfY%2BV2QBEWpbtP8Vcl7DparLj845dITvO%2Fl9Vs6lpU7o892Anqzh&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47U4QYJLMLX%2F20260829%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260829T220402Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=8eb7690dab8482ee38b27bfad06094e4b8b55f76620348a41f80732e3ff18047 150w, https:\/\/glow-prod-nl.s3.eu-west-1.amazonaws.com\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2013\/02\/Slide153-300x225.png?X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&amp;X-Amz-Security-Token=IQoJb3JpZ2luX2VjEKb%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJGMEQCICLN6euxLm0t6cByhB24RRtzPX1O38VvYaZqO9mgVUxiAiB%2BXrTSe0U7cL2%2F0If5iG6eTfMap4Ri%2FXy65PFpUPBWcyq5BQhvEAUaDDI3MzU3MDE5NTQzMyIMMKChVqIGmoXYBx4cKpYFRl4UxzNyhQiU8oCpkHCj5jq9nIMO0DSnYcTzUw6zsQ3N7zIjJIkC5edR8JrIw%2Fo5wrD1WhpfUfD7UWr0QvjuSjMRqKg3Cmxs237BK6LjgddLJNYezEqtdoA3bVJgxZ0YUgvpIkAutb7hYRDf9iNFa%2FcKlM3v9QTXclLUOZxxdz7S7ov%2FIpa%2B3DQYKzk%2FJf4%2BC5lr0y9uzS9XcARdhxmW45Dqkj4qmjEMX9Jzu1eWE3Zp4lRh9y9XlrgrLFAWj5CxpslfJHGXmOBd9qRY7z8pnbfpDR0GjrvKtg2wPC9X6oNygwsQEYxwcHGqfxw%2BkAR2rjz%2FdzgRxfxgzz%2FlpWET7zHAJiZa%2FBMpyZ0X2vWKIaZ%2FToDDax2fqgbiwfZy3YTwI6dkdMxtjTIVsKH4rLkkNgwoXW7F4YxMWnFTYLkYCdgPlHYUCHRpP%2FIumJPOimyoDqpm7KA5FpvZ5ktKvKT7pkeLCVWhlOuCT0%2FAEV7uhUKCWIz8iGCnNUo38Bjp69%2ByAph0pZbJRpTA9ROxQKC8cj8UESZKKK4jBnbTcnWx%2Fm9bdO%2B7ifZpAtO%2FgcMfzCkKWftoL3Dn4Si2iX4gpr1KQ8uq4uf7JTt1YbrCfFiCqe0n0E%2Bb4znUp3Gjxa4Dmsw8PysLiGQEzy0LgCkDnnYxEyISODuApSWnB8Vzh5%2FheILWruZbnNCvFDr5yyf9GsRmiSKmMKYpDxsoqYp5oehml5A3FAGTLF%2FSM9a0wiGeFaOPsfG6XdsHH2H4ex7LXib1xDJEZpbnF1gPSYDVlE5W9SkM9ybMbhx2ZC0NaxNH1PYg1lda%2BujMzAecHzWWBhP%2FRo3%2F3oJI94CPueubfOCiVB7zdyXX27lQstTJ%2FvEJiVIwO6DUh%2FAw463N1AY6sgHWOpIapB8zJpwudKlC1GSjASc8jUiXvJSf88th2cejqHgOr%2Bdb7JqiVpi3Xn9AK6sb%2BDbU4ci8hD84aXWpiIIjKdPaFS4TgHyuLVS7NN8o0kO8Nyn%2FhiLQ6aqKRx%2B0o691XF8pGtqDxk3g2tJLi4fDhFjCgjr%2B4C5vSnkNZjW1u3K0Gh%2FVpw3hc%2BApFfY%2BV2QBEWpbtP8Vcl7DparLj845dITvO%2Fl9Vs6lpU7o892Anqzh&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47U4QYJLMLX%2F20260829%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260829T220402Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=ac0c58ce2f02333697d6dfb1fc64bc020296b053e2671957caba79dda34508c4 300w, https:\/\/blogs.glowscotland.org.uk\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2013\/02\/Slide153.png 600w\" sizes=\"(max-width: 150px) 100vw, 150px\" data-attachment-id=\"155\" data-permalink=\"https:\/\/blogs.glowscotland.org.uk\/nl\/ColtnessHS-ComputingScience\/2013\/02\/07\/spreadsheet-formula\/slide15-4\/\" data-orig-file=\"https:\/\/blogs.glowscotland.org.uk\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2013\/02\/Slide153.png\" data-orig-size=\"600,450\" data-comments-opened=\"1\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;}\" data-image-title=\"Slide15\" data-image-description=\"\" data-image-caption=\"\" data-medium-file=\"https:\/\/glow-prod-nl.s3.eu-west-1.amazonaws.com\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2013\/02\/Slide153-300x225.png?X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&amp;X-Amz-Security-Token=IQoJb3JpZ2luX2VjEKb%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJGMEQCICLN6euxLm0t6cByhB24RRtzPX1O38VvYaZqO9mgVUxiAiB%2BXrTSe0U7cL2%2F0If5iG6eTfMap4Ri%2FXy65PFpUPBWcyq5BQhvEAUaDDI3MzU3MDE5NTQzMyIMMKChVqIGmoXYBx4cKpYFRl4UxzNyhQiU8oCpkHCj5jq9nIMO0DSnYcTzUw6zsQ3N7zIjJIkC5edR8JrIw%2Fo5wrD1WhpfUfD7UWr0QvjuSjMRqKg3Cmxs237BK6LjgddLJNYezEqtdoA3bVJgxZ0YUgvpIkAutb7hYRDf9iNFa%2FcKlM3v9QTXclLUOZxxdz7S7ov%2FIpa%2B3DQYKzk%2FJf4%2BC5lr0y9uzS9XcARdhxmW45Dqkj4qmjEMX9Jzu1eWE3Zp4lRh9y9XlrgrLFAWj5CxpslfJHGXmOBd9qRY7z8pnbfpDR0GjrvKtg2wPC9X6oNygwsQEYxwcHGqfxw%2BkAR2rjz%2FdzgRxfxgzz%2FlpWET7zHAJiZa%2FBMpyZ0X2vWKIaZ%2FToDDax2fqgbiwfZy3YTwI6dkdMxtjTIVsKH4rLkkNgwoXW7F4YxMWnFTYLkYCdgPlHYUCHRpP%2FIumJPOimyoDqpm7KA5FpvZ5ktKvKT7pkeLCVWhlOuCT0%2FAEV7uhUKCWIz8iGCnNUo38Bjp69%2ByAph0pZbJRpTA9ROxQKC8cj8UESZKKK4jBnbTcnWx%2Fm9bdO%2B7ifZpAtO%2FgcMfzCkKWftoL3Dn4Si2iX4gpr1KQ8uq4uf7JTt1YbrCfFiCqe0n0E%2Bb4znUp3Gjxa4Dmsw8PysLiGQEzy0LgCkDnnYxEyISODuApSWnB8Vzh5%2FheILWruZbnNCvFDr5yyf9GsRmiSKmMKYpDxsoqYp5oehml5A3FAGTLF%2FSM9a0wiGeFaOPsfG6XdsHH2H4ex7LXib1xDJEZpbnF1gPSYDVlE5W9SkM9ybMbhx2ZC0NaxNH1PYg1lda%2BujMzAecHzWWBhP%2FRo3%2F3oJI94CPueubfOCiVB7zdyXX27lQstTJ%2FvEJiVIwO6DUh%2FAw463N1AY6sgHWOpIapB8zJpwudKlC1GSjASc8jUiXvJSf88th2cejqHgOr%2Bdb7JqiVpi3Xn9AK6sb%2BDbU4ci8hD84aXWpiIIjKdPaFS4TgHyuLVS7NN8o0kO8Nyn%2FhiLQ6aqKRx%2B0o691XF8pGtqDxk3g2tJLi4fDhFjCgjr%2B4C5vSnkNZjW1u3K0Gh%2FVpw3hc%2BApFfY%2BV2QBEWpbtP8Vcl7DparLj845dITvO%2Fl9Vs6lpU7o892Anqzh&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47U4QYJLMLX%2F20260829%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260829T220402Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=ac0c58ce2f02333697d6dfb1fc64bc020296b053e2671957caba79dda34508c4\" data-large-file=\"https:\/\/blogs.glowscotland.org.uk\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2013\/02\/Slide153.png\" \/><\/a>\n\t\t\t<\/div><\/figure><figure class='gallery-item'>\n\t\t\t<div class='gallery-icon landscape'>\n\t\t\t\t<a href='https:\/\/blogs.glowscotland.org.uk\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2013\/02\/Slide163.png'><img decoding=\"async\" width=\"150\" height=\"112\" src=\"https:\/\/glow-prod-nl.s3.eu-west-1.amazonaws.com\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2013\/02\/Slide163-150x112.png?X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&amp;X-Amz-Security-Token=IQoJb3JpZ2luX2VjEKb%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJGMEQCICLN6euxLm0t6cByhB24RRtzPX1O38VvYaZqO9mgVUxiAiB%2BXrTSe0U7cL2%2F0If5iG6eTfMap4Ri%2FXy65PFpUPBWcyq5BQhvEAUaDDI3MzU3MDE5NTQzMyIMMKChVqIGmoXYBx4cKpYFRl4UxzNyhQiU8oCpkHCj5jq9nIMO0DSnYcTzUw6zsQ3N7zIjJIkC5edR8JrIw%2Fo5wrD1WhpfUfD7UWr0QvjuSjMRqKg3Cmxs237BK6LjgddLJNYezEqtdoA3bVJgxZ0YUgvpIkAutb7hYRDf9iNFa%2FcKlM3v9QTXclLUOZxxdz7S7ov%2FIpa%2B3DQYKzk%2FJf4%2BC5lr0y9uzS9XcARdhxmW45Dqkj4qmjEMX9Jzu1eWE3Zp4lRh9y9XlrgrLFAWj5CxpslfJHGXmOBd9qRY7z8pnbfpDR0GjrvKtg2wPC9X6oNygwsQEYxwcHGqfxw%2BkAR2rjz%2FdzgRxfxgzz%2FlpWET7zHAJiZa%2FBMpyZ0X2vWKIaZ%2FToDDax2fqgbiwfZy3YTwI6dkdMxtjTIVsKH4rLkkNgwoXW7F4YxMWnFTYLkYCdgPlHYUCHRpP%2FIumJPOimyoDqpm7KA5FpvZ5ktKvKT7pkeLCVWhlOuCT0%2FAEV7uhUKCWIz8iGCnNUo38Bjp69%2ByAph0pZbJRpTA9ROxQKC8cj8UESZKKK4jBnbTcnWx%2Fm9bdO%2B7ifZpAtO%2FgcMfzCkKWftoL3Dn4Si2iX4gpr1KQ8uq4uf7JTt1YbrCfFiCqe0n0E%2Bb4znUp3Gjxa4Dmsw8PysLiGQEzy0LgCkDnnYxEyISODuApSWnB8Vzh5%2FheILWruZbnNCvFDr5yyf9GsRmiSKmMKYpDxsoqYp5oehml5A3FAGTLF%2FSM9a0wiGeFaOPsfG6XdsHH2H4ex7LXib1xDJEZpbnF1gPSYDVlE5W9SkM9ybMbhx2ZC0NaxNH1PYg1lda%2BujMzAecHzWWBhP%2FRo3%2F3oJI94CPueubfOCiVB7zdyXX27lQstTJ%2FvEJiVIwO6DUh%2FAw463N1AY6sgHWOpIapB8zJpwudKlC1GSjASc8jUiXvJSf88th2cejqHgOr%2Bdb7JqiVpi3Xn9AK6sb%2BDbU4ci8hD84aXWpiIIjKdPaFS4TgHyuLVS7NN8o0kO8Nyn%2FhiLQ6aqKRx%2B0o691XF8pGtqDxk3g2tJLi4fDhFjCgjr%2B4C5vSnkNZjW1u3K0Gh%2FVpw3hc%2BApFfY%2BV2QBEWpbtP8Vcl7DparLj845dITvO%2Fl9Vs6lpU7o892Anqzh&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47U4QYJLMLX%2F20260829%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260829T220402Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=0917e66dde7d8d449d8bad48c5c6f6ec772a65c4f8ee2520225cf4b8c018d689\" class=\"attachment-thumbnail size-thumbnail\" alt=\"\" srcset=\"https:\/\/glow-prod-nl.s3.eu-west-1.amazonaws.com\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2013\/02\/Slide163-150x112.png?X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&amp;X-Amz-Security-Token=IQoJb3JpZ2luX2VjEKb%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJGMEQCICLN6euxLm0t6cByhB24RRtzPX1O38VvYaZqO9mgVUxiAiB%2BXrTSe0U7cL2%2F0If5iG6eTfMap4Ri%2FXy65PFpUPBWcyq5BQhvEAUaDDI3MzU3MDE5NTQzMyIMMKChVqIGmoXYBx4cKpYFRl4UxzNyhQiU8oCpkHCj5jq9nIMO0DSnYcTzUw6zsQ3N7zIjJIkC5edR8JrIw%2Fo5wrD1WhpfUfD7UWr0QvjuSjMRqKg3Cmxs237BK6LjgddLJNYezEqtdoA3bVJgxZ0YUgvpIkAutb7hYRDf9iNFa%2FcKlM3v9QTXclLUOZxxdz7S7ov%2FIpa%2B3DQYKzk%2FJf4%2BC5lr0y9uzS9XcARdhxmW45Dqkj4qmjEMX9Jzu1eWE3Zp4lRh9y9XlrgrLFAWj5CxpslfJHGXmOBd9qRY7z8pnbfpDR0GjrvKtg2wPC9X6oNygwsQEYxwcHGqfxw%2BkAR2rjz%2FdzgRxfxgzz%2FlpWET7zHAJiZa%2FBMpyZ0X2vWKIaZ%2FToDDax2fqgbiwfZy3YTwI6dkdMxtjTIVsKH4rLkkNgwoXW7F4YxMWnFTYLkYCdgPlHYUCHRpP%2FIumJPOimyoDqpm7KA5FpvZ5ktKvKT7pkeLCVWhlOuCT0%2FAEV7uhUKCWIz8iGCnNUo38Bjp69%2ByAph0pZbJRpTA9ROxQKC8cj8UESZKKK4jBnbTcnWx%2Fm9bdO%2B7ifZpAtO%2FgcMfzCkKWftoL3Dn4Si2iX4gpr1KQ8uq4uf7JTt1YbrCfFiCqe0n0E%2Bb4znUp3Gjxa4Dmsw8PysLiGQEzy0LgCkDnnYxEyISODuApSWnB8Vzh5%2FheILWruZbnNCvFDr5yyf9GsRmiSKmMKYpDxsoqYp5oehml5A3FAGTLF%2FSM9a0wiGeFaOPsfG6XdsHH2H4ex7LXib1xDJEZpbnF1gPSYDVlE5W9SkM9ybMbhx2ZC0NaxNH1PYg1lda%2BujMzAecHzWWBhP%2FRo3%2F3oJI94CPueubfOCiVB7zdyXX27lQstTJ%2FvEJiVIwO6DUh%2FAw463N1AY6sgHWOpIapB8zJpwudKlC1GSjASc8jUiXvJSf88th2cejqHgOr%2Bdb7JqiVpi3Xn9AK6sb%2BDbU4ci8hD84aXWpiIIjKdPaFS4TgHyuLVS7NN8o0kO8Nyn%2FhiLQ6aqKRx%2B0o691XF8pGtqDxk3g2tJLi4fDhFjCgjr%2B4C5vSnkNZjW1u3K0Gh%2FVpw3hc%2BApFfY%2BV2QBEWpbtP8Vcl7DparLj845dITvO%2Fl9Vs6lpU7o892Anqzh&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47U4QYJLMLX%2F20260829%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260829T220402Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=0917e66dde7d8d449d8bad48c5c6f6ec772a65c4f8ee2520225cf4b8c018d689 150w, https:\/\/glow-prod-nl.s3.eu-west-1.amazonaws.com\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2013\/02\/Slide163-300x225.png?X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&amp;X-Amz-Security-Token=IQoJb3JpZ2luX2VjEKb%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJGMEQCICLN6euxLm0t6cByhB24RRtzPX1O38VvYaZqO9mgVUxiAiB%2BXrTSe0U7cL2%2F0If5iG6eTfMap4Ri%2FXy65PFpUPBWcyq5BQhvEAUaDDI3MzU3MDE5NTQzMyIMMKChVqIGmoXYBx4cKpYFRl4UxzNyhQiU8oCpkHCj5jq9nIMO0DSnYcTzUw6zsQ3N7zIjJIkC5edR8JrIw%2Fo5wrD1WhpfUfD7UWr0QvjuSjMRqKg3Cmxs237BK6LjgddLJNYezEqtdoA3bVJgxZ0YUgvpIkAutb7hYRDf9iNFa%2FcKlM3v9QTXclLUOZxxdz7S7ov%2FIpa%2B3DQYKzk%2FJf4%2BC5lr0y9uzS9XcARdhxmW45Dqkj4qmjEMX9Jzu1eWE3Zp4lRh9y9XlrgrLFAWj5CxpslfJHGXmOBd9qRY7z8pnbfpDR0GjrvKtg2wPC9X6oNygwsQEYxwcHGqfxw%2BkAR2rjz%2FdzgRxfxgzz%2FlpWET7zHAJiZa%2FBMpyZ0X2vWKIaZ%2FToDDax2fqgbiwfZy3YTwI6dkdMxtjTIVsKH4rLkkNgwoXW7F4YxMWnFTYLkYCdgPlHYUCHRpP%2FIumJPOimyoDqpm7KA5FpvZ5ktKvKT7pkeLCVWhlOuCT0%2FAEV7uhUKCWIz8iGCnNUo38Bjp69%2ByAph0pZbJRpTA9ROxQKC8cj8UESZKKK4jBnbTcnWx%2Fm9bdO%2B7ifZpAtO%2FgcMfzCkKWftoL3Dn4Si2iX4gpr1KQ8uq4uf7JTt1YbrCfFiCqe0n0E%2Bb4znUp3Gjxa4Dmsw8PysLiGQEzy0LgCkDnnYxEyISODuApSWnB8Vzh5%2FheILWruZbnNCvFDr5yyf9GsRmiSKmMKYpDxsoqYp5oehml5A3FAGTLF%2FSM9a0wiGeFaOPsfG6XdsHH2H4ex7LXib1xDJEZpbnF1gPSYDVlE5W9SkM9ybMbhx2ZC0NaxNH1PYg1lda%2BujMzAecHzWWBhP%2FRo3%2F3oJI94CPueubfOCiVB7zdyXX27lQstTJ%2FvEJiVIwO6DUh%2FAw463N1AY6sgHWOpIapB8zJpwudKlC1GSjASc8jUiXvJSf88th2cejqHgOr%2Bdb7JqiVpi3Xn9AK6sb%2BDbU4ci8hD84aXWpiIIjKdPaFS4TgHyuLVS7NN8o0kO8Nyn%2FhiLQ6aqKRx%2B0o691XF8pGtqDxk3g2tJLi4fDhFjCgjr%2B4C5vSnkNZjW1u3K0Gh%2FVpw3hc%2BApFfY%2BV2QBEWpbtP8Vcl7DparLj845dITvO%2Fl9Vs6lpU7o892Anqzh&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47U4QYJLMLX%2F20260829%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260829T220402Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=dc91fa0679455c43414b69f296b5d8d3a9a8f9a799eda9c93850b5c08f7a1929 300w, https:\/\/blogs.glowscotland.org.uk\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2013\/02\/Slide163.png 600w\" sizes=\"(max-width: 150px) 100vw, 150px\" data-attachment-id=\"156\" data-permalink=\"https:\/\/blogs.glowscotland.org.uk\/nl\/ColtnessHS-ComputingScience\/2013\/02\/07\/spreadsheet-formula\/slide16-4\/\" data-orig-file=\"https:\/\/blogs.glowscotland.org.uk\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2013\/02\/Slide163.png\" data-orig-size=\"600,450\" data-comments-opened=\"1\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;}\" data-image-title=\"Slide16\" data-image-description=\"\" data-image-caption=\"\" data-medium-file=\"https:\/\/glow-prod-nl.s3.eu-west-1.amazonaws.com\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2013\/02\/Slide163-300x225.png?X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&amp;X-Amz-Security-Token=IQoJb3JpZ2luX2VjEKb%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJGMEQCICLN6euxLm0t6cByhB24RRtzPX1O38VvYaZqO9mgVUxiAiB%2BXrTSe0U7cL2%2F0If5iG6eTfMap4Ri%2FXy65PFpUPBWcyq5BQhvEAUaDDI3MzU3MDE5NTQzMyIMMKChVqIGmoXYBx4cKpYFRl4UxzNyhQiU8oCpkHCj5jq9nIMO0DSnYcTzUw6zsQ3N7zIjJIkC5edR8JrIw%2Fo5wrD1WhpfUfD7UWr0QvjuSjMRqKg3Cmxs237BK6LjgddLJNYezEqtdoA3bVJgxZ0YUgvpIkAutb7hYRDf9iNFa%2FcKlM3v9QTXclLUOZxxdz7S7ov%2FIpa%2B3DQYKzk%2FJf4%2BC5lr0y9uzS9XcARdhxmW45Dqkj4qmjEMX9Jzu1eWE3Zp4lRh9y9XlrgrLFAWj5CxpslfJHGXmOBd9qRY7z8pnbfpDR0GjrvKtg2wPC9X6oNygwsQEYxwcHGqfxw%2BkAR2rjz%2FdzgRxfxgzz%2FlpWET7zHAJiZa%2FBMpyZ0X2vWKIaZ%2FToDDax2fqgbiwfZy3YTwI6dkdMxtjTIVsKH4rLkkNgwoXW7F4YxMWnFTYLkYCdgPlHYUCHRpP%2FIumJPOimyoDqpm7KA5FpvZ5ktKvKT7pkeLCVWhlOuCT0%2FAEV7uhUKCWIz8iGCnNUo38Bjp69%2ByAph0pZbJRpTA9ROxQKC8cj8UESZKKK4jBnbTcnWx%2Fm9bdO%2B7ifZpAtO%2FgcMfzCkKWftoL3Dn4Si2iX4gpr1KQ8uq4uf7JTt1YbrCfFiCqe0n0E%2Bb4znUp3Gjxa4Dmsw8PysLiGQEzy0LgCkDnnYxEyISODuApSWnB8Vzh5%2FheILWruZbnNCvFDr5yyf9GsRmiSKmMKYpDxsoqYp5oehml5A3FAGTLF%2FSM9a0wiGeFaOPsfG6XdsHH2H4ex7LXib1xDJEZpbnF1gPSYDVlE5W9SkM9ybMbhx2ZC0NaxNH1PYg1lda%2BujMzAecHzWWBhP%2FRo3%2F3oJI94CPueubfOCiVB7zdyXX27lQstTJ%2FvEJiVIwO6DUh%2FAw463N1AY6sgHWOpIapB8zJpwudKlC1GSjASc8jUiXvJSf88th2cejqHgOr%2Bdb7JqiVpi3Xn9AK6sb%2BDbU4ci8hD84aXWpiIIjKdPaFS4TgHyuLVS7NN8o0kO8Nyn%2FhiLQ6aqKRx%2B0o691XF8pGtqDxk3g2tJLi4fDhFjCgjr%2B4C5vSnkNZjW1u3K0Gh%2FVpw3hc%2BApFfY%2BV2QBEWpbtP8Vcl7DparLj845dITvO%2Fl9Vs6lpU7o892Anqzh&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47U4QYJLMLX%2F20260829%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260829T220402Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=dc91fa0679455c43414b69f296b5d8d3a9a8f9a799eda9c93850b5c08f7a1929\" data-large-file=\"https:\/\/blogs.glowscotland.org.uk\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2013\/02\/Slide163.png\" \/><\/a>\n\t\t\t<\/div><\/figure><figure class='gallery-item'>\n\t\t\t<div class='gallery-icon landscape'>\n\t\t\t\t<a href='https:\/\/blogs.glowscotland.org.uk\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2013\/02\/Slide173.png'><img decoding=\"async\" width=\"150\" height=\"112\" src=\"https:\/\/glow-prod-nl.s3.eu-west-1.amazonaws.com\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2013\/02\/Slide173-150x112.png?X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&amp;X-Amz-Security-Token=IQoJb3JpZ2luX2VjEKb%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJGMEQCICLN6euxLm0t6cByhB24RRtzPX1O38VvYaZqO9mgVUxiAiB%2BXrTSe0U7cL2%2F0If5iG6eTfMap4Ri%2FXy65PFpUPBWcyq5BQhvEAUaDDI3MzU3MDE5NTQzMyIMMKChVqIGmoXYBx4cKpYFRl4UxzNyhQiU8oCpkHCj5jq9nIMO0DSnYcTzUw6zsQ3N7zIjJIkC5edR8JrIw%2Fo5wrD1WhpfUfD7UWr0QvjuSjMRqKg3Cmxs237BK6LjgddLJNYezEqtdoA3bVJgxZ0YUgvpIkAutb7hYRDf9iNFa%2FcKlM3v9QTXclLUOZxxdz7S7ov%2FIpa%2B3DQYKzk%2FJf4%2BC5lr0y9uzS9XcARdhxmW45Dqkj4qmjEMX9Jzu1eWE3Zp4lRh9y9XlrgrLFAWj5CxpslfJHGXmOBd9qRY7z8pnbfpDR0GjrvKtg2wPC9X6oNygwsQEYxwcHGqfxw%2BkAR2rjz%2FdzgRxfxgzz%2FlpWET7zHAJiZa%2FBMpyZ0X2vWKIaZ%2FToDDax2fqgbiwfZy3YTwI6dkdMxtjTIVsKH4rLkkNgwoXW7F4YxMWnFTYLkYCdgPlHYUCHRpP%2FIumJPOimyoDqpm7KA5FpvZ5ktKvKT7pkeLCVWhlOuCT0%2FAEV7uhUKCWIz8iGCnNUo38Bjp69%2ByAph0pZbJRpTA9ROxQKC8cj8UESZKKK4jBnbTcnWx%2Fm9bdO%2B7ifZpAtO%2FgcMfzCkKWftoL3Dn4Si2iX4gpr1KQ8uq4uf7JTt1YbrCfFiCqe0n0E%2Bb4znUp3Gjxa4Dmsw8PysLiGQEzy0LgCkDnnYxEyISODuApSWnB8Vzh5%2FheILWruZbnNCvFDr5yyf9GsRmiSKmMKYpDxsoqYp5oehml5A3FAGTLF%2FSM9a0wiGeFaOPsfG6XdsHH2H4ex7LXib1xDJEZpbnF1gPSYDVlE5W9SkM9ybMbhx2ZC0NaxNH1PYg1lda%2BujMzAecHzWWBhP%2FRo3%2F3oJI94CPueubfOCiVB7zdyXX27lQstTJ%2FvEJiVIwO6DUh%2FAw463N1AY6sgHWOpIapB8zJpwudKlC1GSjASc8jUiXvJSf88th2cejqHgOr%2Bdb7JqiVpi3Xn9AK6sb%2BDbU4ci8hD84aXWpiIIjKdPaFS4TgHyuLVS7NN8o0kO8Nyn%2FhiLQ6aqKRx%2B0o691XF8pGtqDxk3g2tJLi4fDhFjCgjr%2B4C5vSnkNZjW1u3K0Gh%2FVpw3hc%2BApFfY%2BV2QBEWpbtP8Vcl7DparLj845dITvO%2Fl9Vs6lpU7o892Anqzh&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47U4QYJLMLX%2F20260829%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260829T220402Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=5090febb71d2f0166fdfc66f1f907719c78c7b4ff1683f9081c0e5973b52988c\" class=\"attachment-thumbnail size-thumbnail\" alt=\"\" srcset=\"https:\/\/glow-prod-nl.s3.eu-west-1.amazonaws.com\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2013\/02\/Slide173-150x112.png?X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&amp;X-Amz-Security-Token=IQoJb3JpZ2luX2VjEKb%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJGMEQCICLN6euxLm0t6cByhB24RRtzPX1O38VvYaZqO9mgVUxiAiB%2BXrTSe0U7cL2%2F0If5iG6eTfMap4Ri%2FXy65PFpUPBWcyq5BQhvEAUaDDI3MzU3MDE5NTQzMyIMMKChVqIGmoXYBx4cKpYFRl4UxzNyhQiU8oCpkHCj5jq9nIMO0DSnYcTzUw6zsQ3N7zIjJIkC5edR8JrIw%2Fo5wrD1WhpfUfD7UWr0QvjuSjMRqKg3Cmxs237BK6LjgddLJNYezEqtdoA3bVJgxZ0YUgvpIkAutb7hYRDf9iNFa%2FcKlM3v9QTXclLUOZxxdz7S7ov%2FIpa%2B3DQYKzk%2FJf4%2BC5lr0y9uzS9XcARdhxmW45Dqkj4qmjEMX9Jzu1eWE3Zp4lRh9y9XlrgrLFAWj5CxpslfJHGXmOBd9qRY7z8pnbfpDR0GjrvKtg2wPC9X6oNygwsQEYxwcHGqfxw%2BkAR2rjz%2FdzgRxfxgzz%2FlpWET7zHAJiZa%2FBMpyZ0X2vWKIaZ%2FToDDax2fqgbiwfZy3YTwI6dkdMxtjTIVsKH4rLkkNgwoXW7F4YxMWnFTYLkYCdgPlHYUCHRpP%2FIumJPOimyoDqpm7KA5FpvZ5ktKvKT7pkeLCVWhlOuCT0%2FAEV7uhUKCWIz8iGCnNUo38Bjp69%2ByAph0pZbJRpTA9ROxQKC8cj8UESZKKK4jBnbTcnWx%2Fm9bdO%2B7ifZpAtO%2FgcMfzCkKWftoL3Dn4Si2iX4gpr1KQ8uq4uf7JTt1YbrCfFiCqe0n0E%2Bb4znUp3Gjxa4Dmsw8PysLiGQEzy0LgCkDnnYxEyISODuApSWnB8Vzh5%2FheILWruZbnNCvFDr5yyf9GsRmiSKmMKYpDxsoqYp5oehml5A3FAGTLF%2FSM9a0wiGeFaOPsfG6XdsHH2H4ex7LXib1xDJEZpbnF1gPSYDVlE5W9SkM9ybMbhx2ZC0NaxNH1PYg1lda%2BujMzAecHzWWBhP%2FRo3%2F3oJI94CPueubfOCiVB7zdyXX27lQstTJ%2FvEJiVIwO6DUh%2FAw463N1AY6sgHWOpIapB8zJpwudKlC1GSjASc8jUiXvJSf88th2cejqHgOr%2Bdb7JqiVpi3Xn9AK6sb%2BDbU4ci8hD84aXWpiIIjKdPaFS4TgHyuLVS7NN8o0kO8Nyn%2FhiLQ6aqKRx%2B0o691XF8pGtqDxk3g2tJLi4fDhFjCgjr%2B4C5vSnkNZjW1u3K0Gh%2FVpw3hc%2BApFfY%2BV2QBEWpbtP8Vcl7DparLj845dITvO%2Fl9Vs6lpU7o892Anqzh&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47U4QYJLMLX%2F20260829%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260829T220402Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=5090febb71d2f0166fdfc66f1f907719c78c7b4ff1683f9081c0e5973b52988c 150w, https:\/\/glow-prod-nl.s3.eu-west-1.amazonaws.com\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2013\/02\/Slide173-300x225.png?X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&amp;X-Amz-Security-Token=IQoJb3JpZ2luX2VjEKb%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJGMEQCICLN6euxLm0t6cByhB24RRtzPX1O38VvYaZqO9mgVUxiAiB%2BXrTSe0U7cL2%2F0If5iG6eTfMap4Ri%2FXy65PFpUPBWcyq5BQhvEAUaDDI3MzU3MDE5NTQzMyIMMKChVqIGmoXYBx4cKpYFRl4UxzNyhQiU8oCpkHCj5jq9nIMO0DSnYcTzUw6zsQ3N7zIjJIkC5edR8JrIw%2Fo5wrD1WhpfUfD7UWr0QvjuSjMRqKg3Cmxs237BK6LjgddLJNYezEqtdoA3bVJgxZ0YUgvpIkAutb7hYRDf9iNFa%2FcKlM3v9QTXclLUOZxxdz7S7ov%2FIpa%2B3DQYKzk%2FJf4%2BC5lr0y9uzS9XcARdhxmW45Dqkj4qmjEMX9Jzu1eWE3Zp4lRh9y9XlrgrLFAWj5CxpslfJHGXmOBd9qRY7z8pnbfpDR0GjrvKtg2wPC9X6oNygwsQEYxwcHGqfxw%2BkAR2rjz%2FdzgRxfxgzz%2FlpWET7zHAJiZa%2FBMpyZ0X2vWKIaZ%2FToDDax2fqgbiwfZy3YTwI6dkdMxtjTIVsKH4rLkkNgwoXW7F4YxMWnFTYLkYCdgPlHYUCHRpP%2FIumJPOimyoDqpm7KA5FpvZ5ktKvKT7pkeLCVWhlOuCT0%2FAEV7uhUKCWIz8iGCnNUo38Bjp69%2ByAph0pZbJRpTA9ROxQKC8cj8UESZKKK4jBnbTcnWx%2Fm9bdO%2B7ifZpAtO%2FgcMfzCkKWftoL3Dn4Si2iX4gpr1KQ8uq4uf7JTt1YbrCfFiCqe0n0E%2Bb4znUp3Gjxa4Dmsw8PysLiGQEzy0LgCkDnnYxEyISODuApSWnB8Vzh5%2FheILWruZbnNCvFDr5yyf9GsRmiSKmMKYpDxsoqYp5oehml5A3FAGTLF%2FSM9a0wiGeFaOPsfG6XdsHH2H4ex7LXib1xDJEZpbnF1gPSYDVlE5W9SkM9ybMbhx2ZC0NaxNH1PYg1lda%2BujMzAecHzWWBhP%2FRo3%2F3oJI94CPueubfOCiVB7zdyXX27lQstTJ%2FvEJiVIwO6DUh%2FAw463N1AY6sgHWOpIapB8zJpwudKlC1GSjASc8jUiXvJSf88th2cejqHgOr%2Bdb7JqiVpi3Xn9AK6sb%2BDbU4ci8hD84aXWpiIIjKdPaFS4TgHyuLVS7NN8o0kO8Nyn%2FhiLQ6aqKRx%2B0o691XF8pGtqDxk3g2tJLi4fDhFjCgjr%2B4C5vSnkNZjW1u3K0Gh%2FVpw3hc%2BApFfY%2BV2QBEWpbtP8Vcl7DparLj845dITvO%2Fl9Vs6lpU7o892Anqzh&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47U4QYJLMLX%2F20260829%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260829T220402Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=d3a4b28cbfe0e8e6adf43120ae9b529850a02676e64f8268c56f35489248f5ce 300w, https:\/\/blogs.glowscotland.org.uk\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2013\/02\/Slide173.png 600w\" sizes=\"(max-width: 150px) 100vw, 150px\" data-attachment-id=\"157\" data-permalink=\"https:\/\/blogs.glowscotland.org.uk\/nl\/ColtnessHS-ComputingScience\/2013\/02\/07\/spreadsheet-formula\/slide17-4\/\" data-orig-file=\"https:\/\/blogs.glowscotland.org.uk\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2013\/02\/Slide173.png\" data-orig-size=\"600,450\" data-comments-opened=\"1\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;}\" data-image-title=\"Slide17\" data-image-description=\"\" data-image-caption=\"\" data-medium-file=\"https:\/\/glow-prod-nl.s3.eu-west-1.amazonaws.com\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2013\/02\/Slide173-300x225.png?X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&amp;X-Amz-Security-Token=IQoJb3JpZ2luX2VjEKb%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJGMEQCICLN6euxLm0t6cByhB24RRtzPX1O38VvYaZqO9mgVUxiAiB%2BXrTSe0U7cL2%2F0If5iG6eTfMap4Ri%2FXy65PFpUPBWcyq5BQhvEAUaDDI3MzU3MDE5NTQzMyIMMKChVqIGmoXYBx4cKpYFRl4UxzNyhQiU8oCpkHCj5jq9nIMO0DSnYcTzUw6zsQ3N7zIjJIkC5edR8JrIw%2Fo5wrD1WhpfUfD7UWr0QvjuSjMRqKg3Cmxs237BK6LjgddLJNYezEqtdoA3bVJgxZ0YUgvpIkAutb7hYRDf9iNFa%2FcKlM3v9QTXclLUOZxxdz7S7ov%2FIpa%2B3DQYKzk%2FJf4%2BC5lr0y9uzS9XcARdhxmW45Dqkj4qmjEMX9Jzu1eWE3Zp4lRh9y9XlrgrLFAWj5CxpslfJHGXmOBd9qRY7z8pnbfpDR0GjrvKtg2wPC9X6oNygwsQEYxwcHGqfxw%2BkAR2rjz%2FdzgRxfxgzz%2FlpWET7zHAJiZa%2FBMpyZ0X2vWKIaZ%2FToDDax2fqgbiwfZy3YTwI6dkdMxtjTIVsKH4rLkkNgwoXW7F4YxMWnFTYLkYCdgPlHYUCHRpP%2FIumJPOimyoDqpm7KA5FpvZ5ktKvKT7pkeLCVWhlOuCT0%2FAEV7uhUKCWIz8iGCnNUo38Bjp69%2ByAph0pZbJRpTA9ROxQKC8cj8UESZKKK4jBnbTcnWx%2Fm9bdO%2B7ifZpAtO%2FgcMfzCkKWftoL3Dn4Si2iX4gpr1KQ8uq4uf7JTt1YbrCfFiCqe0n0E%2Bb4znUp3Gjxa4Dmsw8PysLiGQEzy0LgCkDnnYxEyISODuApSWnB8Vzh5%2FheILWruZbnNCvFDr5yyf9GsRmiSKmMKYpDxsoqYp5oehml5A3FAGTLF%2FSM9a0wiGeFaOPsfG6XdsHH2H4ex7LXib1xDJEZpbnF1gPSYDVlE5W9SkM9ybMbhx2ZC0NaxNH1PYg1lda%2BujMzAecHzWWBhP%2FRo3%2F3oJI94CPueubfOCiVB7zdyXX27lQstTJ%2FvEJiVIwO6DUh%2FAw463N1AY6sgHWOpIapB8zJpwudKlC1GSjASc8jUiXvJSf88th2cejqHgOr%2Bdb7JqiVpi3Xn9AK6sb%2BDbU4ci8hD84aXWpiIIjKdPaFS4TgHyuLVS7NN8o0kO8Nyn%2FhiLQ6aqKRx%2B0o691XF8pGtqDxk3g2tJLi4fDhFjCgjr%2B4C5vSnkNZjW1u3K0Gh%2FVpw3hc%2BApFfY%2BV2QBEWpbtP8Vcl7DparLj845dITvO%2Fl9Vs6lpU7o892Anqzh&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47U4QYJLMLX%2F20260829%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260829T220402Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=d3a4b28cbfe0e8e6adf43120ae9b529850a02676e64f8268c56f35489248f5ce\" data-large-file=\"https:\/\/blogs.glowscotland.org.uk\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2013\/02\/Slide173.png\" \/><\/a>\n\t\t\t<\/div><\/figure><figure class='gallery-item'>\n\t\t\t<div class='gallery-icon landscape'>\n\t\t\t\t<a href='https:\/\/blogs.glowscotland.org.uk\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2013\/02\/Slide183.png'><img decoding=\"async\" width=\"150\" height=\"112\" src=\"https:\/\/glow-prod-nl.s3.eu-west-1.amazonaws.com\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2013\/02\/Slide183-150x112.png?X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&amp;X-Amz-Security-Token=IQoJb3JpZ2luX2VjEKb%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJGMEQCICLN6euxLm0t6cByhB24RRtzPX1O38VvYaZqO9mgVUxiAiB%2BXrTSe0U7cL2%2F0If5iG6eTfMap4Ri%2FXy65PFpUPBWcyq5BQhvEAUaDDI3MzU3MDE5NTQzMyIMMKChVqIGmoXYBx4cKpYFRl4UxzNyhQiU8oCpkHCj5jq9nIMO0DSnYcTzUw6zsQ3N7zIjJIkC5edR8JrIw%2Fo5wrD1WhpfUfD7UWr0QvjuSjMRqKg3Cmxs237BK6LjgddLJNYezEqtdoA3bVJgxZ0YUgvpIkAutb7hYRDf9iNFa%2FcKlM3v9QTXclLUOZxxdz7S7ov%2FIpa%2B3DQYKzk%2FJf4%2BC5lr0y9uzS9XcARdhxmW45Dqkj4qmjEMX9Jzu1eWE3Zp4lRh9y9XlrgrLFAWj5CxpslfJHGXmOBd9qRY7z8pnbfpDR0GjrvKtg2wPC9X6oNygwsQEYxwcHGqfxw%2BkAR2rjz%2FdzgRxfxgzz%2FlpWET7zHAJiZa%2FBMpyZ0X2vWKIaZ%2FToDDax2fqgbiwfZy3YTwI6dkdMxtjTIVsKH4rLkkNgwoXW7F4YxMWnFTYLkYCdgPlHYUCHRpP%2FIumJPOimyoDqpm7KA5FpvZ5ktKvKT7pkeLCVWhlOuCT0%2FAEV7uhUKCWIz8iGCnNUo38Bjp69%2ByAph0pZbJRpTA9ROxQKC8cj8UESZKKK4jBnbTcnWx%2Fm9bdO%2B7ifZpAtO%2FgcMfzCkKWftoL3Dn4Si2iX4gpr1KQ8uq4uf7JTt1YbrCfFiCqe0n0E%2Bb4znUp3Gjxa4Dmsw8PysLiGQEzy0LgCkDnnYxEyISODuApSWnB8Vzh5%2FheILWruZbnNCvFDr5yyf9GsRmiSKmMKYpDxsoqYp5oehml5A3FAGTLF%2FSM9a0wiGeFaOPsfG6XdsHH2H4ex7LXib1xDJEZpbnF1gPSYDVlE5W9SkM9ybMbhx2ZC0NaxNH1PYg1lda%2BujMzAecHzWWBhP%2FRo3%2F3oJI94CPueubfOCiVB7zdyXX27lQstTJ%2FvEJiVIwO6DUh%2FAw463N1AY6sgHWOpIapB8zJpwudKlC1GSjASc8jUiXvJSf88th2cejqHgOr%2Bdb7JqiVpi3Xn9AK6sb%2BDbU4ci8hD84aXWpiIIjKdPaFS4TgHyuLVS7NN8o0kO8Nyn%2FhiLQ6aqKRx%2B0o691XF8pGtqDxk3g2tJLi4fDhFjCgjr%2B4C5vSnkNZjW1u3K0Gh%2FVpw3hc%2BApFfY%2BV2QBEWpbtP8Vcl7DparLj845dITvO%2Fl9Vs6lpU7o892Anqzh&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47U4QYJLMLX%2F20260829%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260829T220402Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=f079eb01122c1432c7f8e0169909a9e1176d56832ef9fc9f21f6544e9d98844e\" class=\"attachment-thumbnail size-thumbnail\" alt=\"\" srcset=\"https:\/\/glow-prod-nl.s3.eu-west-1.amazonaws.com\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2013\/02\/Slide183-150x112.png?X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&amp;X-Amz-Security-Token=IQoJb3JpZ2luX2VjEKb%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJGMEQCICLN6euxLm0t6cByhB24RRtzPX1O38VvYaZqO9mgVUxiAiB%2BXrTSe0U7cL2%2F0If5iG6eTfMap4Ri%2FXy65PFpUPBWcyq5BQhvEAUaDDI3MzU3MDE5NTQzMyIMMKChVqIGmoXYBx4cKpYFRl4UxzNyhQiU8oCpkHCj5jq9nIMO0DSnYcTzUw6zsQ3N7zIjJIkC5edR8JrIw%2Fo5wrD1WhpfUfD7UWr0QvjuSjMRqKg3Cmxs237BK6LjgddLJNYezEqtdoA3bVJgxZ0YUgvpIkAutb7hYRDf9iNFa%2FcKlM3v9QTXclLUOZxxdz7S7ov%2FIpa%2B3DQYKzk%2FJf4%2BC5lr0y9uzS9XcARdhxmW45Dqkj4qmjEMX9Jzu1eWE3Zp4lRh9y9XlrgrLFAWj5CxpslfJHGXmOBd9qRY7z8pnbfpDR0GjrvKtg2wPC9X6oNygwsQEYxwcHGqfxw%2BkAR2rjz%2FdzgRxfxgzz%2FlpWET7zHAJiZa%2FBMpyZ0X2vWKIaZ%2FToDDax2fqgbiwfZy3YTwI6dkdMxtjTIVsKH4rLkkNgwoXW7F4YxMWnFTYLkYCdgPlHYUCHRpP%2FIumJPOimyoDqpm7KA5FpvZ5ktKvKT7pkeLCVWhlOuCT0%2FAEV7uhUKCWIz8iGCnNUo38Bjp69%2ByAph0pZbJRpTA9ROxQKC8cj8UESZKKK4jBnbTcnWx%2Fm9bdO%2B7ifZpAtO%2FgcMfzCkKWftoL3Dn4Si2iX4gpr1KQ8uq4uf7JTt1YbrCfFiCqe0n0E%2Bb4znUp3Gjxa4Dmsw8PysLiGQEzy0LgCkDnnYxEyISODuApSWnB8Vzh5%2FheILWruZbnNCvFDr5yyf9GsRmiSKmMKYpDxsoqYp5oehml5A3FAGTLF%2FSM9a0wiGeFaOPsfG6XdsHH2H4ex7LXib1xDJEZpbnF1gPSYDVlE5W9SkM9ybMbhx2ZC0NaxNH1PYg1lda%2BujMzAecHzWWBhP%2FRo3%2F3oJI94CPueubfOCiVB7zdyXX27lQstTJ%2FvEJiVIwO6DUh%2FAw463N1AY6sgHWOpIapB8zJpwudKlC1GSjASc8jUiXvJSf88th2cejqHgOr%2Bdb7JqiVpi3Xn9AK6sb%2BDbU4ci8hD84aXWpiIIjKdPaFS4TgHyuLVS7NN8o0kO8Nyn%2FhiLQ6aqKRx%2B0o691XF8pGtqDxk3g2tJLi4fDhFjCgjr%2B4C5vSnkNZjW1u3K0Gh%2FVpw3hc%2BApFfY%2BV2QBEWpbtP8Vcl7DparLj845dITvO%2Fl9Vs6lpU7o892Anqzh&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47U4QYJLMLX%2F20260829%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260829T220402Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=f079eb01122c1432c7f8e0169909a9e1176d56832ef9fc9f21f6544e9d98844e 150w, https:\/\/glow-prod-nl.s3.eu-west-1.amazonaws.com\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2013\/02\/Slide183-300x225.png?X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&amp;X-Amz-Security-Token=IQoJb3JpZ2luX2VjEKb%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJGMEQCICLN6euxLm0t6cByhB24RRtzPX1O38VvYaZqO9mgVUxiAiB%2BXrTSe0U7cL2%2F0If5iG6eTfMap4Ri%2FXy65PFpUPBWcyq5BQhvEAUaDDI3MzU3MDE5NTQzMyIMMKChVqIGmoXYBx4cKpYFRl4UxzNyhQiU8oCpkHCj5jq9nIMO0DSnYcTzUw6zsQ3N7zIjJIkC5edR8JrIw%2Fo5wrD1WhpfUfD7UWr0QvjuSjMRqKg3Cmxs237BK6LjgddLJNYezEqtdoA3bVJgxZ0YUgvpIkAutb7hYRDf9iNFa%2FcKlM3v9QTXclLUOZxxdz7S7ov%2FIpa%2B3DQYKzk%2FJf4%2BC5lr0y9uzS9XcARdhxmW45Dqkj4qmjEMX9Jzu1eWE3Zp4lRh9y9XlrgrLFAWj5CxpslfJHGXmOBd9qRY7z8pnbfpDR0GjrvKtg2wPC9X6oNygwsQEYxwcHGqfxw%2BkAR2rjz%2FdzgRxfxgzz%2FlpWET7zHAJiZa%2FBMpyZ0X2vWKIaZ%2FToDDax2fqgbiwfZy3YTwI6dkdMxtjTIVsKH4rLkkNgwoXW7F4YxMWnFTYLkYCdgPlHYUCHRpP%2FIumJPOimyoDqpm7KA5FpvZ5ktKvKT7pkeLCVWhlOuCT0%2FAEV7uhUKCWIz8iGCnNUo38Bjp69%2ByAph0pZbJRpTA9ROxQKC8cj8UESZKKK4jBnbTcnWx%2Fm9bdO%2B7ifZpAtO%2FgcMfzCkKWftoL3Dn4Si2iX4gpr1KQ8uq4uf7JTt1YbrCfFiCqe0n0E%2Bb4znUp3Gjxa4Dmsw8PysLiGQEzy0LgCkDnnYxEyISODuApSWnB8Vzh5%2FheILWruZbnNCvFDr5yyf9GsRmiSKmMKYpDxsoqYp5oehml5A3FAGTLF%2FSM9a0wiGeFaOPsfG6XdsHH2H4ex7LXib1xDJEZpbnF1gPSYDVlE5W9SkM9ybMbhx2ZC0NaxNH1PYg1lda%2BujMzAecHzWWBhP%2FRo3%2F3oJI94CPueubfOCiVB7zdyXX27lQstTJ%2FvEJiVIwO6DUh%2FAw463N1AY6sgHWOpIapB8zJpwudKlC1GSjASc8jUiXvJSf88th2cejqHgOr%2Bdb7JqiVpi3Xn9AK6sb%2BDbU4ci8hD84aXWpiIIjKdPaFS4TgHyuLVS7NN8o0kO8Nyn%2FhiLQ6aqKRx%2B0o691XF8pGtqDxk3g2tJLi4fDhFjCgjr%2B4C5vSnkNZjW1u3K0Gh%2FVpw3hc%2BApFfY%2BV2QBEWpbtP8Vcl7DparLj845dITvO%2Fl9Vs6lpU7o892Anqzh&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47U4QYJLMLX%2F20260829%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260829T220402Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=81730208921e9503e626f2f8b5144a6bb7d57c8eab4cc82c01262f01124a056d 300w, https:\/\/blogs.glowscotland.org.uk\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2013\/02\/Slide183.png 600w\" sizes=\"(max-width: 150px) 100vw, 150px\" data-attachment-id=\"158\" data-permalink=\"https:\/\/blogs.glowscotland.org.uk\/nl\/ColtnessHS-ComputingScience\/2013\/02\/07\/spreadsheet-formula\/slide18-4\/\" data-orig-file=\"https:\/\/blogs.glowscotland.org.uk\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2013\/02\/Slide183.png\" data-orig-size=\"600,450\" data-comments-opened=\"1\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;}\" data-image-title=\"Slide18\" data-image-description=\"\" data-image-caption=\"\" data-medium-file=\"https:\/\/glow-prod-nl.s3.eu-west-1.amazonaws.com\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2013\/02\/Slide183-300x225.png?X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&amp;X-Amz-Security-Token=IQoJb3JpZ2luX2VjEKb%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJGMEQCICLN6euxLm0t6cByhB24RRtzPX1O38VvYaZqO9mgVUxiAiB%2BXrTSe0U7cL2%2F0If5iG6eTfMap4Ri%2FXy65PFpUPBWcyq5BQhvEAUaDDI3MzU3MDE5NTQzMyIMMKChVqIGmoXYBx4cKpYFRl4UxzNyhQiU8oCpkHCj5jq9nIMO0DSnYcTzUw6zsQ3N7zIjJIkC5edR8JrIw%2Fo5wrD1WhpfUfD7UWr0QvjuSjMRqKg3Cmxs237BK6LjgddLJNYezEqtdoA3bVJgxZ0YUgvpIkAutb7hYRDf9iNFa%2FcKlM3v9QTXclLUOZxxdz7S7ov%2FIpa%2B3DQYKzk%2FJf4%2BC5lr0y9uzS9XcARdhxmW45Dqkj4qmjEMX9Jzu1eWE3Zp4lRh9y9XlrgrLFAWj5CxpslfJHGXmOBd9qRY7z8pnbfpDR0GjrvKtg2wPC9X6oNygwsQEYxwcHGqfxw%2BkAR2rjz%2FdzgRxfxgzz%2FlpWET7zHAJiZa%2FBMpyZ0X2vWKIaZ%2FToDDax2fqgbiwfZy3YTwI6dkdMxtjTIVsKH4rLkkNgwoXW7F4YxMWnFTYLkYCdgPlHYUCHRpP%2FIumJPOimyoDqpm7KA5FpvZ5ktKvKT7pkeLCVWhlOuCT0%2FAEV7uhUKCWIz8iGCnNUo38Bjp69%2ByAph0pZbJRpTA9ROxQKC8cj8UESZKKK4jBnbTcnWx%2Fm9bdO%2B7ifZpAtO%2FgcMfzCkKWftoL3Dn4Si2iX4gpr1KQ8uq4uf7JTt1YbrCfFiCqe0n0E%2Bb4znUp3Gjxa4Dmsw8PysLiGQEzy0LgCkDnnYxEyISODuApSWnB8Vzh5%2FheILWruZbnNCvFDr5yyf9GsRmiSKmMKYpDxsoqYp5oehml5A3FAGTLF%2FSM9a0wiGeFaOPsfG6XdsHH2H4ex7LXib1xDJEZpbnF1gPSYDVlE5W9SkM9ybMbhx2ZC0NaxNH1PYg1lda%2BujMzAecHzWWBhP%2FRo3%2F3oJI94CPueubfOCiVB7zdyXX27lQstTJ%2FvEJiVIwO6DUh%2FAw463N1AY6sgHWOpIapB8zJpwudKlC1GSjASc8jUiXvJSf88th2cejqHgOr%2Bdb7JqiVpi3Xn9AK6sb%2BDbU4ci8hD84aXWpiIIjKdPaFS4TgHyuLVS7NN8o0kO8Nyn%2FhiLQ6aqKRx%2B0o691XF8pGtqDxk3g2tJLi4fDhFjCgjr%2B4C5vSnkNZjW1u3K0Gh%2FVpw3hc%2BApFfY%2BV2QBEWpbtP8Vcl7DparLj845dITvO%2Fl9Vs6lpU7o892Anqzh&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47U4QYJLMLX%2F20260829%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260829T220402Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=81730208921e9503e626f2f8b5144a6bb7d57c8eab4cc82c01262f01124a056d\" data-large-file=\"https:\/\/blogs.glowscotland.org.uk\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2013\/02\/Slide183.png\" \/><\/a>\n\t\t\t<\/div><\/figure><figure class='gallery-item'>\n\t\t\t<div class='gallery-icon landscape'>\n\t\t\t\t<a href='https:\/\/blogs.glowscotland.org.uk\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2013\/02\/Slide193.png'><img decoding=\"async\" width=\"150\" height=\"112\" src=\"https:\/\/glow-prod-nl.s3.eu-west-1.amazonaws.com\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2013\/02\/Slide193-150x112.png?X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&amp;X-Amz-Security-Token=IQoJb3JpZ2luX2VjEKb%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJGMEQCICLN6euxLm0t6cByhB24RRtzPX1O38VvYaZqO9mgVUxiAiB%2BXrTSe0U7cL2%2F0If5iG6eTfMap4Ri%2FXy65PFpUPBWcyq5BQhvEAUaDDI3MzU3MDE5NTQzMyIMMKChVqIGmoXYBx4cKpYFRl4UxzNyhQiU8oCpkHCj5jq9nIMO0DSnYcTzUw6zsQ3N7zIjJIkC5edR8JrIw%2Fo5wrD1WhpfUfD7UWr0QvjuSjMRqKg3Cmxs237BK6LjgddLJNYezEqtdoA3bVJgxZ0YUgvpIkAutb7hYRDf9iNFa%2FcKlM3v9QTXclLUOZxxdz7S7ov%2FIpa%2B3DQYKzk%2FJf4%2BC5lr0y9uzS9XcARdhxmW45Dqkj4qmjEMX9Jzu1eWE3Zp4lRh9y9XlrgrLFAWj5CxpslfJHGXmOBd9qRY7z8pnbfpDR0GjrvKtg2wPC9X6oNygwsQEYxwcHGqfxw%2BkAR2rjz%2FdzgRxfxgzz%2FlpWET7zHAJiZa%2FBMpyZ0X2vWKIaZ%2FToDDax2fqgbiwfZy3YTwI6dkdMxtjTIVsKH4rLkkNgwoXW7F4YxMWnFTYLkYCdgPlHYUCHRpP%2FIumJPOimyoDqpm7KA5FpvZ5ktKvKT7pkeLCVWhlOuCT0%2FAEV7uhUKCWIz8iGCnNUo38Bjp69%2ByAph0pZbJRpTA9ROxQKC8cj8UESZKKK4jBnbTcnWx%2Fm9bdO%2B7ifZpAtO%2FgcMfzCkKWftoL3Dn4Si2iX4gpr1KQ8uq4uf7JTt1YbrCfFiCqe0n0E%2Bb4znUp3Gjxa4Dmsw8PysLiGQEzy0LgCkDnnYxEyISODuApSWnB8Vzh5%2FheILWruZbnNCvFDr5yyf9GsRmiSKmMKYpDxsoqYp5oehml5A3FAGTLF%2FSM9a0wiGeFaOPsfG6XdsHH2H4ex7LXib1xDJEZpbnF1gPSYDVlE5W9SkM9ybMbhx2ZC0NaxNH1PYg1lda%2BujMzAecHzWWBhP%2FRo3%2F3oJI94CPueubfOCiVB7zdyXX27lQstTJ%2FvEJiVIwO6DUh%2FAw463N1AY6sgHWOpIapB8zJpwudKlC1GSjASc8jUiXvJSf88th2cejqHgOr%2Bdb7JqiVpi3Xn9AK6sb%2BDbU4ci8hD84aXWpiIIjKdPaFS4TgHyuLVS7NN8o0kO8Nyn%2FhiLQ6aqKRx%2B0o691XF8pGtqDxk3g2tJLi4fDhFjCgjr%2B4C5vSnkNZjW1u3K0Gh%2FVpw3hc%2BApFfY%2BV2QBEWpbtP8Vcl7DparLj845dITvO%2Fl9Vs6lpU7o892Anqzh&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47U4QYJLMLX%2F20260829%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260829T220402Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=d9ceb3f210d0e1050a0383304b23a0edb57d539240f6a282edb1999d42f1a6a9\" class=\"attachment-thumbnail size-thumbnail\" alt=\"\" srcset=\"https:\/\/glow-prod-nl.s3.eu-west-1.amazonaws.com\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2013\/02\/Slide193-150x112.png?X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&amp;X-Amz-Security-Token=IQoJb3JpZ2luX2VjEKb%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJGMEQCICLN6euxLm0t6cByhB24RRtzPX1O38VvYaZqO9mgVUxiAiB%2BXrTSe0U7cL2%2F0If5iG6eTfMap4Ri%2FXy65PFpUPBWcyq5BQhvEAUaDDI3MzU3MDE5NTQzMyIMMKChVqIGmoXYBx4cKpYFRl4UxzNyhQiU8oCpkHCj5jq9nIMO0DSnYcTzUw6zsQ3N7zIjJIkC5edR8JrIw%2Fo5wrD1WhpfUfD7UWr0QvjuSjMRqKg3Cmxs237BK6LjgddLJNYezEqtdoA3bVJgxZ0YUgvpIkAutb7hYRDf9iNFa%2FcKlM3v9QTXclLUOZxxdz7S7ov%2FIpa%2B3DQYKzk%2FJf4%2BC5lr0y9uzS9XcARdhxmW45Dqkj4qmjEMX9Jzu1eWE3Zp4lRh9y9XlrgrLFAWj5CxpslfJHGXmOBd9qRY7z8pnbfpDR0GjrvKtg2wPC9X6oNygwsQEYxwcHGqfxw%2BkAR2rjz%2FdzgRxfxgzz%2FlpWET7zHAJiZa%2FBMpyZ0X2vWKIaZ%2FToDDax2fqgbiwfZy3YTwI6dkdMxtjTIVsKH4rLkkNgwoXW7F4YxMWnFTYLkYCdgPlHYUCHRpP%2FIumJPOimyoDqpm7KA5FpvZ5ktKvKT7pkeLCVWhlOuCT0%2FAEV7uhUKCWIz8iGCnNUo38Bjp69%2ByAph0pZbJRpTA9ROxQKC8cj8UESZKKK4jBnbTcnWx%2Fm9bdO%2B7ifZpAtO%2FgcMfzCkKWftoL3Dn4Si2iX4gpr1KQ8uq4uf7JTt1YbrCfFiCqe0n0E%2Bb4znUp3Gjxa4Dmsw8PysLiGQEzy0LgCkDnnYxEyISODuApSWnB8Vzh5%2FheILWruZbnNCvFDr5yyf9GsRmiSKmMKYpDxsoqYp5oehml5A3FAGTLF%2FSM9a0wiGeFaOPsfG6XdsHH2H4ex7LXib1xDJEZpbnF1gPSYDVlE5W9SkM9ybMbhx2ZC0NaxNH1PYg1lda%2BujMzAecHzWWBhP%2FRo3%2F3oJI94CPueubfOCiVB7zdyXX27lQstTJ%2FvEJiVIwO6DUh%2FAw463N1AY6sgHWOpIapB8zJpwudKlC1GSjASc8jUiXvJSf88th2cejqHgOr%2Bdb7JqiVpi3Xn9AK6sb%2BDbU4ci8hD84aXWpiIIjKdPaFS4TgHyuLVS7NN8o0kO8Nyn%2FhiLQ6aqKRx%2B0o691XF8pGtqDxk3g2tJLi4fDhFjCgjr%2B4C5vSnkNZjW1u3K0Gh%2FVpw3hc%2BApFfY%2BV2QBEWpbtP8Vcl7DparLj845dITvO%2Fl9Vs6lpU7o892Anqzh&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47U4QYJLMLX%2F20260829%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260829T220402Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=d9ceb3f210d0e1050a0383304b23a0edb57d539240f6a282edb1999d42f1a6a9 150w, https:\/\/glow-prod-nl.s3.eu-west-1.amazonaws.com\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2013\/02\/Slide193-300x225.png?X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&amp;X-Amz-Security-Token=IQoJb3JpZ2luX2VjEKb%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJGMEQCICLN6euxLm0t6cByhB24RRtzPX1O38VvYaZqO9mgVUxiAiB%2BXrTSe0U7cL2%2F0If5iG6eTfMap4Ri%2FXy65PFpUPBWcyq5BQhvEAUaDDI3MzU3MDE5NTQzMyIMMKChVqIGmoXYBx4cKpYFRl4UxzNyhQiU8oCpkHCj5jq9nIMO0DSnYcTzUw6zsQ3N7zIjJIkC5edR8JrIw%2Fo5wrD1WhpfUfD7UWr0QvjuSjMRqKg3Cmxs237BK6LjgddLJNYezEqtdoA3bVJgxZ0YUgvpIkAutb7hYRDf9iNFa%2FcKlM3v9QTXclLUOZxxdz7S7ov%2FIpa%2B3DQYKzk%2FJf4%2BC5lr0y9uzS9XcARdhxmW45Dqkj4qmjEMX9Jzu1eWE3Zp4lRh9y9XlrgrLFAWj5CxpslfJHGXmOBd9qRY7z8pnbfpDR0GjrvKtg2wPC9X6oNygwsQEYxwcHGqfxw%2BkAR2rjz%2FdzgRxfxgzz%2FlpWET7zHAJiZa%2FBMpyZ0X2vWKIaZ%2FToDDax2fqgbiwfZy3YTwI6dkdMxtjTIVsKH4rLkkNgwoXW7F4YxMWnFTYLkYCdgPlHYUCHRpP%2FIumJPOimyoDqpm7KA5FpvZ5ktKvKT7pkeLCVWhlOuCT0%2FAEV7uhUKCWIz8iGCnNUo38Bjp69%2ByAph0pZbJRpTA9ROxQKC8cj8UESZKKK4jBnbTcnWx%2Fm9bdO%2B7ifZpAtO%2FgcMfzCkKWftoL3Dn4Si2iX4gpr1KQ8uq4uf7JTt1YbrCfFiCqe0n0E%2Bb4znUp3Gjxa4Dmsw8PysLiGQEzy0LgCkDnnYxEyISODuApSWnB8Vzh5%2FheILWruZbnNCvFDr5yyf9GsRmiSKmMKYpDxsoqYp5oehml5A3FAGTLF%2FSM9a0wiGeFaOPsfG6XdsHH2H4ex7LXib1xDJEZpbnF1gPSYDVlE5W9SkM9ybMbhx2ZC0NaxNH1PYg1lda%2BujMzAecHzWWBhP%2FRo3%2F3oJI94CPueubfOCiVB7zdyXX27lQstTJ%2FvEJiVIwO6DUh%2FAw463N1AY6sgHWOpIapB8zJpwudKlC1GSjASc8jUiXvJSf88th2cejqHgOr%2Bdb7JqiVpi3Xn9AK6sb%2BDbU4ci8hD84aXWpiIIjKdPaFS4TgHyuLVS7NN8o0kO8Nyn%2FhiLQ6aqKRx%2B0o691XF8pGtqDxk3g2tJLi4fDhFjCgjr%2B4C5vSnkNZjW1u3K0Gh%2FVpw3hc%2BApFfY%2BV2QBEWpbtP8Vcl7DparLj845dITvO%2Fl9Vs6lpU7o892Anqzh&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47U4QYJLMLX%2F20260829%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260829T220402Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=b6bd34ae640c945c11146f53d01e9808e09b7ae58271d9490d8087b2ab2b265f 300w, https:\/\/blogs.glowscotland.org.uk\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2013\/02\/Slide193.png 600w\" sizes=\"(max-width: 150px) 100vw, 150px\" data-attachment-id=\"159\" data-permalink=\"https:\/\/blogs.glowscotland.org.uk\/nl\/ColtnessHS-ComputingScience\/2013\/02\/07\/spreadsheet-formula\/slide19-4\/\" data-orig-file=\"https:\/\/blogs.glowscotland.org.uk\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2013\/02\/Slide193.png\" data-orig-size=\"600,450\" data-comments-opened=\"1\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;}\" data-image-title=\"Slide19\" data-image-description=\"\" data-image-caption=\"\" data-medium-file=\"https:\/\/glow-prod-nl.s3.eu-west-1.amazonaws.com\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2013\/02\/Slide193-300x225.png?X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&amp;X-Amz-Security-Token=IQoJb3JpZ2luX2VjEKb%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJGMEQCICLN6euxLm0t6cByhB24RRtzPX1O38VvYaZqO9mgVUxiAiB%2BXrTSe0U7cL2%2F0If5iG6eTfMap4Ri%2FXy65PFpUPBWcyq5BQhvEAUaDDI3MzU3MDE5NTQzMyIMMKChVqIGmoXYBx4cKpYFRl4UxzNyhQiU8oCpkHCj5jq9nIMO0DSnYcTzUw6zsQ3N7zIjJIkC5edR8JrIw%2Fo5wrD1WhpfUfD7UWr0QvjuSjMRqKg3Cmxs237BK6LjgddLJNYezEqtdoA3bVJgxZ0YUgvpIkAutb7hYRDf9iNFa%2FcKlM3v9QTXclLUOZxxdz7S7ov%2FIpa%2B3DQYKzk%2FJf4%2BC5lr0y9uzS9XcARdhxmW45Dqkj4qmjEMX9Jzu1eWE3Zp4lRh9y9XlrgrLFAWj5CxpslfJHGXmOBd9qRY7z8pnbfpDR0GjrvKtg2wPC9X6oNygwsQEYxwcHGqfxw%2BkAR2rjz%2FdzgRxfxgzz%2FlpWET7zHAJiZa%2FBMpyZ0X2vWKIaZ%2FToDDax2fqgbiwfZy3YTwI6dkdMxtjTIVsKH4rLkkNgwoXW7F4YxMWnFTYLkYCdgPlHYUCHRpP%2FIumJPOimyoDqpm7KA5FpvZ5ktKvKT7pkeLCVWhlOuCT0%2FAEV7uhUKCWIz8iGCnNUo38Bjp69%2ByAph0pZbJRpTA9ROxQKC8cj8UESZKKK4jBnbTcnWx%2Fm9bdO%2B7ifZpAtO%2FgcMfzCkKWftoL3Dn4Si2iX4gpr1KQ8uq4uf7JTt1YbrCfFiCqe0n0E%2Bb4znUp3Gjxa4Dmsw8PysLiGQEzy0LgCkDnnYxEyISODuApSWnB8Vzh5%2FheILWruZbnNCvFDr5yyf9GsRmiSKmMKYpDxsoqYp5oehml5A3FAGTLF%2FSM9a0wiGeFaOPsfG6XdsHH2H4ex7LXib1xDJEZpbnF1gPSYDVlE5W9SkM9ybMbhx2ZC0NaxNH1PYg1lda%2BujMzAecHzWWBhP%2FRo3%2F3oJI94CPueubfOCiVB7zdyXX27lQstTJ%2FvEJiVIwO6DUh%2FAw463N1AY6sgHWOpIapB8zJpwudKlC1GSjASc8jUiXvJSf88th2cejqHgOr%2Bdb7JqiVpi3Xn9AK6sb%2BDbU4ci8hD84aXWpiIIjKdPaFS4TgHyuLVS7NN8o0kO8Nyn%2FhiLQ6aqKRx%2B0o691XF8pGtqDxk3g2tJLi4fDhFjCgjr%2B4C5vSnkNZjW1u3K0Gh%2FVpw3hc%2BApFfY%2BV2QBEWpbtP8Vcl7DparLj845dITvO%2Fl9Vs6lpU7o892Anqzh&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47U4QYJLMLX%2F20260829%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260829T220402Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=b6bd34ae640c945c11146f53d01e9808e09b7ae58271d9490d8087b2ab2b265f\" data-large-file=\"https:\/\/blogs.glowscotland.org.uk\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2013\/02\/Slide193.png\" \/><\/a>\n\t\t\t<\/div><\/figure><figure class='gallery-item'>\n\t\t\t<div class='gallery-icon landscape'>\n\t\t\t\t<a href='https:\/\/blogs.glowscotland.org.uk\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2013\/02\/Slide202.png'><img decoding=\"async\" width=\"150\" height=\"112\" src=\"https:\/\/glow-prod-nl.s3.eu-west-1.amazonaws.com\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2013\/02\/Slide202-150x112.png?X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&amp;X-Amz-Security-Token=IQoJb3JpZ2luX2VjEKb%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJGMEQCICLN6euxLm0t6cByhB24RRtzPX1O38VvYaZqO9mgVUxiAiB%2BXrTSe0U7cL2%2F0If5iG6eTfMap4Ri%2FXy65PFpUPBWcyq5BQhvEAUaDDI3MzU3MDE5NTQzMyIMMKChVqIGmoXYBx4cKpYFRl4UxzNyhQiU8oCpkHCj5jq9nIMO0DSnYcTzUw6zsQ3N7zIjJIkC5edR8JrIw%2Fo5wrD1WhpfUfD7UWr0QvjuSjMRqKg3Cmxs237BK6LjgddLJNYezEqtdoA3bVJgxZ0YUgvpIkAutb7hYRDf9iNFa%2FcKlM3v9QTXclLUOZxxdz7S7ov%2FIpa%2B3DQYKzk%2FJf4%2BC5lr0y9uzS9XcARdhxmW45Dqkj4qmjEMX9Jzu1eWE3Zp4lRh9y9XlrgrLFAWj5CxpslfJHGXmOBd9qRY7z8pnbfpDR0GjrvKtg2wPC9X6oNygwsQEYxwcHGqfxw%2BkAR2rjz%2FdzgRxfxgzz%2FlpWET7zHAJiZa%2FBMpyZ0X2vWKIaZ%2FToDDax2fqgbiwfZy3YTwI6dkdMxtjTIVsKH4rLkkNgwoXW7F4YxMWnFTYLkYCdgPlHYUCHRpP%2FIumJPOimyoDqpm7KA5FpvZ5ktKvKT7pkeLCVWhlOuCT0%2FAEV7uhUKCWIz8iGCnNUo38Bjp69%2ByAph0pZbJRpTA9ROxQKC8cj8UESZKKK4jBnbTcnWx%2Fm9bdO%2B7ifZpAtO%2FgcMfzCkKWftoL3Dn4Si2iX4gpr1KQ8uq4uf7JTt1YbrCfFiCqe0n0E%2Bb4znUp3Gjxa4Dmsw8PysLiGQEzy0LgCkDnnYxEyISODuApSWnB8Vzh5%2FheILWruZbnNCvFDr5yyf9GsRmiSKmMKYpDxsoqYp5oehml5A3FAGTLF%2FSM9a0wiGeFaOPsfG6XdsHH2H4ex7LXib1xDJEZpbnF1gPSYDVlE5W9SkM9ybMbhx2ZC0NaxNH1PYg1lda%2BujMzAecHzWWBhP%2FRo3%2F3oJI94CPueubfOCiVB7zdyXX27lQstTJ%2FvEJiVIwO6DUh%2FAw463N1AY6sgHWOpIapB8zJpwudKlC1GSjASc8jUiXvJSf88th2cejqHgOr%2Bdb7JqiVpi3Xn9AK6sb%2BDbU4ci8hD84aXWpiIIjKdPaFS4TgHyuLVS7NN8o0kO8Nyn%2FhiLQ6aqKRx%2B0o691XF8pGtqDxk3g2tJLi4fDhFjCgjr%2B4C5vSnkNZjW1u3K0Gh%2FVpw3hc%2BApFfY%2BV2QBEWpbtP8Vcl7DparLj845dITvO%2Fl9Vs6lpU7o892Anqzh&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47U4QYJLMLX%2F20260829%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260829T220402Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=e669878d2f67bc80c1b910c4dbc1593a76c12807fba256888a6a020d21410f50\" class=\"attachment-thumbnail size-thumbnail\" alt=\"\" srcset=\"https:\/\/glow-prod-nl.s3.eu-west-1.amazonaws.com\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2013\/02\/Slide202-150x112.png?X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&amp;X-Amz-Security-Token=IQoJb3JpZ2luX2VjEKb%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJGMEQCICLN6euxLm0t6cByhB24RRtzPX1O38VvYaZqO9mgVUxiAiB%2BXrTSe0U7cL2%2F0If5iG6eTfMap4Ri%2FXy65PFpUPBWcyq5BQhvEAUaDDI3MzU3MDE5NTQzMyIMMKChVqIGmoXYBx4cKpYFRl4UxzNyhQiU8oCpkHCj5jq9nIMO0DSnYcTzUw6zsQ3N7zIjJIkC5edR8JrIw%2Fo5wrD1WhpfUfD7UWr0QvjuSjMRqKg3Cmxs237BK6LjgddLJNYezEqtdoA3bVJgxZ0YUgvpIkAutb7hYRDf9iNFa%2FcKlM3v9QTXclLUOZxxdz7S7ov%2FIpa%2B3DQYKzk%2FJf4%2BC5lr0y9uzS9XcARdhxmW45Dqkj4qmjEMX9Jzu1eWE3Zp4lRh9y9XlrgrLFAWj5CxpslfJHGXmOBd9qRY7z8pnbfpDR0GjrvKtg2wPC9X6oNygwsQEYxwcHGqfxw%2BkAR2rjz%2FdzgRxfxgzz%2FlpWET7zHAJiZa%2FBMpyZ0X2vWKIaZ%2FToDDax2fqgbiwfZy3YTwI6dkdMxtjTIVsKH4rLkkNgwoXW7F4YxMWnFTYLkYCdgPlHYUCHRpP%2FIumJPOimyoDqpm7KA5FpvZ5ktKvKT7pkeLCVWhlOuCT0%2FAEV7uhUKCWIz8iGCnNUo38Bjp69%2ByAph0pZbJRpTA9ROxQKC8cj8UESZKKK4jBnbTcnWx%2Fm9bdO%2B7ifZpAtO%2FgcMfzCkKWftoL3Dn4Si2iX4gpr1KQ8uq4uf7JTt1YbrCfFiCqe0n0E%2Bb4znUp3Gjxa4Dmsw8PysLiGQEzy0LgCkDnnYxEyISODuApSWnB8Vzh5%2FheILWruZbnNCvFDr5yyf9GsRmiSKmMKYpDxsoqYp5oehml5A3FAGTLF%2FSM9a0wiGeFaOPsfG6XdsHH2H4ex7LXib1xDJEZpbnF1gPSYDVlE5W9SkM9ybMbhx2ZC0NaxNH1PYg1lda%2BujMzAecHzWWBhP%2FRo3%2F3oJI94CPueubfOCiVB7zdyXX27lQstTJ%2FvEJiVIwO6DUh%2FAw463N1AY6sgHWOpIapB8zJpwudKlC1GSjASc8jUiXvJSf88th2cejqHgOr%2Bdb7JqiVpi3Xn9AK6sb%2BDbU4ci8hD84aXWpiIIjKdPaFS4TgHyuLVS7NN8o0kO8Nyn%2FhiLQ6aqKRx%2B0o691XF8pGtqDxk3g2tJLi4fDhFjCgjr%2B4C5vSnkNZjW1u3K0Gh%2FVpw3hc%2BApFfY%2BV2QBEWpbtP8Vcl7DparLj845dITvO%2Fl9Vs6lpU7o892Anqzh&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47U4QYJLMLX%2F20260829%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260829T220402Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=e669878d2f67bc80c1b910c4dbc1593a76c12807fba256888a6a020d21410f50 150w, https:\/\/glow-prod-nl.s3.eu-west-1.amazonaws.com\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2013\/02\/Slide202-300x225.png?X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&amp;X-Amz-Security-Token=IQoJb3JpZ2luX2VjEKb%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJGMEQCICLN6euxLm0t6cByhB24RRtzPX1O38VvYaZqO9mgVUxiAiB%2BXrTSe0U7cL2%2F0If5iG6eTfMap4Ri%2FXy65PFpUPBWcyq5BQhvEAUaDDI3MzU3MDE5NTQzMyIMMKChVqIGmoXYBx4cKpYFRl4UxzNyhQiU8oCpkHCj5jq9nIMO0DSnYcTzUw6zsQ3N7zIjJIkC5edR8JrIw%2Fo5wrD1WhpfUfD7UWr0QvjuSjMRqKg3Cmxs237BK6LjgddLJNYezEqtdoA3bVJgxZ0YUgvpIkAutb7hYRDf9iNFa%2FcKlM3v9QTXclLUOZxxdz7S7ov%2FIpa%2B3DQYKzk%2FJf4%2BC5lr0y9uzS9XcARdhxmW45Dqkj4qmjEMX9Jzu1eWE3Zp4lRh9y9XlrgrLFAWj5CxpslfJHGXmOBd9qRY7z8pnbfpDR0GjrvKtg2wPC9X6oNygwsQEYxwcHGqfxw%2BkAR2rjz%2FdzgRxfxgzz%2FlpWET7zHAJiZa%2FBMpyZ0X2vWKIaZ%2FToDDax2fqgbiwfZy3YTwI6dkdMxtjTIVsKH4rLkkNgwoXW7F4YxMWnFTYLkYCdgPlHYUCHRpP%2FIumJPOimyoDqpm7KA5FpvZ5ktKvKT7pkeLCVWhlOuCT0%2FAEV7uhUKCWIz8iGCnNUo38Bjp69%2ByAph0pZbJRpTA9ROxQKC8cj8UESZKKK4jBnbTcnWx%2Fm9bdO%2B7ifZpAtO%2FgcMfzCkKWftoL3Dn4Si2iX4gpr1KQ8uq4uf7JTt1YbrCfFiCqe0n0E%2Bb4znUp3Gjxa4Dmsw8PysLiGQEzy0LgCkDnnYxEyISODuApSWnB8Vzh5%2FheILWruZbnNCvFDr5yyf9GsRmiSKmMKYpDxsoqYp5oehml5A3FAGTLF%2FSM9a0wiGeFaOPsfG6XdsHH2H4ex7LXib1xDJEZpbnF1gPSYDVlE5W9SkM9ybMbhx2ZC0NaxNH1PYg1lda%2BujMzAecHzWWBhP%2FRo3%2F3oJI94CPueubfOCiVB7zdyXX27lQstTJ%2FvEJiVIwO6DUh%2FAw463N1AY6sgHWOpIapB8zJpwudKlC1GSjASc8jUiXvJSf88th2cejqHgOr%2Bdb7JqiVpi3Xn9AK6sb%2BDbU4ci8hD84aXWpiIIjKdPaFS4TgHyuLVS7NN8o0kO8Nyn%2FhiLQ6aqKRx%2B0o691XF8pGtqDxk3g2tJLi4fDhFjCgjr%2B4C5vSnkNZjW1u3K0Gh%2FVpw3hc%2BApFfY%2BV2QBEWpbtP8Vcl7DparLj845dITvO%2Fl9Vs6lpU7o892Anqzh&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47U4QYJLMLX%2F20260829%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260829T220402Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=2f458d01d606f5c0378e6cd612ecbc07248970b581d64ec79b749982271543e9 300w, https:\/\/blogs.glowscotland.org.uk\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2013\/02\/Slide202.png 600w\" sizes=\"(max-width: 150px) 100vw, 150px\" data-attachment-id=\"160\" data-permalink=\"https:\/\/blogs.glowscotland.org.uk\/nl\/ColtnessHS-ComputingScience\/2013\/02\/07\/spreadsheet-formula\/slide20-3\/\" data-orig-file=\"https:\/\/blogs.glowscotland.org.uk\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2013\/02\/Slide202.png\" data-orig-size=\"600,450\" data-comments-opened=\"1\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;}\" data-image-title=\"Slide20\" data-image-description=\"\" data-image-caption=\"\" data-medium-file=\"https:\/\/glow-prod-nl.s3.eu-west-1.amazonaws.com\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2013\/02\/Slide202-300x225.png?X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&amp;X-Amz-Security-Token=IQoJb3JpZ2luX2VjEKb%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJGMEQCICLN6euxLm0t6cByhB24RRtzPX1O38VvYaZqO9mgVUxiAiB%2BXrTSe0U7cL2%2F0If5iG6eTfMap4Ri%2FXy65PFpUPBWcyq5BQhvEAUaDDI3MzU3MDE5NTQzMyIMMKChVqIGmoXYBx4cKpYFRl4UxzNyhQiU8oCpkHCj5jq9nIMO0DSnYcTzUw6zsQ3N7zIjJIkC5edR8JrIw%2Fo5wrD1WhpfUfD7UWr0QvjuSjMRqKg3Cmxs237BK6LjgddLJNYezEqtdoA3bVJgxZ0YUgvpIkAutb7hYRDf9iNFa%2FcKlM3v9QTXclLUOZxxdz7S7ov%2FIpa%2B3DQYKzk%2FJf4%2BC5lr0y9uzS9XcARdhxmW45Dqkj4qmjEMX9Jzu1eWE3Zp4lRh9y9XlrgrLFAWj5CxpslfJHGXmOBd9qRY7z8pnbfpDR0GjrvKtg2wPC9X6oNygwsQEYxwcHGqfxw%2BkAR2rjz%2FdzgRxfxgzz%2FlpWET7zHAJiZa%2FBMpyZ0X2vWKIaZ%2FToDDax2fqgbiwfZy3YTwI6dkdMxtjTIVsKH4rLkkNgwoXW7F4YxMWnFTYLkYCdgPlHYUCHRpP%2FIumJPOimyoDqpm7KA5FpvZ5ktKvKT7pkeLCVWhlOuCT0%2FAEV7uhUKCWIz8iGCnNUo38Bjp69%2ByAph0pZbJRpTA9ROxQKC8cj8UESZKKK4jBnbTcnWx%2Fm9bdO%2B7ifZpAtO%2FgcMfzCkKWftoL3Dn4Si2iX4gpr1KQ8uq4uf7JTt1YbrCfFiCqe0n0E%2Bb4znUp3Gjxa4Dmsw8PysLiGQEzy0LgCkDnnYxEyISODuApSWnB8Vzh5%2FheILWruZbnNCvFDr5yyf9GsRmiSKmMKYpDxsoqYp5oehml5A3FAGTLF%2FSM9a0wiGeFaOPsfG6XdsHH2H4ex7LXib1xDJEZpbnF1gPSYDVlE5W9SkM9ybMbhx2ZC0NaxNH1PYg1lda%2BujMzAecHzWWBhP%2FRo3%2F3oJI94CPueubfOCiVB7zdyXX27lQstTJ%2FvEJiVIwO6DUh%2FAw463N1AY6sgHWOpIapB8zJpwudKlC1GSjASc8jUiXvJSf88th2cejqHgOr%2Bdb7JqiVpi3Xn9AK6sb%2BDbU4ci8hD84aXWpiIIjKdPaFS4TgHyuLVS7NN8o0kO8Nyn%2FhiLQ6aqKRx%2B0o691XF8pGtqDxk3g2tJLi4fDhFjCgjr%2B4C5vSnkNZjW1u3K0Gh%2FVpw3hc%2BApFfY%2BV2QBEWpbtP8Vcl7DparLj845dITvO%2Fl9Vs6lpU7o892Anqzh&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47U4QYJLMLX%2F20260829%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260829T220402Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=2f458d01d606f5c0378e6cd612ecbc07248970b581d64ec79b749982271543e9\" data-large-file=\"https:\/\/blogs.glowscotland.org.uk\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2013\/02\/Slide202.png\" \/><\/a>\n\t\t\t<\/div><\/figure>\n\t\t<\/div>\n\n","protected":false},"excerpt":{"rendered":"<p>Today we looked at how spreadsheets use formula. Every spreadsheet formula must start with an equals sign (=), this tells the spreadsheet application to treat the cell contents as a formula. We use the following\u00a0mathematical\u00a0formula in spreadsheets Add + Subtract &#8211; Multiply * Divide \/ The rules of BODMAS apply for complex\u00a0mathematical\u00a0conditions =A1*A5 =A1*A5 + &hellip;<\/p>\n","protected":false},"author":32,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[17300,9712],"class_list":["post-151","post","type-post","status-publish","format-standard","hentry","category-uncategorized","tag-complex","tag-formula"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/blogs.glowscotland.org.uk\/nl\/ColtnessHS-ComputingScience\/wp-json\/wp\/v2\/posts\/151","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blogs.glowscotland.org.uk\/nl\/ColtnessHS-ComputingScience\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blogs.glowscotland.org.uk\/nl\/ColtnessHS-ComputingScience\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blogs.glowscotland.org.uk\/nl\/ColtnessHS-ComputingScience\/wp-json\/wp\/v2\/users\/32"}],"replies":[{"embeddable":true,"href":"https:\/\/blogs.glowscotland.org.uk\/nl\/ColtnessHS-ComputingScience\/wp-json\/wp\/v2\/comments?post=151"}],"version-history":[{"count":1,"href":"https:\/\/blogs.glowscotland.org.uk\/nl\/ColtnessHS-ComputingScience\/wp-json\/wp\/v2\/posts\/151\/revisions"}],"predecessor-version":[{"id":161,"href":"https:\/\/blogs.glowscotland.org.uk\/nl\/ColtnessHS-ComputingScience\/wp-json\/wp\/v2\/posts\/151\/revisions\/161"}],"wp:attachment":[{"href":"https:\/\/blogs.glowscotland.org.uk\/nl\/ColtnessHS-ComputingScience\/wp-json\/wp\/v2\/media?parent=151"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blogs.glowscotland.org.uk\/nl\/ColtnessHS-ComputingScience\/wp-json\/wp\/v2\/categories?post=151"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blogs.glowscotland.org.uk\/nl\/ColtnessHS-ComputingScience\/wp-json\/wp\/v2\/tags?post=151"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}