{"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=IQoJb3JpZ2luX2VjEKL%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJHMEUCIGgGN7l2xQl4djSuAXm1AP9ecyp9%2Fb9BxElonCOLtr3PAiEAkoRVEIPOAiaJ65W7ij8mZfmO5DJFQoDBIiqlVWUlvwgquAUIaxAFGgwyNzM1NzAxOTU0MzMiDJOycTfWjy7huf8TDCqVBS03uVTrIjjzR%2B0npalSsMfk%2FUypHQ1gg0lg7mhNqA1Ojm5K0KlbzLs%2BmHjknctR6RQMtvqDRFwKioMWQVlRUac0ybFax1bHM28EDMooBoqczRf4YHilK9rZJHLk0E77eBliuy2KwS8gy6nMFFQAaMjPMPyIM7MDLHyP9aiPBCIBSBw3HodAQiRepf%2FXqLrBe%2BzHVv2Aa2jeNuiTyj37kiYx%2F1ZnO6MsdQS6ZrTve1VnUJAJUAK8HKadJS9iZI8Y6RLpN%2Bemmi6e9AuF6J4DhwdQR1IiKYJNp9atkh%2BIxTi4zSIkmyt8Q%2FKpNgrH6%2ByQy4ocvXEVfcjpd2%2Ba2CszJGg%2FBKw8t%2BsDr9ucOJSkAA6j7ffShjj90TppaFkZJOiNxH4abWnWW6t4kaoHwViMN0UCNLhgFaLNubUY2MYSaiQfEmQwiVZCz%2F52JdFkVZLOqmH5SZmTIGe3bjU1QxGbW%2BKEP9DTVWx6jab1apgP5XuFeaTwaNqwH4IOBd2aCLsjtXm5MfP4hOpHshusTkKENrCpYVzPFBa1ToEFINq29zeB22YQoenXGzKrbwu%2F1ENAvKvuVTu9gL2yeHdiGbXZmZfU2z%2Fs9TixEP3wy9PiAEVHZwEOEcYcQarcg88MJaPSWzIYC2HQPFFhYxn4sNryb0GrjySI%2Byg8BgiqOh9t7hwZktE%2FSB52YC4b6Z6KRWkc%2FJY8DPF8yVNolhc6Ou32dX3u95RbJ1A9Es1MiplanvQ0aNTQpek7d%2BOfBJLzVimUOusS4GFza5vQ25HO0vDCwTsLscJEmDrOIaLAPpNG3DkRztP3DxC7VCUjtgxni97BDDHrgG4c0AqNydVlpfAQCcv4x6w1J2xvyu0C19isf577W0EqowUw9%2FWd1wY6sQEKCmCJWEoMNTus%2FHLEAZ75LFBTisoZHqo6IRnpfx3MkHdes%2Bm9VvBiargIB8NcAoAhO%2FpyQxHy5b%2BwpprQNJ%2B9Vf5ZqpPq2OEP0mCT4tFij%2BbkWZN5kYH8HnPfYvtpFgcHiBkXtbvtJqz4eQgcnaWpQw2y5Qld2ny91lb0%2FaygD8AVGwgdNrQt4D3fWYjUMBYMdl1cOQhZjhrWoQgrFIigJNTchi4avPH2Gy0MAm1DTI8%3D&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47UXFX7YBOL%2F20261101%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20261101T180724Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=e233b3fa7fa0bdeda72307047de1e0abbd62292eea9bd105b41384d94067f3cc\" 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=IQoJb3JpZ2luX2VjEKL%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJHMEUCIGgGN7l2xQl4djSuAXm1AP9ecyp9%2Fb9BxElonCOLtr3PAiEAkoRVEIPOAiaJ65W7ij8mZfmO5DJFQoDBIiqlVWUlvwgquAUIaxAFGgwyNzM1NzAxOTU0MzMiDJOycTfWjy7huf8TDCqVBS03uVTrIjjzR%2B0npalSsMfk%2FUypHQ1gg0lg7mhNqA1Ojm5K0KlbzLs%2BmHjknctR6RQMtvqDRFwKioMWQVlRUac0ybFax1bHM28EDMooBoqczRf4YHilK9rZJHLk0E77eBliuy2KwS8gy6nMFFQAaMjPMPyIM7MDLHyP9aiPBCIBSBw3HodAQiRepf%2FXqLrBe%2BzHVv2Aa2jeNuiTyj37kiYx%2F1ZnO6MsdQS6ZrTve1VnUJAJUAK8HKadJS9iZI8Y6RLpN%2Bemmi6e9AuF6J4DhwdQR1IiKYJNp9atkh%2BIxTi4zSIkmyt8Q%2FKpNgrH6%2ByQy4ocvXEVfcjpd2%2Ba2CszJGg%2FBKw8t%2BsDr9ucOJSkAA6j7ffShjj90TppaFkZJOiNxH4abWnWW6t4kaoHwViMN0UCNLhgFaLNubUY2MYSaiQfEmQwiVZCz%2F52JdFkVZLOqmH5SZmTIGe3bjU1QxGbW%2BKEP9DTVWx6jab1apgP5XuFeaTwaNqwH4IOBd2aCLsjtXm5MfP4hOpHshusTkKENrCpYVzPFBa1ToEFINq29zeB22YQoenXGzKrbwu%2F1ENAvKvuVTu9gL2yeHdiGbXZmZfU2z%2Fs9TixEP3wy9PiAEVHZwEOEcYcQarcg88MJaPSWzIYC2HQPFFhYxn4sNryb0GrjySI%2Byg8BgiqOh9t7hwZktE%2FSB52YC4b6Z6KRWkc%2FJY8DPF8yVNolhc6Ou32dX3u95RbJ1A9Es1MiplanvQ0aNTQpek7d%2BOfBJLzVimUOusS4GFza5vQ25HO0vDCwTsLscJEmDrOIaLAPpNG3DkRztP3DxC7VCUjtgxni97BDDHrgG4c0AqNydVlpfAQCcv4x6w1J2xvyu0C19isf577W0EqowUw9%2FWd1wY6sQEKCmCJWEoMNTus%2FHLEAZ75LFBTisoZHqo6IRnpfx3MkHdes%2Bm9VvBiargIB8NcAoAhO%2FpyQxHy5b%2BwpprQNJ%2B9Vf5ZqpPq2OEP0mCT4tFij%2BbkWZN5kYH8HnPfYvtpFgcHiBkXtbvtJqz4eQgcnaWpQw2y5Qld2ny91lb0%2FaygD8AVGwgdNrQt4D3fWYjUMBYMdl1cOQhZjhrWoQgrFIigJNTchi4avPH2Gy0MAm1DTI8%3D&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47UXFX7YBOL%2F20261101%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20261101T180724Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=e233b3fa7fa0bdeda72307047de1e0abbd62292eea9bd105b41384d94067f3cc 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=IQoJb3JpZ2luX2VjEKL%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJHMEUCIGgGN7l2xQl4djSuAXm1AP9ecyp9%2Fb9BxElonCOLtr3PAiEAkoRVEIPOAiaJ65W7ij8mZfmO5DJFQoDBIiqlVWUlvwgquAUIaxAFGgwyNzM1NzAxOTU0MzMiDJOycTfWjy7huf8TDCqVBS03uVTrIjjzR%2B0npalSsMfk%2FUypHQ1gg0lg7mhNqA1Ojm5K0KlbzLs%2BmHjknctR6RQMtvqDRFwKioMWQVlRUac0ybFax1bHM28EDMooBoqczRf4YHilK9rZJHLk0E77eBliuy2KwS8gy6nMFFQAaMjPMPyIM7MDLHyP9aiPBCIBSBw3HodAQiRepf%2FXqLrBe%2BzHVv2Aa2jeNuiTyj37kiYx%2F1ZnO6MsdQS6ZrTve1VnUJAJUAK8HKadJS9iZI8Y6RLpN%2Bemmi6e9AuF6J4DhwdQR1IiKYJNp9atkh%2BIxTi4zSIkmyt8Q%2FKpNgrH6%2ByQy4ocvXEVfcjpd2%2Ba2CszJGg%2FBKw8t%2BsDr9ucOJSkAA6j7ffShjj90TppaFkZJOiNxH4abWnWW6t4kaoHwViMN0UCNLhgFaLNubUY2MYSaiQfEmQwiVZCz%2F52JdFkVZLOqmH5SZmTIGe3bjU1QxGbW%2BKEP9DTVWx6jab1apgP5XuFeaTwaNqwH4IOBd2aCLsjtXm5MfP4hOpHshusTkKENrCpYVzPFBa1ToEFINq29zeB22YQoenXGzKrbwu%2F1ENAvKvuVTu9gL2yeHdiGbXZmZfU2z%2Fs9TixEP3wy9PiAEVHZwEOEcYcQarcg88MJaPSWzIYC2HQPFFhYxn4sNryb0GrjySI%2Byg8BgiqOh9t7hwZktE%2FSB52YC4b6Z6KRWkc%2FJY8DPF8yVNolhc6Ou32dX3u95RbJ1A9Es1MiplanvQ0aNTQpek7d%2BOfBJLzVimUOusS4GFza5vQ25HO0vDCwTsLscJEmDrOIaLAPpNG3DkRztP3DxC7VCUjtgxni97BDDHrgG4c0AqNydVlpfAQCcv4x6w1J2xvyu0C19isf577W0EqowUw9%2FWd1wY6sQEKCmCJWEoMNTus%2FHLEAZ75LFBTisoZHqo6IRnpfx3MkHdes%2Bm9VvBiargIB8NcAoAhO%2FpyQxHy5b%2BwpprQNJ%2B9Vf5ZqpPq2OEP0mCT4tFij%2BbkWZN5kYH8HnPfYvtpFgcHiBkXtbvtJqz4eQgcnaWpQw2y5Qld2ny91lb0%2FaygD8AVGwgdNrQt4D3fWYjUMBYMdl1cOQhZjhrWoQgrFIigJNTchi4avPH2Gy0MAm1DTI8%3D&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47UXFX7YBOL%2F20261101%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20261101T180724Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=0f7083984ce715bfbee751eaca6389c33b27d8224988a586d536152ae59867d1 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=IQoJb3JpZ2luX2VjEKL%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJHMEUCIGgGN7l2xQl4djSuAXm1AP9ecyp9%2Fb9BxElonCOLtr3PAiEAkoRVEIPOAiaJ65W7ij8mZfmO5DJFQoDBIiqlVWUlvwgquAUIaxAFGgwyNzM1NzAxOTU0MzMiDJOycTfWjy7huf8TDCqVBS03uVTrIjjzR%2B0npalSsMfk%2FUypHQ1gg0lg7mhNqA1Ojm5K0KlbzLs%2BmHjknctR6RQMtvqDRFwKioMWQVlRUac0ybFax1bHM28EDMooBoqczRf4YHilK9rZJHLk0E77eBliuy2KwS8gy6nMFFQAaMjPMPyIM7MDLHyP9aiPBCIBSBw3HodAQiRepf%2FXqLrBe%2BzHVv2Aa2jeNuiTyj37kiYx%2F1ZnO6MsdQS6ZrTve1VnUJAJUAK8HKadJS9iZI8Y6RLpN%2Bemmi6e9AuF6J4DhwdQR1IiKYJNp9atkh%2BIxTi4zSIkmyt8Q%2FKpNgrH6%2ByQy4ocvXEVfcjpd2%2Ba2CszJGg%2FBKw8t%2BsDr9ucOJSkAA6j7ffShjj90TppaFkZJOiNxH4abWnWW6t4kaoHwViMN0UCNLhgFaLNubUY2MYSaiQfEmQwiVZCz%2F52JdFkVZLOqmH5SZmTIGe3bjU1QxGbW%2BKEP9DTVWx6jab1apgP5XuFeaTwaNqwH4IOBd2aCLsjtXm5MfP4hOpHshusTkKENrCpYVzPFBa1ToEFINq29zeB22YQoenXGzKrbwu%2F1ENAvKvuVTu9gL2yeHdiGbXZmZfU2z%2Fs9TixEP3wy9PiAEVHZwEOEcYcQarcg88MJaPSWzIYC2HQPFFhYxn4sNryb0GrjySI%2Byg8BgiqOh9t7hwZktE%2FSB52YC4b6Z6KRWkc%2FJY8DPF8yVNolhc6Ou32dX3u95RbJ1A9Es1MiplanvQ0aNTQpek7d%2BOfBJLzVimUOusS4GFza5vQ25HO0vDCwTsLscJEmDrOIaLAPpNG3DkRztP3DxC7VCUjtgxni97BDDHrgG4c0AqNydVlpfAQCcv4x6w1J2xvyu0C19isf577W0EqowUw9%2FWd1wY6sQEKCmCJWEoMNTus%2FHLEAZ75LFBTisoZHqo6IRnpfx3MkHdes%2Bm9VvBiargIB8NcAoAhO%2FpyQxHy5b%2BwpprQNJ%2B9Vf5ZqpPq2OEP0mCT4tFij%2BbkWZN5kYH8HnPfYvtpFgcHiBkXtbvtJqz4eQgcnaWpQw2y5Qld2ny91lb0%2FaygD8AVGwgdNrQt4D3fWYjUMBYMdl1cOQhZjhrWoQgrFIigJNTchi4avPH2Gy0MAm1DTI8%3D&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47UXFX7YBOL%2F20261101%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20261101T180724Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=0f7083984ce715bfbee751eaca6389c33b27d8224988a586d536152ae59867d1\" 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=IQoJb3JpZ2luX2VjEKL%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJHMEUCIGgGN7l2xQl4djSuAXm1AP9ecyp9%2Fb9BxElonCOLtr3PAiEAkoRVEIPOAiaJ65W7ij8mZfmO5DJFQoDBIiqlVWUlvwgquAUIaxAFGgwyNzM1NzAxOTU0MzMiDJOycTfWjy7huf8TDCqVBS03uVTrIjjzR%2B0npalSsMfk%2FUypHQ1gg0lg7mhNqA1Ojm5K0KlbzLs%2BmHjknctR6RQMtvqDRFwKioMWQVlRUac0ybFax1bHM28EDMooBoqczRf4YHilK9rZJHLk0E77eBliuy2KwS8gy6nMFFQAaMjPMPyIM7MDLHyP9aiPBCIBSBw3HodAQiRepf%2FXqLrBe%2BzHVv2Aa2jeNuiTyj37kiYx%2F1ZnO6MsdQS6ZrTve1VnUJAJUAK8HKadJS9iZI8Y6RLpN%2Bemmi6e9AuF6J4DhwdQR1IiKYJNp9atkh%2BIxTi4zSIkmyt8Q%2FKpNgrH6%2ByQy4ocvXEVfcjpd2%2Ba2CszJGg%2FBKw8t%2BsDr9ucOJSkAA6j7ffShjj90TppaFkZJOiNxH4abWnWW6t4kaoHwViMN0UCNLhgFaLNubUY2MYSaiQfEmQwiVZCz%2F52JdFkVZLOqmH5SZmTIGe3bjU1QxGbW%2BKEP9DTVWx6jab1apgP5XuFeaTwaNqwH4IOBd2aCLsjtXm5MfP4hOpHshusTkKENrCpYVzPFBa1ToEFINq29zeB22YQoenXGzKrbwu%2F1ENAvKvuVTu9gL2yeHdiGbXZmZfU2z%2Fs9TixEP3wy9PiAEVHZwEOEcYcQarcg88MJaPSWzIYC2HQPFFhYxn4sNryb0GrjySI%2Byg8BgiqOh9t7hwZktE%2FSB52YC4b6Z6KRWkc%2FJY8DPF8yVNolhc6Ou32dX3u95RbJ1A9Es1MiplanvQ0aNTQpek7d%2BOfBJLzVimUOusS4GFza5vQ25HO0vDCwTsLscJEmDrOIaLAPpNG3DkRztP3DxC7VCUjtgxni97BDDHrgG4c0AqNydVlpfAQCcv4x6w1J2xvyu0C19isf577W0EqowUw9%2FWd1wY6sQEKCmCJWEoMNTus%2FHLEAZ75LFBTisoZHqo6IRnpfx3MkHdes%2Bm9VvBiargIB8NcAoAhO%2FpyQxHy5b%2BwpprQNJ%2B9Vf5ZqpPq2OEP0mCT4tFij%2BbkWZN5kYH8HnPfYvtpFgcHiBkXtbvtJqz4eQgcnaWpQw2y5Qld2ny91lb0%2FaygD8AVGwgdNrQt4D3fWYjUMBYMdl1cOQhZjhrWoQgrFIigJNTchi4avPH2Gy0MAm1DTI8%3D&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47UXFX7YBOL%2F20261101%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20261101T180724Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=ac8ff0e53dc17027f3ac6413a897cb5683f2dfd922283dcd866b3fc7830a0c64\" 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=IQoJb3JpZ2luX2VjEKL%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJHMEUCIGgGN7l2xQl4djSuAXm1AP9ecyp9%2Fb9BxElonCOLtr3PAiEAkoRVEIPOAiaJ65W7ij8mZfmO5DJFQoDBIiqlVWUlvwgquAUIaxAFGgwyNzM1NzAxOTU0MzMiDJOycTfWjy7huf8TDCqVBS03uVTrIjjzR%2B0npalSsMfk%2FUypHQ1gg0lg7mhNqA1Ojm5K0KlbzLs%2BmHjknctR6RQMtvqDRFwKioMWQVlRUac0ybFax1bHM28EDMooBoqczRf4YHilK9rZJHLk0E77eBliuy2KwS8gy6nMFFQAaMjPMPyIM7MDLHyP9aiPBCIBSBw3HodAQiRepf%2FXqLrBe%2BzHVv2Aa2jeNuiTyj37kiYx%2F1ZnO6MsdQS6ZrTve1VnUJAJUAK8HKadJS9iZI8Y6RLpN%2Bemmi6e9AuF6J4DhwdQR1IiKYJNp9atkh%2BIxTi4zSIkmyt8Q%2FKpNgrH6%2ByQy4ocvXEVfcjpd2%2Ba2CszJGg%2FBKw8t%2BsDr9ucOJSkAA6j7ffShjj90TppaFkZJOiNxH4abWnWW6t4kaoHwViMN0UCNLhgFaLNubUY2MYSaiQfEmQwiVZCz%2F52JdFkVZLOqmH5SZmTIGe3bjU1QxGbW%2BKEP9DTVWx6jab1apgP5XuFeaTwaNqwH4IOBd2aCLsjtXm5MfP4hOpHshusTkKENrCpYVzPFBa1ToEFINq29zeB22YQoenXGzKrbwu%2F1ENAvKvuVTu9gL2yeHdiGbXZmZfU2z%2Fs9TixEP3wy9PiAEVHZwEOEcYcQarcg88MJaPSWzIYC2HQPFFhYxn4sNryb0GrjySI%2Byg8BgiqOh9t7hwZktE%2FSB52YC4b6Z6KRWkc%2FJY8DPF8yVNolhc6Ou32dX3u95RbJ1A9Es1MiplanvQ0aNTQpek7d%2BOfBJLzVimUOusS4GFza5vQ25HO0vDCwTsLscJEmDrOIaLAPpNG3DkRztP3DxC7VCUjtgxni97BDDHrgG4c0AqNydVlpfAQCcv4x6w1J2xvyu0C19isf577W0EqowUw9%2FWd1wY6sQEKCmCJWEoMNTus%2FHLEAZ75LFBTisoZHqo6IRnpfx3MkHdes%2Bm9VvBiargIB8NcAoAhO%2FpyQxHy5b%2BwpprQNJ%2B9Vf5ZqpPq2OEP0mCT4tFij%2BbkWZN5kYH8HnPfYvtpFgcHiBkXtbvtJqz4eQgcnaWpQw2y5Qld2ny91lb0%2FaygD8AVGwgdNrQt4D3fWYjUMBYMdl1cOQhZjhrWoQgrFIigJNTchi4avPH2Gy0MAm1DTI8%3D&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47UXFX7YBOL%2F20261101%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20261101T180724Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=ac8ff0e53dc17027f3ac6413a897cb5683f2dfd922283dcd866b3fc7830a0c64 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=IQoJb3JpZ2luX2VjEKL%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJHMEUCIGgGN7l2xQl4djSuAXm1AP9ecyp9%2Fb9BxElonCOLtr3PAiEAkoRVEIPOAiaJ65W7ij8mZfmO5DJFQoDBIiqlVWUlvwgquAUIaxAFGgwyNzM1NzAxOTU0MzMiDJOycTfWjy7huf8TDCqVBS03uVTrIjjzR%2B0npalSsMfk%2FUypHQ1gg0lg7mhNqA1Ojm5K0KlbzLs%2BmHjknctR6RQMtvqDRFwKioMWQVlRUac0ybFax1bHM28EDMooBoqczRf4YHilK9rZJHLk0E77eBliuy2KwS8gy6nMFFQAaMjPMPyIM7MDLHyP9aiPBCIBSBw3HodAQiRepf%2FXqLrBe%2BzHVv2Aa2jeNuiTyj37kiYx%2F1ZnO6MsdQS6ZrTve1VnUJAJUAK8HKadJS9iZI8Y6RLpN%2Bemmi6e9AuF6J4DhwdQR1IiKYJNp9atkh%2BIxTi4zSIkmyt8Q%2FKpNgrH6%2ByQy4ocvXEVfcjpd2%2Ba2CszJGg%2FBKw8t%2BsDr9ucOJSkAA6j7ffShjj90TppaFkZJOiNxH4abWnWW6t4kaoHwViMN0UCNLhgFaLNubUY2MYSaiQfEmQwiVZCz%2F52JdFkVZLOqmH5SZmTIGe3bjU1QxGbW%2BKEP9DTVWx6jab1apgP5XuFeaTwaNqwH4IOBd2aCLsjtXm5MfP4hOpHshusTkKENrCpYVzPFBa1ToEFINq29zeB22YQoenXGzKrbwu%2F1ENAvKvuVTu9gL2yeHdiGbXZmZfU2z%2Fs9TixEP3wy9PiAEVHZwEOEcYcQarcg88MJaPSWzIYC2HQPFFhYxn4sNryb0GrjySI%2Byg8BgiqOh9t7hwZktE%2FSB52YC4b6Z6KRWkc%2FJY8DPF8yVNolhc6Ou32dX3u95RbJ1A9Es1MiplanvQ0aNTQpek7d%2BOfBJLzVimUOusS4GFza5vQ25HO0vDCwTsLscJEmDrOIaLAPpNG3DkRztP3DxC7VCUjtgxni97BDDHrgG4c0AqNydVlpfAQCcv4x6w1J2xvyu0C19isf577W0EqowUw9%2FWd1wY6sQEKCmCJWEoMNTus%2FHLEAZ75LFBTisoZHqo6IRnpfx3MkHdes%2Bm9VvBiargIB8NcAoAhO%2FpyQxHy5b%2BwpprQNJ%2B9Vf5ZqpPq2OEP0mCT4tFij%2BbkWZN5kYH8HnPfYvtpFgcHiBkXtbvtJqz4eQgcnaWpQw2y5Qld2ny91lb0%2FaygD8AVGwgdNrQt4D3fWYjUMBYMdl1cOQhZjhrWoQgrFIigJNTchi4avPH2Gy0MAm1DTI8%3D&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47UXFX7YBOL%2F20261101%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20261101T180724Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=57d98d929603cb811d521cdbaa005cac89dc48d2f33a0485a76ef03a16f387fb 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=IQoJb3JpZ2luX2VjEKL%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJHMEUCIGgGN7l2xQl4djSuAXm1AP9ecyp9%2Fb9BxElonCOLtr3PAiEAkoRVEIPOAiaJ65W7ij8mZfmO5DJFQoDBIiqlVWUlvwgquAUIaxAFGgwyNzM1NzAxOTU0MzMiDJOycTfWjy7huf8TDCqVBS03uVTrIjjzR%2B0npalSsMfk%2FUypHQ1gg0lg7mhNqA1Ojm5K0KlbzLs%2BmHjknctR6RQMtvqDRFwKioMWQVlRUac0ybFax1bHM28EDMooBoqczRf4YHilK9rZJHLk0E77eBliuy2KwS8gy6nMFFQAaMjPMPyIM7MDLHyP9aiPBCIBSBw3HodAQiRepf%2FXqLrBe%2BzHVv2Aa2jeNuiTyj37kiYx%2F1ZnO6MsdQS6ZrTve1VnUJAJUAK8HKadJS9iZI8Y6RLpN%2Bemmi6e9AuF6J4DhwdQR1IiKYJNp9atkh%2BIxTi4zSIkmyt8Q%2FKpNgrH6%2ByQy4ocvXEVfcjpd2%2Ba2CszJGg%2FBKw8t%2BsDr9ucOJSkAA6j7ffShjj90TppaFkZJOiNxH4abWnWW6t4kaoHwViMN0UCNLhgFaLNubUY2MYSaiQfEmQwiVZCz%2F52JdFkVZLOqmH5SZmTIGe3bjU1QxGbW%2BKEP9DTVWx6jab1apgP5XuFeaTwaNqwH4IOBd2aCLsjtXm5MfP4hOpHshusTkKENrCpYVzPFBa1ToEFINq29zeB22YQoenXGzKrbwu%2F1ENAvKvuVTu9gL2yeHdiGbXZmZfU2z%2Fs9TixEP3wy9PiAEVHZwEOEcYcQarcg88MJaPSWzIYC2HQPFFhYxn4sNryb0GrjySI%2Byg8BgiqOh9t7hwZktE%2FSB52YC4b6Z6KRWkc%2FJY8DPF8yVNolhc6Ou32dX3u95RbJ1A9Es1MiplanvQ0aNTQpek7d%2BOfBJLzVimUOusS4GFza5vQ25HO0vDCwTsLscJEmDrOIaLAPpNG3DkRztP3DxC7VCUjtgxni97BDDHrgG4c0AqNydVlpfAQCcv4x6w1J2xvyu0C19isf577W0EqowUw9%2FWd1wY6sQEKCmCJWEoMNTus%2FHLEAZ75LFBTisoZHqo6IRnpfx3MkHdes%2Bm9VvBiargIB8NcAoAhO%2FpyQxHy5b%2BwpprQNJ%2B9Vf5ZqpPq2OEP0mCT4tFij%2BbkWZN5kYH8HnPfYvtpFgcHiBkXtbvtJqz4eQgcnaWpQw2y5Qld2ny91lb0%2FaygD8AVGwgdNrQt4D3fWYjUMBYMdl1cOQhZjhrWoQgrFIigJNTchi4avPH2Gy0MAm1DTI8%3D&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47UXFX7YBOL%2F20261101%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20261101T180724Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=57d98d929603cb811d521cdbaa005cac89dc48d2f33a0485a76ef03a16f387fb\" 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=IQoJb3JpZ2luX2VjEKL%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJHMEUCIGgGN7l2xQl4djSuAXm1AP9ecyp9%2Fb9BxElonCOLtr3PAiEAkoRVEIPOAiaJ65W7ij8mZfmO5DJFQoDBIiqlVWUlvwgquAUIaxAFGgwyNzM1NzAxOTU0MzMiDJOycTfWjy7huf8TDCqVBS03uVTrIjjzR%2B0npalSsMfk%2FUypHQ1gg0lg7mhNqA1Ojm5K0KlbzLs%2BmHjknctR6RQMtvqDRFwKioMWQVlRUac0ybFax1bHM28EDMooBoqczRf4YHilK9rZJHLk0E77eBliuy2KwS8gy6nMFFQAaMjPMPyIM7MDLHyP9aiPBCIBSBw3HodAQiRepf%2FXqLrBe%2BzHVv2Aa2jeNuiTyj37kiYx%2F1ZnO6MsdQS6ZrTve1VnUJAJUAK8HKadJS9iZI8Y6RLpN%2Bemmi6e9AuF6J4DhwdQR1IiKYJNp9atkh%2BIxTi4zSIkmyt8Q%2FKpNgrH6%2ByQy4ocvXEVfcjpd2%2Ba2CszJGg%2FBKw8t%2BsDr9ucOJSkAA6j7ffShjj90TppaFkZJOiNxH4abWnWW6t4kaoHwViMN0UCNLhgFaLNubUY2MYSaiQfEmQwiVZCz%2F52JdFkVZLOqmH5SZmTIGe3bjU1QxGbW%2BKEP9DTVWx6jab1apgP5XuFeaTwaNqwH4IOBd2aCLsjtXm5MfP4hOpHshusTkKENrCpYVzPFBa1ToEFINq29zeB22YQoenXGzKrbwu%2F1ENAvKvuVTu9gL2yeHdiGbXZmZfU2z%2Fs9TixEP3wy9PiAEVHZwEOEcYcQarcg88MJaPSWzIYC2HQPFFhYxn4sNryb0GrjySI%2Byg8BgiqOh9t7hwZktE%2FSB52YC4b6Z6KRWkc%2FJY8DPF8yVNolhc6Ou32dX3u95RbJ1A9Es1MiplanvQ0aNTQpek7d%2BOfBJLzVimUOusS4GFza5vQ25HO0vDCwTsLscJEmDrOIaLAPpNG3DkRztP3DxC7VCUjtgxni97BDDHrgG4c0AqNydVlpfAQCcv4x6w1J2xvyu0C19isf577W0EqowUw9%2FWd1wY6sQEKCmCJWEoMNTus%2FHLEAZ75LFBTisoZHqo6IRnpfx3MkHdes%2Bm9VvBiargIB8NcAoAhO%2FpyQxHy5b%2BwpprQNJ%2B9Vf5ZqpPq2OEP0mCT4tFij%2BbkWZN5kYH8HnPfYvtpFgcHiBkXtbvtJqz4eQgcnaWpQw2y5Qld2ny91lb0%2FaygD8AVGwgdNrQt4D3fWYjUMBYMdl1cOQhZjhrWoQgrFIigJNTchi4avPH2Gy0MAm1DTI8%3D&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47UXFX7YBOL%2F20261101%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20261101T180724Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=4a622a7278faaa99ad4a58ed29024f3a89384aa0e42e6ff35ebfb053ca4cee1e\" 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=IQoJb3JpZ2luX2VjEKL%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJHMEUCIGgGN7l2xQl4djSuAXm1AP9ecyp9%2Fb9BxElonCOLtr3PAiEAkoRVEIPOAiaJ65W7ij8mZfmO5DJFQoDBIiqlVWUlvwgquAUIaxAFGgwyNzM1NzAxOTU0MzMiDJOycTfWjy7huf8TDCqVBS03uVTrIjjzR%2B0npalSsMfk%2FUypHQ1gg0lg7mhNqA1Ojm5K0KlbzLs%2BmHjknctR6RQMtvqDRFwKioMWQVlRUac0ybFax1bHM28EDMooBoqczRf4YHilK9rZJHLk0E77eBliuy2KwS8gy6nMFFQAaMjPMPyIM7MDLHyP9aiPBCIBSBw3HodAQiRepf%2FXqLrBe%2BzHVv2Aa2jeNuiTyj37kiYx%2F1ZnO6MsdQS6ZrTve1VnUJAJUAK8HKadJS9iZI8Y6RLpN%2Bemmi6e9AuF6J4DhwdQR1IiKYJNp9atkh%2BIxTi4zSIkmyt8Q%2FKpNgrH6%2ByQy4ocvXEVfcjpd2%2Ba2CszJGg%2FBKw8t%2BsDr9ucOJSkAA6j7ffShjj90TppaFkZJOiNxH4abWnWW6t4kaoHwViMN0UCNLhgFaLNubUY2MYSaiQfEmQwiVZCz%2F52JdFkVZLOqmH5SZmTIGe3bjU1QxGbW%2BKEP9DTVWx6jab1apgP5XuFeaTwaNqwH4IOBd2aCLsjtXm5MfP4hOpHshusTkKENrCpYVzPFBa1ToEFINq29zeB22YQoenXGzKrbwu%2F1ENAvKvuVTu9gL2yeHdiGbXZmZfU2z%2Fs9TixEP3wy9PiAEVHZwEOEcYcQarcg88MJaPSWzIYC2HQPFFhYxn4sNryb0GrjySI%2Byg8BgiqOh9t7hwZktE%2FSB52YC4b6Z6KRWkc%2FJY8DPF8yVNolhc6Ou32dX3u95RbJ1A9Es1MiplanvQ0aNTQpek7d%2BOfBJLzVimUOusS4GFza5vQ25HO0vDCwTsLscJEmDrOIaLAPpNG3DkRztP3DxC7VCUjtgxni97BDDHrgG4c0AqNydVlpfAQCcv4x6w1J2xvyu0C19isf577W0EqowUw9%2FWd1wY6sQEKCmCJWEoMNTus%2FHLEAZ75LFBTisoZHqo6IRnpfx3MkHdes%2Bm9VvBiargIB8NcAoAhO%2FpyQxHy5b%2BwpprQNJ%2B9Vf5ZqpPq2OEP0mCT4tFij%2BbkWZN5kYH8HnPfYvtpFgcHiBkXtbvtJqz4eQgcnaWpQw2y5Qld2ny91lb0%2FaygD8AVGwgdNrQt4D3fWYjUMBYMdl1cOQhZjhrWoQgrFIigJNTchi4avPH2Gy0MAm1DTI8%3D&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47UXFX7YBOL%2F20261101%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20261101T180724Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=4a622a7278faaa99ad4a58ed29024f3a89384aa0e42e6ff35ebfb053ca4cee1e 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=IQoJb3JpZ2luX2VjEKL%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJHMEUCIGgGN7l2xQl4djSuAXm1AP9ecyp9%2Fb9BxElonCOLtr3PAiEAkoRVEIPOAiaJ65W7ij8mZfmO5DJFQoDBIiqlVWUlvwgquAUIaxAFGgwyNzM1NzAxOTU0MzMiDJOycTfWjy7huf8TDCqVBS03uVTrIjjzR%2B0npalSsMfk%2FUypHQ1gg0lg7mhNqA1Ojm5K0KlbzLs%2BmHjknctR6RQMtvqDRFwKioMWQVlRUac0ybFax1bHM28EDMooBoqczRf4YHilK9rZJHLk0E77eBliuy2KwS8gy6nMFFQAaMjPMPyIM7MDLHyP9aiPBCIBSBw3HodAQiRepf%2FXqLrBe%2BzHVv2Aa2jeNuiTyj37kiYx%2F1ZnO6MsdQS6ZrTve1VnUJAJUAK8HKadJS9iZI8Y6RLpN%2Bemmi6e9AuF6J4DhwdQR1IiKYJNp9atkh%2BIxTi4zSIkmyt8Q%2FKpNgrH6%2ByQy4ocvXEVfcjpd2%2Ba2CszJGg%2FBKw8t%2BsDr9ucOJSkAA6j7ffShjj90TppaFkZJOiNxH4abWnWW6t4kaoHwViMN0UCNLhgFaLNubUY2MYSaiQfEmQwiVZCz%2F52JdFkVZLOqmH5SZmTIGe3bjU1QxGbW%2BKEP9DTVWx6jab1apgP5XuFeaTwaNqwH4IOBd2aCLsjtXm5MfP4hOpHshusTkKENrCpYVzPFBa1ToEFINq29zeB22YQoenXGzKrbwu%2F1ENAvKvuVTu9gL2yeHdiGbXZmZfU2z%2Fs9TixEP3wy9PiAEVHZwEOEcYcQarcg88MJaPSWzIYC2HQPFFhYxn4sNryb0GrjySI%2Byg8BgiqOh9t7hwZktE%2FSB52YC4b6Z6KRWkc%2FJY8DPF8yVNolhc6Ou32dX3u95RbJ1A9Es1MiplanvQ0aNTQpek7d%2BOfBJLzVimUOusS4GFza5vQ25HO0vDCwTsLscJEmDrOIaLAPpNG3DkRztP3DxC7VCUjtgxni97BDDHrgG4c0AqNydVlpfAQCcv4x6w1J2xvyu0C19isf577W0EqowUw9%2FWd1wY6sQEKCmCJWEoMNTus%2FHLEAZ75LFBTisoZHqo6IRnpfx3MkHdes%2Bm9VvBiargIB8NcAoAhO%2FpyQxHy5b%2BwpprQNJ%2B9Vf5ZqpPq2OEP0mCT4tFij%2BbkWZN5kYH8HnPfYvtpFgcHiBkXtbvtJqz4eQgcnaWpQw2y5Qld2ny91lb0%2FaygD8AVGwgdNrQt4D3fWYjUMBYMdl1cOQhZjhrWoQgrFIigJNTchi4avPH2Gy0MAm1DTI8%3D&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47UXFX7YBOL%2F20261101%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20261101T180724Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=9c3821088b58f033adae56edd3e1748072c4b1e0ce2beef6e73226dbbd99e2ef 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=IQoJb3JpZ2luX2VjEKL%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJHMEUCIGgGN7l2xQl4djSuAXm1AP9ecyp9%2Fb9BxElonCOLtr3PAiEAkoRVEIPOAiaJ65W7ij8mZfmO5DJFQoDBIiqlVWUlvwgquAUIaxAFGgwyNzM1NzAxOTU0MzMiDJOycTfWjy7huf8TDCqVBS03uVTrIjjzR%2B0npalSsMfk%2FUypHQ1gg0lg7mhNqA1Ojm5K0KlbzLs%2BmHjknctR6RQMtvqDRFwKioMWQVlRUac0ybFax1bHM28EDMooBoqczRf4YHilK9rZJHLk0E77eBliuy2KwS8gy6nMFFQAaMjPMPyIM7MDLHyP9aiPBCIBSBw3HodAQiRepf%2FXqLrBe%2BzHVv2Aa2jeNuiTyj37kiYx%2F1ZnO6MsdQS6ZrTve1VnUJAJUAK8HKadJS9iZI8Y6RLpN%2Bemmi6e9AuF6J4DhwdQR1IiKYJNp9atkh%2BIxTi4zSIkmyt8Q%2FKpNgrH6%2ByQy4ocvXEVfcjpd2%2Ba2CszJGg%2FBKw8t%2BsDr9ucOJSkAA6j7ffShjj90TppaFkZJOiNxH4abWnWW6t4kaoHwViMN0UCNLhgFaLNubUY2MYSaiQfEmQwiVZCz%2F52JdFkVZLOqmH5SZmTIGe3bjU1QxGbW%2BKEP9DTVWx6jab1apgP5XuFeaTwaNqwH4IOBd2aCLsjtXm5MfP4hOpHshusTkKENrCpYVzPFBa1ToEFINq29zeB22YQoenXGzKrbwu%2F1ENAvKvuVTu9gL2yeHdiGbXZmZfU2z%2Fs9TixEP3wy9PiAEVHZwEOEcYcQarcg88MJaPSWzIYC2HQPFFhYxn4sNryb0GrjySI%2Byg8BgiqOh9t7hwZktE%2FSB52YC4b6Z6KRWkc%2FJY8DPF8yVNolhc6Ou32dX3u95RbJ1A9Es1MiplanvQ0aNTQpek7d%2BOfBJLzVimUOusS4GFza5vQ25HO0vDCwTsLscJEmDrOIaLAPpNG3DkRztP3DxC7VCUjtgxni97BDDHrgG4c0AqNydVlpfAQCcv4x6w1J2xvyu0C19isf577W0EqowUw9%2FWd1wY6sQEKCmCJWEoMNTus%2FHLEAZ75LFBTisoZHqo6IRnpfx3MkHdes%2Bm9VvBiargIB8NcAoAhO%2FpyQxHy5b%2BwpprQNJ%2B9Vf5ZqpPq2OEP0mCT4tFij%2BbkWZN5kYH8HnPfYvtpFgcHiBkXtbvtJqz4eQgcnaWpQw2y5Qld2ny91lb0%2FaygD8AVGwgdNrQt4D3fWYjUMBYMdl1cOQhZjhrWoQgrFIigJNTchi4avPH2Gy0MAm1DTI8%3D&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47UXFX7YBOL%2F20261101%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20261101T180724Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=9c3821088b58f033adae56edd3e1748072c4b1e0ce2beef6e73226dbbd99e2ef\" 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=IQoJb3JpZ2luX2VjEKL%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJHMEUCIGgGN7l2xQl4djSuAXm1AP9ecyp9%2Fb9BxElonCOLtr3PAiEAkoRVEIPOAiaJ65W7ij8mZfmO5DJFQoDBIiqlVWUlvwgquAUIaxAFGgwyNzM1NzAxOTU0MzMiDJOycTfWjy7huf8TDCqVBS03uVTrIjjzR%2B0npalSsMfk%2FUypHQ1gg0lg7mhNqA1Ojm5K0KlbzLs%2BmHjknctR6RQMtvqDRFwKioMWQVlRUac0ybFax1bHM28EDMooBoqczRf4YHilK9rZJHLk0E77eBliuy2KwS8gy6nMFFQAaMjPMPyIM7MDLHyP9aiPBCIBSBw3HodAQiRepf%2FXqLrBe%2BzHVv2Aa2jeNuiTyj37kiYx%2F1ZnO6MsdQS6ZrTve1VnUJAJUAK8HKadJS9iZI8Y6RLpN%2Bemmi6e9AuF6J4DhwdQR1IiKYJNp9atkh%2BIxTi4zSIkmyt8Q%2FKpNgrH6%2ByQy4ocvXEVfcjpd2%2Ba2CszJGg%2FBKw8t%2BsDr9ucOJSkAA6j7ffShjj90TppaFkZJOiNxH4abWnWW6t4kaoHwViMN0UCNLhgFaLNubUY2MYSaiQfEmQwiVZCz%2F52JdFkVZLOqmH5SZmTIGe3bjU1QxGbW%2BKEP9DTVWx6jab1apgP5XuFeaTwaNqwH4IOBd2aCLsjtXm5MfP4hOpHshusTkKENrCpYVzPFBa1ToEFINq29zeB22YQoenXGzKrbwu%2F1ENAvKvuVTu9gL2yeHdiGbXZmZfU2z%2Fs9TixEP3wy9PiAEVHZwEOEcYcQarcg88MJaPSWzIYC2HQPFFhYxn4sNryb0GrjySI%2Byg8BgiqOh9t7hwZktE%2FSB52YC4b6Z6KRWkc%2FJY8DPF8yVNolhc6Ou32dX3u95RbJ1A9Es1MiplanvQ0aNTQpek7d%2BOfBJLzVimUOusS4GFza5vQ25HO0vDCwTsLscJEmDrOIaLAPpNG3DkRztP3DxC7VCUjtgxni97BDDHrgG4c0AqNydVlpfAQCcv4x6w1J2xvyu0C19isf577W0EqowUw9%2FWd1wY6sQEKCmCJWEoMNTus%2FHLEAZ75LFBTisoZHqo6IRnpfx3MkHdes%2Bm9VvBiargIB8NcAoAhO%2FpyQxHy5b%2BwpprQNJ%2B9Vf5ZqpPq2OEP0mCT4tFij%2BbkWZN5kYH8HnPfYvtpFgcHiBkXtbvtJqz4eQgcnaWpQw2y5Qld2ny91lb0%2FaygD8AVGwgdNrQt4D3fWYjUMBYMdl1cOQhZjhrWoQgrFIigJNTchi4avPH2Gy0MAm1DTI8%3D&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47UXFX7YBOL%2F20261101%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20261101T180724Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=0f0811d416f47f6835fe8d6f2b23c679cfe2aaf371b2c31e59f79159c9aace82\" 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=IQoJb3JpZ2luX2VjEKL%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJHMEUCIGgGN7l2xQl4djSuAXm1AP9ecyp9%2Fb9BxElonCOLtr3PAiEAkoRVEIPOAiaJ65W7ij8mZfmO5DJFQoDBIiqlVWUlvwgquAUIaxAFGgwyNzM1NzAxOTU0MzMiDJOycTfWjy7huf8TDCqVBS03uVTrIjjzR%2B0npalSsMfk%2FUypHQ1gg0lg7mhNqA1Ojm5K0KlbzLs%2BmHjknctR6RQMtvqDRFwKioMWQVlRUac0ybFax1bHM28EDMooBoqczRf4YHilK9rZJHLk0E77eBliuy2KwS8gy6nMFFQAaMjPMPyIM7MDLHyP9aiPBCIBSBw3HodAQiRepf%2FXqLrBe%2BzHVv2Aa2jeNuiTyj37kiYx%2F1ZnO6MsdQS6ZrTve1VnUJAJUAK8HKadJS9iZI8Y6RLpN%2Bemmi6e9AuF6J4DhwdQR1IiKYJNp9atkh%2BIxTi4zSIkmyt8Q%2FKpNgrH6%2ByQy4ocvXEVfcjpd2%2Ba2CszJGg%2FBKw8t%2BsDr9ucOJSkAA6j7ffShjj90TppaFkZJOiNxH4abWnWW6t4kaoHwViMN0UCNLhgFaLNubUY2MYSaiQfEmQwiVZCz%2F52JdFkVZLOqmH5SZmTIGe3bjU1QxGbW%2BKEP9DTVWx6jab1apgP5XuFeaTwaNqwH4IOBd2aCLsjtXm5MfP4hOpHshusTkKENrCpYVzPFBa1ToEFINq29zeB22YQoenXGzKrbwu%2F1ENAvKvuVTu9gL2yeHdiGbXZmZfU2z%2Fs9TixEP3wy9PiAEVHZwEOEcYcQarcg88MJaPSWzIYC2HQPFFhYxn4sNryb0GrjySI%2Byg8BgiqOh9t7hwZktE%2FSB52YC4b6Z6KRWkc%2FJY8DPF8yVNolhc6Ou32dX3u95RbJ1A9Es1MiplanvQ0aNTQpek7d%2BOfBJLzVimUOusS4GFza5vQ25HO0vDCwTsLscJEmDrOIaLAPpNG3DkRztP3DxC7VCUjtgxni97BDDHrgG4c0AqNydVlpfAQCcv4x6w1J2xvyu0C19isf577W0EqowUw9%2FWd1wY6sQEKCmCJWEoMNTus%2FHLEAZ75LFBTisoZHqo6IRnpfx3MkHdes%2Bm9VvBiargIB8NcAoAhO%2FpyQxHy5b%2BwpprQNJ%2B9Vf5ZqpPq2OEP0mCT4tFij%2BbkWZN5kYH8HnPfYvtpFgcHiBkXtbvtJqz4eQgcnaWpQw2y5Qld2ny91lb0%2FaygD8AVGwgdNrQt4D3fWYjUMBYMdl1cOQhZjhrWoQgrFIigJNTchi4avPH2Gy0MAm1DTI8%3D&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47UXFX7YBOL%2F20261101%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20261101T180724Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=0f0811d416f47f6835fe8d6f2b23c679cfe2aaf371b2c31e59f79159c9aace82 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=IQoJb3JpZ2luX2VjEKL%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJHMEUCIGgGN7l2xQl4djSuAXm1AP9ecyp9%2Fb9BxElonCOLtr3PAiEAkoRVEIPOAiaJ65W7ij8mZfmO5DJFQoDBIiqlVWUlvwgquAUIaxAFGgwyNzM1NzAxOTU0MzMiDJOycTfWjy7huf8TDCqVBS03uVTrIjjzR%2B0npalSsMfk%2FUypHQ1gg0lg7mhNqA1Ojm5K0KlbzLs%2BmHjknctR6RQMtvqDRFwKioMWQVlRUac0ybFax1bHM28EDMooBoqczRf4YHilK9rZJHLk0E77eBliuy2KwS8gy6nMFFQAaMjPMPyIM7MDLHyP9aiPBCIBSBw3HodAQiRepf%2FXqLrBe%2BzHVv2Aa2jeNuiTyj37kiYx%2F1ZnO6MsdQS6ZrTve1VnUJAJUAK8HKadJS9iZI8Y6RLpN%2Bemmi6e9AuF6J4DhwdQR1IiKYJNp9atkh%2BIxTi4zSIkmyt8Q%2FKpNgrH6%2ByQy4ocvXEVfcjpd2%2Ba2CszJGg%2FBKw8t%2BsDr9ucOJSkAA6j7ffShjj90TppaFkZJOiNxH4abWnWW6t4kaoHwViMN0UCNLhgFaLNubUY2MYSaiQfEmQwiVZCz%2F52JdFkVZLOqmH5SZmTIGe3bjU1QxGbW%2BKEP9DTVWx6jab1apgP5XuFeaTwaNqwH4IOBd2aCLsjtXm5MfP4hOpHshusTkKENrCpYVzPFBa1ToEFINq29zeB22YQoenXGzKrbwu%2F1ENAvKvuVTu9gL2yeHdiGbXZmZfU2z%2Fs9TixEP3wy9PiAEVHZwEOEcYcQarcg88MJaPSWzIYC2HQPFFhYxn4sNryb0GrjySI%2Byg8BgiqOh9t7hwZktE%2FSB52YC4b6Z6KRWkc%2FJY8DPF8yVNolhc6Ou32dX3u95RbJ1A9Es1MiplanvQ0aNTQpek7d%2BOfBJLzVimUOusS4GFza5vQ25HO0vDCwTsLscJEmDrOIaLAPpNG3DkRztP3DxC7VCUjtgxni97BDDHrgG4c0AqNydVlpfAQCcv4x6w1J2xvyu0C19isf577W0EqowUw9%2FWd1wY6sQEKCmCJWEoMNTus%2FHLEAZ75LFBTisoZHqo6IRnpfx3MkHdes%2Bm9VvBiargIB8NcAoAhO%2FpyQxHy5b%2BwpprQNJ%2B9Vf5ZqpPq2OEP0mCT4tFij%2BbkWZN5kYH8HnPfYvtpFgcHiBkXtbvtJqz4eQgcnaWpQw2y5Qld2ny91lb0%2FaygD8AVGwgdNrQt4D3fWYjUMBYMdl1cOQhZjhrWoQgrFIigJNTchi4avPH2Gy0MAm1DTI8%3D&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47UXFX7YBOL%2F20261101%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20261101T180724Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=08679166d3824f9162a3c61569699ed8630bafbac0abf91e0c49b52d06650656 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=IQoJb3JpZ2luX2VjEKL%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJHMEUCIGgGN7l2xQl4djSuAXm1AP9ecyp9%2Fb9BxElonCOLtr3PAiEAkoRVEIPOAiaJ65W7ij8mZfmO5DJFQoDBIiqlVWUlvwgquAUIaxAFGgwyNzM1NzAxOTU0MzMiDJOycTfWjy7huf8TDCqVBS03uVTrIjjzR%2B0npalSsMfk%2FUypHQ1gg0lg7mhNqA1Ojm5K0KlbzLs%2BmHjknctR6RQMtvqDRFwKioMWQVlRUac0ybFax1bHM28EDMooBoqczRf4YHilK9rZJHLk0E77eBliuy2KwS8gy6nMFFQAaMjPMPyIM7MDLHyP9aiPBCIBSBw3HodAQiRepf%2FXqLrBe%2BzHVv2Aa2jeNuiTyj37kiYx%2F1ZnO6MsdQS6ZrTve1VnUJAJUAK8HKadJS9iZI8Y6RLpN%2Bemmi6e9AuF6J4DhwdQR1IiKYJNp9atkh%2BIxTi4zSIkmyt8Q%2FKpNgrH6%2ByQy4ocvXEVfcjpd2%2Ba2CszJGg%2FBKw8t%2BsDr9ucOJSkAA6j7ffShjj90TppaFkZJOiNxH4abWnWW6t4kaoHwViMN0UCNLhgFaLNubUY2MYSaiQfEmQwiVZCz%2F52JdFkVZLOqmH5SZmTIGe3bjU1QxGbW%2BKEP9DTVWx6jab1apgP5XuFeaTwaNqwH4IOBd2aCLsjtXm5MfP4hOpHshusTkKENrCpYVzPFBa1ToEFINq29zeB22YQoenXGzKrbwu%2F1ENAvKvuVTu9gL2yeHdiGbXZmZfU2z%2Fs9TixEP3wy9PiAEVHZwEOEcYcQarcg88MJaPSWzIYC2HQPFFhYxn4sNryb0GrjySI%2Byg8BgiqOh9t7hwZktE%2FSB52YC4b6Z6KRWkc%2FJY8DPF8yVNolhc6Ou32dX3u95RbJ1A9Es1MiplanvQ0aNTQpek7d%2BOfBJLzVimUOusS4GFza5vQ25HO0vDCwTsLscJEmDrOIaLAPpNG3DkRztP3DxC7VCUjtgxni97BDDHrgG4c0AqNydVlpfAQCcv4x6w1J2xvyu0C19isf577W0EqowUw9%2FWd1wY6sQEKCmCJWEoMNTus%2FHLEAZ75LFBTisoZHqo6IRnpfx3MkHdes%2Bm9VvBiargIB8NcAoAhO%2FpyQxHy5b%2BwpprQNJ%2B9Vf5ZqpPq2OEP0mCT4tFij%2BbkWZN5kYH8HnPfYvtpFgcHiBkXtbvtJqz4eQgcnaWpQw2y5Qld2ny91lb0%2FaygD8AVGwgdNrQt4D3fWYjUMBYMdl1cOQhZjhrWoQgrFIigJNTchi4avPH2Gy0MAm1DTI8%3D&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47UXFX7YBOL%2F20261101%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20261101T180724Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=08679166d3824f9162a3c61569699ed8630bafbac0abf91e0c49b52d06650656\" 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=IQoJb3JpZ2luX2VjEKL%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJHMEUCIGgGN7l2xQl4djSuAXm1AP9ecyp9%2Fb9BxElonCOLtr3PAiEAkoRVEIPOAiaJ65W7ij8mZfmO5DJFQoDBIiqlVWUlvwgquAUIaxAFGgwyNzM1NzAxOTU0MzMiDJOycTfWjy7huf8TDCqVBS03uVTrIjjzR%2B0npalSsMfk%2FUypHQ1gg0lg7mhNqA1Ojm5K0KlbzLs%2BmHjknctR6RQMtvqDRFwKioMWQVlRUac0ybFax1bHM28EDMooBoqczRf4YHilK9rZJHLk0E77eBliuy2KwS8gy6nMFFQAaMjPMPyIM7MDLHyP9aiPBCIBSBw3HodAQiRepf%2FXqLrBe%2BzHVv2Aa2jeNuiTyj37kiYx%2F1ZnO6MsdQS6ZrTve1VnUJAJUAK8HKadJS9iZI8Y6RLpN%2Bemmi6e9AuF6J4DhwdQR1IiKYJNp9atkh%2BIxTi4zSIkmyt8Q%2FKpNgrH6%2ByQy4ocvXEVfcjpd2%2Ba2CszJGg%2FBKw8t%2BsDr9ucOJSkAA6j7ffShjj90TppaFkZJOiNxH4abWnWW6t4kaoHwViMN0UCNLhgFaLNubUY2MYSaiQfEmQwiVZCz%2F52JdFkVZLOqmH5SZmTIGe3bjU1QxGbW%2BKEP9DTVWx6jab1apgP5XuFeaTwaNqwH4IOBd2aCLsjtXm5MfP4hOpHshusTkKENrCpYVzPFBa1ToEFINq29zeB22YQoenXGzKrbwu%2F1ENAvKvuVTu9gL2yeHdiGbXZmZfU2z%2Fs9TixEP3wy9PiAEVHZwEOEcYcQarcg88MJaPSWzIYC2HQPFFhYxn4sNryb0GrjySI%2Byg8BgiqOh9t7hwZktE%2FSB52YC4b6Z6KRWkc%2FJY8DPF8yVNolhc6Ou32dX3u95RbJ1A9Es1MiplanvQ0aNTQpek7d%2BOfBJLzVimUOusS4GFza5vQ25HO0vDCwTsLscJEmDrOIaLAPpNG3DkRztP3DxC7VCUjtgxni97BDDHrgG4c0AqNydVlpfAQCcv4x6w1J2xvyu0C19isf577W0EqowUw9%2FWd1wY6sQEKCmCJWEoMNTus%2FHLEAZ75LFBTisoZHqo6IRnpfx3MkHdes%2Bm9VvBiargIB8NcAoAhO%2FpyQxHy5b%2BwpprQNJ%2B9Vf5ZqpPq2OEP0mCT4tFij%2BbkWZN5kYH8HnPfYvtpFgcHiBkXtbvtJqz4eQgcnaWpQw2y5Qld2ny91lb0%2FaygD8AVGwgdNrQt4D3fWYjUMBYMdl1cOQhZjhrWoQgrFIigJNTchi4avPH2Gy0MAm1DTI8%3D&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47UXFX7YBOL%2F20261101%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20261101T180724Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=674077f1f2f77281031521cfeadfeea94efba5d8ee094172498e78b89c996a46\" 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=IQoJb3JpZ2luX2VjEKL%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJHMEUCIGgGN7l2xQl4djSuAXm1AP9ecyp9%2Fb9BxElonCOLtr3PAiEAkoRVEIPOAiaJ65W7ij8mZfmO5DJFQoDBIiqlVWUlvwgquAUIaxAFGgwyNzM1NzAxOTU0MzMiDJOycTfWjy7huf8TDCqVBS03uVTrIjjzR%2B0npalSsMfk%2FUypHQ1gg0lg7mhNqA1Ojm5K0KlbzLs%2BmHjknctR6RQMtvqDRFwKioMWQVlRUac0ybFax1bHM28EDMooBoqczRf4YHilK9rZJHLk0E77eBliuy2KwS8gy6nMFFQAaMjPMPyIM7MDLHyP9aiPBCIBSBw3HodAQiRepf%2FXqLrBe%2BzHVv2Aa2jeNuiTyj37kiYx%2F1ZnO6MsdQS6ZrTve1VnUJAJUAK8HKadJS9iZI8Y6RLpN%2Bemmi6e9AuF6J4DhwdQR1IiKYJNp9atkh%2BIxTi4zSIkmyt8Q%2FKpNgrH6%2ByQy4ocvXEVfcjpd2%2Ba2CszJGg%2FBKw8t%2BsDr9ucOJSkAA6j7ffShjj90TppaFkZJOiNxH4abWnWW6t4kaoHwViMN0UCNLhgFaLNubUY2MYSaiQfEmQwiVZCz%2F52JdFkVZLOqmH5SZmTIGe3bjU1QxGbW%2BKEP9DTVWx6jab1apgP5XuFeaTwaNqwH4IOBd2aCLsjtXm5MfP4hOpHshusTkKENrCpYVzPFBa1ToEFINq29zeB22YQoenXGzKrbwu%2F1ENAvKvuVTu9gL2yeHdiGbXZmZfU2z%2Fs9TixEP3wy9PiAEVHZwEOEcYcQarcg88MJaPSWzIYC2HQPFFhYxn4sNryb0GrjySI%2Byg8BgiqOh9t7hwZktE%2FSB52YC4b6Z6KRWkc%2FJY8DPF8yVNolhc6Ou32dX3u95RbJ1A9Es1MiplanvQ0aNTQpek7d%2BOfBJLzVimUOusS4GFza5vQ25HO0vDCwTsLscJEmDrOIaLAPpNG3DkRztP3DxC7VCUjtgxni97BDDHrgG4c0AqNydVlpfAQCcv4x6w1J2xvyu0C19isf577W0EqowUw9%2FWd1wY6sQEKCmCJWEoMNTus%2FHLEAZ75LFBTisoZHqo6IRnpfx3MkHdes%2Bm9VvBiargIB8NcAoAhO%2FpyQxHy5b%2BwpprQNJ%2B9Vf5ZqpPq2OEP0mCT4tFij%2BbkWZN5kYH8HnPfYvtpFgcHiBkXtbvtJqz4eQgcnaWpQw2y5Qld2ny91lb0%2FaygD8AVGwgdNrQt4D3fWYjUMBYMdl1cOQhZjhrWoQgrFIigJNTchi4avPH2Gy0MAm1DTI8%3D&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47UXFX7YBOL%2F20261101%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20261101T180724Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=674077f1f2f77281031521cfeadfeea94efba5d8ee094172498e78b89c996a46 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=IQoJb3JpZ2luX2VjEKL%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJHMEUCIGgGN7l2xQl4djSuAXm1AP9ecyp9%2Fb9BxElonCOLtr3PAiEAkoRVEIPOAiaJ65W7ij8mZfmO5DJFQoDBIiqlVWUlvwgquAUIaxAFGgwyNzM1NzAxOTU0MzMiDJOycTfWjy7huf8TDCqVBS03uVTrIjjzR%2B0npalSsMfk%2FUypHQ1gg0lg7mhNqA1Ojm5K0KlbzLs%2BmHjknctR6RQMtvqDRFwKioMWQVlRUac0ybFax1bHM28EDMooBoqczRf4YHilK9rZJHLk0E77eBliuy2KwS8gy6nMFFQAaMjPMPyIM7MDLHyP9aiPBCIBSBw3HodAQiRepf%2FXqLrBe%2BzHVv2Aa2jeNuiTyj37kiYx%2F1ZnO6MsdQS6ZrTve1VnUJAJUAK8HKadJS9iZI8Y6RLpN%2Bemmi6e9AuF6J4DhwdQR1IiKYJNp9atkh%2BIxTi4zSIkmyt8Q%2FKpNgrH6%2ByQy4ocvXEVfcjpd2%2Ba2CszJGg%2FBKw8t%2BsDr9ucOJSkAA6j7ffShjj90TppaFkZJOiNxH4abWnWW6t4kaoHwViMN0UCNLhgFaLNubUY2MYSaiQfEmQwiVZCz%2F52JdFkVZLOqmH5SZmTIGe3bjU1QxGbW%2BKEP9DTVWx6jab1apgP5XuFeaTwaNqwH4IOBd2aCLsjtXm5MfP4hOpHshusTkKENrCpYVzPFBa1ToEFINq29zeB22YQoenXGzKrbwu%2F1ENAvKvuVTu9gL2yeHdiGbXZmZfU2z%2Fs9TixEP3wy9PiAEVHZwEOEcYcQarcg88MJaPSWzIYC2HQPFFhYxn4sNryb0GrjySI%2Byg8BgiqOh9t7hwZktE%2FSB52YC4b6Z6KRWkc%2FJY8DPF8yVNolhc6Ou32dX3u95RbJ1A9Es1MiplanvQ0aNTQpek7d%2BOfBJLzVimUOusS4GFza5vQ25HO0vDCwTsLscJEmDrOIaLAPpNG3DkRztP3DxC7VCUjtgxni97BDDHrgG4c0AqNydVlpfAQCcv4x6w1J2xvyu0C19isf577W0EqowUw9%2FWd1wY6sQEKCmCJWEoMNTus%2FHLEAZ75LFBTisoZHqo6IRnpfx3MkHdes%2Bm9VvBiargIB8NcAoAhO%2FpyQxHy5b%2BwpprQNJ%2B9Vf5ZqpPq2OEP0mCT4tFij%2BbkWZN5kYH8HnPfYvtpFgcHiBkXtbvtJqz4eQgcnaWpQw2y5Qld2ny91lb0%2FaygD8AVGwgdNrQt4D3fWYjUMBYMdl1cOQhZjhrWoQgrFIigJNTchi4avPH2Gy0MAm1DTI8%3D&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47UXFX7YBOL%2F20261101%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20261101T180724Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=120cdebaca989e858d4d3f03dd3f7c350169f4fd95803d40cef901c4bb3d4c73 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=IQoJb3JpZ2luX2VjEKL%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJHMEUCIGgGN7l2xQl4djSuAXm1AP9ecyp9%2Fb9BxElonCOLtr3PAiEAkoRVEIPOAiaJ65W7ij8mZfmO5DJFQoDBIiqlVWUlvwgquAUIaxAFGgwyNzM1NzAxOTU0MzMiDJOycTfWjy7huf8TDCqVBS03uVTrIjjzR%2B0npalSsMfk%2FUypHQ1gg0lg7mhNqA1Ojm5K0KlbzLs%2BmHjknctR6RQMtvqDRFwKioMWQVlRUac0ybFax1bHM28EDMooBoqczRf4YHilK9rZJHLk0E77eBliuy2KwS8gy6nMFFQAaMjPMPyIM7MDLHyP9aiPBCIBSBw3HodAQiRepf%2FXqLrBe%2BzHVv2Aa2jeNuiTyj37kiYx%2F1ZnO6MsdQS6ZrTve1VnUJAJUAK8HKadJS9iZI8Y6RLpN%2Bemmi6e9AuF6J4DhwdQR1IiKYJNp9atkh%2BIxTi4zSIkmyt8Q%2FKpNgrH6%2ByQy4ocvXEVfcjpd2%2Ba2CszJGg%2FBKw8t%2BsDr9ucOJSkAA6j7ffShjj90TppaFkZJOiNxH4abWnWW6t4kaoHwViMN0UCNLhgFaLNubUY2MYSaiQfEmQwiVZCz%2F52JdFkVZLOqmH5SZmTIGe3bjU1QxGbW%2BKEP9DTVWx6jab1apgP5XuFeaTwaNqwH4IOBd2aCLsjtXm5MfP4hOpHshusTkKENrCpYVzPFBa1ToEFINq29zeB22YQoenXGzKrbwu%2F1ENAvKvuVTu9gL2yeHdiGbXZmZfU2z%2Fs9TixEP3wy9PiAEVHZwEOEcYcQarcg88MJaPSWzIYC2HQPFFhYxn4sNryb0GrjySI%2Byg8BgiqOh9t7hwZktE%2FSB52YC4b6Z6KRWkc%2FJY8DPF8yVNolhc6Ou32dX3u95RbJ1A9Es1MiplanvQ0aNTQpek7d%2BOfBJLzVimUOusS4GFza5vQ25HO0vDCwTsLscJEmDrOIaLAPpNG3DkRztP3DxC7VCUjtgxni97BDDHrgG4c0AqNydVlpfAQCcv4x6w1J2xvyu0C19isf577W0EqowUw9%2FWd1wY6sQEKCmCJWEoMNTus%2FHLEAZ75LFBTisoZHqo6IRnpfx3MkHdes%2Bm9VvBiargIB8NcAoAhO%2FpyQxHy5b%2BwpprQNJ%2B9Vf5ZqpPq2OEP0mCT4tFij%2BbkWZN5kYH8HnPfYvtpFgcHiBkXtbvtJqz4eQgcnaWpQw2y5Qld2ny91lb0%2FaygD8AVGwgdNrQt4D3fWYjUMBYMdl1cOQhZjhrWoQgrFIigJNTchi4avPH2Gy0MAm1DTI8%3D&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47UXFX7YBOL%2F20261101%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20261101T180724Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=120cdebaca989e858d4d3f03dd3f7c350169f4fd95803d40cef901c4bb3d4c73\" 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=IQoJb3JpZ2luX2VjEKL%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJHMEUCIGgGN7l2xQl4djSuAXm1AP9ecyp9%2Fb9BxElonCOLtr3PAiEAkoRVEIPOAiaJ65W7ij8mZfmO5DJFQoDBIiqlVWUlvwgquAUIaxAFGgwyNzM1NzAxOTU0MzMiDJOycTfWjy7huf8TDCqVBS03uVTrIjjzR%2B0npalSsMfk%2FUypHQ1gg0lg7mhNqA1Ojm5K0KlbzLs%2BmHjknctR6RQMtvqDRFwKioMWQVlRUac0ybFax1bHM28EDMooBoqczRf4YHilK9rZJHLk0E77eBliuy2KwS8gy6nMFFQAaMjPMPyIM7MDLHyP9aiPBCIBSBw3HodAQiRepf%2FXqLrBe%2BzHVv2Aa2jeNuiTyj37kiYx%2F1ZnO6MsdQS6ZrTve1VnUJAJUAK8HKadJS9iZI8Y6RLpN%2Bemmi6e9AuF6J4DhwdQR1IiKYJNp9atkh%2BIxTi4zSIkmyt8Q%2FKpNgrH6%2ByQy4ocvXEVfcjpd2%2Ba2CszJGg%2FBKw8t%2BsDr9ucOJSkAA6j7ffShjj90TppaFkZJOiNxH4abWnWW6t4kaoHwViMN0UCNLhgFaLNubUY2MYSaiQfEmQwiVZCz%2F52JdFkVZLOqmH5SZmTIGe3bjU1QxGbW%2BKEP9DTVWx6jab1apgP5XuFeaTwaNqwH4IOBd2aCLsjtXm5MfP4hOpHshusTkKENrCpYVzPFBa1ToEFINq29zeB22YQoenXGzKrbwu%2F1ENAvKvuVTu9gL2yeHdiGbXZmZfU2z%2Fs9TixEP3wy9PiAEVHZwEOEcYcQarcg88MJaPSWzIYC2HQPFFhYxn4sNryb0GrjySI%2Byg8BgiqOh9t7hwZktE%2FSB52YC4b6Z6KRWkc%2FJY8DPF8yVNolhc6Ou32dX3u95RbJ1A9Es1MiplanvQ0aNTQpek7d%2BOfBJLzVimUOusS4GFza5vQ25HO0vDCwTsLscJEmDrOIaLAPpNG3DkRztP3DxC7VCUjtgxni97BDDHrgG4c0AqNydVlpfAQCcv4x6w1J2xvyu0C19isf577W0EqowUw9%2FWd1wY6sQEKCmCJWEoMNTus%2FHLEAZ75LFBTisoZHqo6IRnpfx3MkHdes%2Bm9VvBiargIB8NcAoAhO%2FpyQxHy5b%2BwpprQNJ%2B9Vf5ZqpPq2OEP0mCT4tFij%2BbkWZN5kYH8HnPfYvtpFgcHiBkXtbvtJqz4eQgcnaWpQw2y5Qld2ny91lb0%2FaygD8AVGwgdNrQt4D3fWYjUMBYMdl1cOQhZjhrWoQgrFIigJNTchi4avPH2Gy0MAm1DTI8%3D&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47UXFX7YBOL%2F20261101%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20261101T180724Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=2e5c15e310d1a5a2b5534205fea8c8f3d2b3e4162a16496addf952c39137791f\" 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=IQoJb3JpZ2luX2VjEKL%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJHMEUCIGgGN7l2xQl4djSuAXm1AP9ecyp9%2Fb9BxElonCOLtr3PAiEAkoRVEIPOAiaJ65W7ij8mZfmO5DJFQoDBIiqlVWUlvwgquAUIaxAFGgwyNzM1NzAxOTU0MzMiDJOycTfWjy7huf8TDCqVBS03uVTrIjjzR%2B0npalSsMfk%2FUypHQ1gg0lg7mhNqA1Ojm5K0KlbzLs%2BmHjknctR6RQMtvqDRFwKioMWQVlRUac0ybFax1bHM28EDMooBoqczRf4YHilK9rZJHLk0E77eBliuy2KwS8gy6nMFFQAaMjPMPyIM7MDLHyP9aiPBCIBSBw3HodAQiRepf%2FXqLrBe%2BzHVv2Aa2jeNuiTyj37kiYx%2F1ZnO6MsdQS6ZrTve1VnUJAJUAK8HKadJS9iZI8Y6RLpN%2Bemmi6e9AuF6J4DhwdQR1IiKYJNp9atkh%2BIxTi4zSIkmyt8Q%2FKpNgrH6%2ByQy4ocvXEVfcjpd2%2Ba2CszJGg%2FBKw8t%2BsDr9ucOJSkAA6j7ffShjj90TppaFkZJOiNxH4abWnWW6t4kaoHwViMN0UCNLhgFaLNubUY2MYSaiQfEmQwiVZCz%2F52JdFkVZLOqmH5SZmTIGe3bjU1QxGbW%2BKEP9DTVWx6jab1apgP5XuFeaTwaNqwH4IOBd2aCLsjtXm5MfP4hOpHshusTkKENrCpYVzPFBa1ToEFINq29zeB22YQoenXGzKrbwu%2F1ENAvKvuVTu9gL2yeHdiGbXZmZfU2z%2Fs9TixEP3wy9PiAEVHZwEOEcYcQarcg88MJaPSWzIYC2HQPFFhYxn4sNryb0GrjySI%2Byg8BgiqOh9t7hwZktE%2FSB52YC4b6Z6KRWkc%2FJY8DPF8yVNolhc6Ou32dX3u95RbJ1A9Es1MiplanvQ0aNTQpek7d%2BOfBJLzVimUOusS4GFza5vQ25HO0vDCwTsLscJEmDrOIaLAPpNG3DkRztP3DxC7VCUjtgxni97BDDHrgG4c0AqNydVlpfAQCcv4x6w1J2xvyu0C19isf577W0EqowUw9%2FWd1wY6sQEKCmCJWEoMNTus%2FHLEAZ75LFBTisoZHqo6IRnpfx3MkHdes%2Bm9VvBiargIB8NcAoAhO%2FpyQxHy5b%2BwpprQNJ%2B9Vf5ZqpPq2OEP0mCT4tFij%2BbkWZN5kYH8HnPfYvtpFgcHiBkXtbvtJqz4eQgcnaWpQw2y5Qld2ny91lb0%2FaygD8AVGwgdNrQt4D3fWYjUMBYMdl1cOQhZjhrWoQgrFIigJNTchi4avPH2Gy0MAm1DTI8%3D&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47UXFX7YBOL%2F20261101%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20261101T180724Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=2e5c15e310d1a5a2b5534205fea8c8f3d2b3e4162a16496addf952c39137791f 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=IQoJb3JpZ2luX2VjEKL%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJHMEUCIGgGN7l2xQl4djSuAXm1AP9ecyp9%2Fb9BxElonCOLtr3PAiEAkoRVEIPOAiaJ65W7ij8mZfmO5DJFQoDBIiqlVWUlvwgquAUIaxAFGgwyNzM1NzAxOTU0MzMiDJOycTfWjy7huf8TDCqVBS03uVTrIjjzR%2B0npalSsMfk%2FUypHQ1gg0lg7mhNqA1Ojm5K0KlbzLs%2BmHjknctR6RQMtvqDRFwKioMWQVlRUac0ybFax1bHM28EDMooBoqczRf4YHilK9rZJHLk0E77eBliuy2KwS8gy6nMFFQAaMjPMPyIM7MDLHyP9aiPBCIBSBw3HodAQiRepf%2FXqLrBe%2BzHVv2Aa2jeNuiTyj37kiYx%2F1ZnO6MsdQS6ZrTve1VnUJAJUAK8HKadJS9iZI8Y6RLpN%2Bemmi6e9AuF6J4DhwdQR1IiKYJNp9atkh%2BIxTi4zSIkmyt8Q%2FKpNgrH6%2ByQy4ocvXEVfcjpd2%2Ba2CszJGg%2FBKw8t%2BsDr9ucOJSkAA6j7ffShjj90TppaFkZJOiNxH4abWnWW6t4kaoHwViMN0UCNLhgFaLNubUY2MYSaiQfEmQwiVZCz%2F52JdFkVZLOqmH5SZmTIGe3bjU1QxGbW%2BKEP9DTVWx6jab1apgP5XuFeaTwaNqwH4IOBd2aCLsjtXm5MfP4hOpHshusTkKENrCpYVzPFBa1ToEFINq29zeB22YQoenXGzKrbwu%2F1ENAvKvuVTu9gL2yeHdiGbXZmZfU2z%2Fs9TixEP3wy9PiAEVHZwEOEcYcQarcg88MJaPSWzIYC2HQPFFhYxn4sNryb0GrjySI%2Byg8BgiqOh9t7hwZktE%2FSB52YC4b6Z6KRWkc%2FJY8DPF8yVNolhc6Ou32dX3u95RbJ1A9Es1MiplanvQ0aNTQpek7d%2BOfBJLzVimUOusS4GFza5vQ25HO0vDCwTsLscJEmDrOIaLAPpNG3DkRztP3DxC7VCUjtgxni97BDDHrgG4c0AqNydVlpfAQCcv4x6w1J2xvyu0C19isf577W0EqowUw9%2FWd1wY6sQEKCmCJWEoMNTus%2FHLEAZ75LFBTisoZHqo6IRnpfx3MkHdes%2Bm9VvBiargIB8NcAoAhO%2FpyQxHy5b%2BwpprQNJ%2B9Vf5ZqpPq2OEP0mCT4tFij%2BbkWZN5kYH8HnPfYvtpFgcHiBkXtbvtJqz4eQgcnaWpQw2y5Qld2ny91lb0%2FaygD8AVGwgdNrQt4D3fWYjUMBYMdl1cOQhZjhrWoQgrFIigJNTchi4avPH2Gy0MAm1DTI8%3D&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47UXFX7YBOL%2F20261101%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20261101T180724Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=40ef160964434ff4007abd1a437c9b4eb877fdbaeda78e22b7970ffbe0e161b5 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=IQoJb3JpZ2luX2VjEKL%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJHMEUCIGgGN7l2xQl4djSuAXm1AP9ecyp9%2Fb9BxElonCOLtr3PAiEAkoRVEIPOAiaJ65W7ij8mZfmO5DJFQoDBIiqlVWUlvwgquAUIaxAFGgwyNzM1NzAxOTU0MzMiDJOycTfWjy7huf8TDCqVBS03uVTrIjjzR%2B0npalSsMfk%2FUypHQ1gg0lg7mhNqA1Ojm5K0KlbzLs%2BmHjknctR6RQMtvqDRFwKioMWQVlRUac0ybFax1bHM28EDMooBoqczRf4YHilK9rZJHLk0E77eBliuy2KwS8gy6nMFFQAaMjPMPyIM7MDLHyP9aiPBCIBSBw3HodAQiRepf%2FXqLrBe%2BzHVv2Aa2jeNuiTyj37kiYx%2F1ZnO6MsdQS6ZrTve1VnUJAJUAK8HKadJS9iZI8Y6RLpN%2Bemmi6e9AuF6J4DhwdQR1IiKYJNp9atkh%2BIxTi4zSIkmyt8Q%2FKpNgrH6%2ByQy4ocvXEVfcjpd2%2Ba2CszJGg%2FBKw8t%2BsDr9ucOJSkAA6j7ffShjj90TppaFkZJOiNxH4abWnWW6t4kaoHwViMN0UCNLhgFaLNubUY2MYSaiQfEmQwiVZCz%2F52JdFkVZLOqmH5SZmTIGe3bjU1QxGbW%2BKEP9DTVWx6jab1apgP5XuFeaTwaNqwH4IOBd2aCLsjtXm5MfP4hOpHshusTkKENrCpYVzPFBa1ToEFINq29zeB22YQoenXGzKrbwu%2F1ENAvKvuVTu9gL2yeHdiGbXZmZfU2z%2Fs9TixEP3wy9PiAEVHZwEOEcYcQarcg88MJaPSWzIYC2HQPFFhYxn4sNryb0GrjySI%2Byg8BgiqOh9t7hwZktE%2FSB52YC4b6Z6KRWkc%2FJY8DPF8yVNolhc6Ou32dX3u95RbJ1A9Es1MiplanvQ0aNTQpek7d%2BOfBJLzVimUOusS4GFza5vQ25HO0vDCwTsLscJEmDrOIaLAPpNG3DkRztP3DxC7VCUjtgxni97BDDHrgG4c0AqNydVlpfAQCcv4x6w1J2xvyu0C19isf577W0EqowUw9%2FWd1wY6sQEKCmCJWEoMNTus%2FHLEAZ75LFBTisoZHqo6IRnpfx3MkHdes%2Bm9VvBiargIB8NcAoAhO%2FpyQxHy5b%2BwpprQNJ%2B9Vf5ZqpPq2OEP0mCT4tFij%2BbkWZN5kYH8HnPfYvtpFgcHiBkXtbvtJqz4eQgcnaWpQw2y5Qld2ny91lb0%2FaygD8AVGwgdNrQt4D3fWYjUMBYMdl1cOQhZjhrWoQgrFIigJNTchi4avPH2Gy0MAm1DTI8%3D&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47UXFX7YBOL%2F20261101%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20261101T180724Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=40ef160964434ff4007abd1a437c9b4eb877fdbaeda78e22b7970ffbe0e161b5\" 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=IQoJb3JpZ2luX2VjEKL%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJHMEUCIGgGN7l2xQl4djSuAXm1AP9ecyp9%2Fb9BxElonCOLtr3PAiEAkoRVEIPOAiaJ65W7ij8mZfmO5DJFQoDBIiqlVWUlvwgquAUIaxAFGgwyNzM1NzAxOTU0MzMiDJOycTfWjy7huf8TDCqVBS03uVTrIjjzR%2B0npalSsMfk%2FUypHQ1gg0lg7mhNqA1Ojm5K0KlbzLs%2BmHjknctR6RQMtvqDRFwKioMWQVlRUac0ybFax1bHM28EDMooBoqczRf4YHilK9rZJHLk0E77eBliuy2KwS8gy6nMFFQAaMjPMPyIM7MDLHyP9aiPBCIBSBw3HodAQiRepf%2FXqLrBe%2BzHVv2Aa2jeNuiTyj37kiYx%2F1ZnO6MsdQS6ZrTve1VnUJAJUAK8HKadJS9iZI8Y6RLpN%2Bemmi6e9AuF6J4DhwdQR1IiKYJNp9atkh%2BIxTi4zSIkmyt8Q%2FKpNgrH6%2ByQy4ocvXEVfcjpd2%2Ba2CszJGg%2FBKw8t%2BsDr9ucOJSkAA6j7ffShjj90TppaFkZJOiNxH4abWnWW6t4kaoHwViMN0UCNLhgFaLNubUY2MYSaiQfEmQwiVZCz%2F52JdFkVZLOqmH5SZmTIGe3bjU1QxGbW%2BKEP9DTVWx6jab1apgP5XuFeaTwaNqwH4IOBd2aCLsjtXm5MfP4hOpHshusTkKENrCpYVzPFBa1ToEFINq29zeB22YQoenXGzKrbwu%2F1ENAvKvuVTu9gL2yeHdiGbXZmZfU2z%2Fs9TixEP3wy9PiAEVHZwEOEcYcQarcg88MJaPSWzIYC2HQPFFhYxn4sNryb0GrjySI%2Byg8BgiqOh9t7hwZktE%2FSB52YC4b6Z6KRWkc%2FJY8DPF8yVNolhc6Ou32dX3u95RbJ1A9Es1MiplanvQ0aNTQpek7d%2BOfBJLzVimUOusS4GFza5vQ25HO0vDCwTsLscJEmDrOIaLAPpNG3DkRztP3DxC7VCUjtgxni97BDDHrgG4c0AqNydVlpfAQCcv4x6w1J2xvyu0C19isf577W0EqowUw9%2FWd1wY6sQEKCmCJWEoMNTus%2FHLEAZ75LFBTisoZHqo6IRnpfx3MkHdes%2Bm9VvBiargIB8NcAoAhO%2FpyQxHy5b%2BwpprQNJ%2B9Vf5ZqpPq2OEP0mCT4tFij%2BbkWZN5kYH8HnPfYvtpFgcHiBkXtbvtJqz4eQgcnaWpQw2y5Qld2ny91lb0%2FaygD8AVGwgdNrQt4D3fWYjUMBYMdl1cOQhZjhrWoQgrFIigJNTchi4avPH2Gy0MAm1DTI8%3D&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47UXFX7YBOL%2F20261101%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20261101T180724Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=5d7a57a3abbdb45ed69ed241e5baecee965603de38446dbabb2450a7fb5d39c5\" 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=IQoJb3JpZ2luX2VjEKL%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJHMEUCIGgGN7l2xQl4djSuAXm1AP9ecyp9%2Fb9BxElonCOLtr3PAiEAkoRVEIPOAiaJ65W7ij8mZfmO5DJFQoDBIiqlVWUlvwgquAUIaxAFGgwyNzM1NzAxOTU0MzMiDJOycTfWjy7huf8TDCqVBS03uVTrIjjzR%2B0npalSsMfk%2FUypHQ1gg0lg7mhNqA1Ojm5K0KlbzLs%2BmHjknctR6RQMtvqDRFwKioMWQVlRUac0ybFax1bHM28EDMooBoqczRf4YHilK9rZJHLk0E77eBliuy2KwS8gy6nMFFQAaMjPMPyIM7MDLHyP9aiPBCIBSBw3HodAQiRepf%2FXqLrBe%2BzHVv2Aa2jeNuiTyj37kiYx%2F1ZnO6MsdQS6ZrTve1VnUJAJUAK8HKadJS9iZI8Y6RLpN%2Bemmi6e9AuF6J4DhwdQR1IiKYJNp9atkh%2BIxTi4zSIkmyt8Q%2FKpNgrH6%2ByQy4ocvXEVfcjpd2%2Ba2CszJGg%2FBKw8t%2BsDr9ucOJSkAA6j7ffShjj90TppaFkZJOiNxH4abWnWW6t4kaoHwViMN0UCNLhgFaLNubUY2MYSaiQfEmQwiVZCz%2F52JdFkVZLOqmH5SZmTIGe3bjU1QxGbW%2BKEP9DTVWx6jab1apgP5XuFeaTwaNqwH4IOBd2aCLsjtXm5MfP4hOpHshusTkKENrCpYVzPFBa1ToEFINq29zeB22YQoenXGzKrbwu%2F1ENAvKvuVTu9gL2yeHdiGbXZmZfU2z%2Fs9TixEP3wy9PiAEVHZwEOEcYcQarcg88MJaPSWzIYC2HQPFFhYxn4sNryb0GrjySI%2Byg8BgiqOh9t7hwZktE%2FSB52YC4b6Z6KRWkc%2FJY8DPF8yVNolhc6Ou32dX3u95RbJ1A9Es1MiplanvQ0aNTQpek7d%2BOfBJLzVimUOusS4GFza5vQ25HO0vDCwTsLscJEmDrOIaLAPpNG3DkRztP3DxC7VCUjtgxni97BDDHrgG4c0AqNydVlpfAQCcv4x6w1J2xvyu0C19isf577W0EqowUw9%2FWd1wY6sQEKCmCJWEoMNTus%2FHLEAZ75LFBTisoZHqo6IRnpfx3MkHdes%2Bm9VvBiargIB8NcAoAhO%2FpyQxHy5b%2BwpprQNJ%2B9Vf5ZqpPq2OEP0mCT4tFij%2BbkWZN5kYH8HnPfYvtpFgcHiBkXtbvtJqz4eQgcnaWpQw2y5Qld2ny91lb0%2FaygD8AVGwgdNrQt4D3fWYjUMBYMdl1cOQhZjhrWoQgrFIigJNTchi4avPH2Gy0MAm1DTI8%3D&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47UXFX7YBOL%2F20261101%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20261101T180724Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=5d7a57a3abbdb45ed69ed241e5baecee965603de38446dbabb2450a7fb5d39c5 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=IQoJb3JpZ2luX2VjEKL%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJHMEUCIGgGN7l2xQl4djSuAXm1AP9ecyp9%2Fb9BxElonCOLtr3PAiEAkoRVEIPOAiaJ65W7ij8mZfmO5DJFQoDBIiqlVWUlvwgquAUIaxAFGgwyNzM1NzAxOTU0MzMiDJOycTfWjy7huf8TDCqVBS03uVTrIjjzR%2B0npalSsMfk%2FUypHQ1gg0lg7mhNqA1Ojm5K0KlbzLs%2BmHjknctR6RQMtvqDRFwKioMWQVlRUac0ybFax1bHM28EDMooBoqczRf4YHilK9rZJHLk0E77eBliuy2KwS8gy6nMFFQAaMjPMPyIM7MDLHyP9aiPBCIBSBw3HodAQiRepf%2FXqLrBe%2BzHVv2Aa2jeNuiTyj37kiYx%2F1ZnO6MsdQS6ZrTve1VnUJAJUAK8HKadJS9iZI8Y6RLpN%2Bemmi6e9AuF6J4DhwdQR1IiKYJNp9atkh%2BIxTi4zSIkmyt8Q%2FKpNgrH6%2ByQy4ocvXEVfcjpd2%2Ba2CszJGg%2FBKw8t%2BsDr9ucOJSkAA6j7ffShjj90TppaFkZJOiNxH4abWnWW6t4kaoHwViMN0UCNLhgFaLNubUY2MYSaiQfEmQwiVZCz%2F52JdFkVZLOqmH5SZmTIGe3bjU1QxGbW%2BKEP9DTVWx6jab1apgP5XuFeaTwaNqwH4IOBd2aCLsjtXm5MfP4hOpHshusTkKENrCpYVzPFBa1ToEFINq29zeB22YQoenXGzKrbwu%2F1ENAvKvuVTu9gL2yeHdiGbXZmZfU2z%2Fs9TixEP3wy9PiAEVHZwEOEcYcQarcg88MJaPSWzIYC2HQPFFhYxn4sNryb0GrjySI%2Byg8BgiqOh9t7hwZktE%2FSB52YC4b6Z6KRWkc%2FJY8DPF8yVNolhc6Ou32dX3u95RbJ1A9Es1MiplanvQ0aNTQpek7d%2BOfBJLzVimUOusS4GFza5vQ25HO0vDCwTsLscJEmDrOIaLAPpNG3DkRztP3DxC7VCUjtgxni97BDDHrgG4c0AqNydVlpfAQCcv4x6w1J2xvyu0C19isf577W0EqowUw9%2FWd1wY6sQEKCmCJWEoMNTus%2FHLEAZ75LFBTisoZHqo6IRnpfx3MkHdes%2Bm9VvBiargIB8NcAoAhO%2FpyQxHy5b%2BwpprQNJ%2B9Vf5ZqpPq2OEP0mCT4tFij%2BbkWZN5kYH8HnPfYvtpFgcHiBkXtbvtJqz4eQgcnaWpQw2y5Qld2ny91lb0%2FaygD8AVGwgdNrQt4D3fWYjUMBYMdl1cOQhZjhrWoQgrFIigJNTchi4avPH2Gy0MAm1DTI8%3D&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47UXFX7YBOL%2F20261101%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20261101T180724Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=8561bc9e251551fe02183314197a155432f0181cf644391d554801906058fe05 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=IQoJb3JpZ2luX2VjEKL%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJHMEUCIGgGN7l2xQl4djSuAXm1AP9ecyp9%2Fb9BxElonCOLtr3PAiEAkoRVEIPOAiaJ65W7ij8mZfmO5DJFQoDBIiqlVWUlvwgquAUIaxAFGgwyNzM1NzAxOTU0MzMiDJOycTfWjy7huf8TDCqVBS03uVTrIjjzR%2B0npalSsMfk%2FUypHQ1gg0lg7mhNqA1Ojm5K0KlbzLs%2BmHjknctR6RQMtvqDRFwKioMWQVlRUac0ybFax1bHM28EDMooBoqczRf4YHilK9rZJHLk0E77eBliuy2KwS8gy6nMFFQAaMjPMPyIM7MDLHyP9aiPBCIBSBw3HodAQiRepf%2FXqLrBe%2BzHVv2Aa2jeNuiTyj37kiYx%2F1ZnO6MsdQS6ZrTve1VnUJAJUAK8HKadJS9iZI8Y6RLpN%2Bemmi6e9AuF6J4DhwdQR1IiKYJNp9atkh%2BIxTi4zSIkmyt8Q%2FKpNgrH6%2ByQy4ocvXEVfcjpd2%2Ba2CszJGg%2FBKw8t%2BsDr9ucOJSkAA6j7ffShjj90TppaFkZJOiNxH4abWnWW6t4kaoHwViMN0UCNLhgFaLNubUY2MYSaiQfEmQwiVZCz%2F52JdFkVZLOqmH5SZmTIGe3bjU1QxGbW%2BKEP9DTVWx6jab1apgP5XuFeaTwaNqwH4IOBd2aCLsjtXm5MfP4hOpHshusTkKENrCpYVzPFBa1ToEFINq29zeB22YQoenXGzKrbwu%2F1ENAvKvuVTu9gL2yeHdiGbXZmZfU2z%2Fs9TixEP3wy9PiAEVHZwEOEcYcQarcg88MJaPSWzIYC2HQPFFhYxn4sNryb0GrjySI%2Byg8BgiqOh9t7hwZktE%2FSB52YC4b6Z6KRWkc%2FJY8DPF8yVNolhc6Ou32dX3u95RbJ1A9Es1MiplanvQ0aNTQpek7d%2BOfBJLzVimUOusS4GFza5vQ25HO0vDCwTsLscJEmDrOIaLAPpNG3DkRztP3DxC7VCUjtgxni97BDDHrgG4c0AqNydVlpfAQCcv4x6w1J2xvyu0C19isf577W0EqowUw9%2FWd1wY6sQEKCmCJWEoMNTus%2FHLEAZ75LFBTisoZHqo6IRnpfx3MkHdes%2Bm9VvBiargIB8NcAoAhO%2FpyQxHy5b%2BwpprQNJ%2B9Vf5ZqpPq2OEP0mCT4tFij%2BbkWZN5kYH8HnPfYvtpFgcHiBkXtbvtJqz4eQgcnaWpQw2y5Qld2ny91lb0%2FaygD8AVGwgdNrQt4D3fWYjUMBYMdl1cOQhZjhrWoQgrFIigJNTchi4avPH2Gy0MAm1DTI8%3D&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47UXFX7YBOL%2F20261101%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20261101T180724Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=8561bc9e251551fe02183314197a155432f0181cf644391d554801906058fe05\" 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=IQoJb3JpZ2luX2VjEKL%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJHMEUCIGgGN7l2xQl4djSuAXm1AP9ecyp9%2Fb9BxElonCOLtr3PAiEAkoRVEIPOAiaJ65W7ij8mZfmO5DJFQoDBIiqlVWUlvwgquAUIaxAFGgwyNzM1NzAxOTU0MzMiDJOycTfWjy7huf8TDCqVBS03uVTrIjjzR%2B0npalSsMfk%2FUypHQ1gg0lg7mhNqA1Ojm5K0KlbzLs%2BmHjknctR6RQMtvqDRFwKioMWQVlRUac0ybFax1bHM28EDMooBoqczRf4YHilK9rZJHLk0E77eBliuy2KwS8gy6nMFFQAaMjPMPyIM7MDLHyP9aiPBCIBSBw3HodAQiRepf%2FXqLrBe%2BzHVv2Aa2jeNuiTyj37kiYx%2F1ZnO6MsdQS6ZrTve1VnUJAJUAK8HKadJS9iZI8Y6RLpN%2Bemmi6e9AuF6J4DhwdQR1IiKYJNp9atkh%2BIxTi4zSIkmyt8Q%2FKpNgrH6%2ByQy4ocvXEVfcjpd2%2Ba2CszJGg%2FBKw8t%2BsDr9ucOJSkAA6j7ffShjj90TppaFkZJOiNxH4abWnWW6t4kaoHwViMN0UCNLhgFaLNubUY2MYSaiQfEmQwiVZCz%2F52JdFkVZLOqmH5SZmTIGe3bjU1QxGbW%2BKEP9DTVWx6jab1apgP5XuFeaTwaNqwH4IOBd2aCLsjtXm5MfP4hOpHshusTkKENrCpYVzPFBa1ToEFINq29zeB22YQoenXGzKrbwu%2F1ENAvKvuVTu9gL2yeHdiGbXZmZfU2z%2Fs9TixEP3wy9PiAEVHZwEOEcYcQarcg88MJaPSWzIYC2HQPFFhYxn4sNryb0GrjySI%2Byg8BgiqOh9t7hwZktE%2FSB52YC4b6Z6KRWkc%2FJY8DPF8yVNolhc6Ou32dX3u95RbJ1A9Es1MiplanvQ0aNTQpek7d%2BOfBJLzVimUOusS4GFza5vQ25HO0vDCwTsLscJEmDrOIaLAPpNG3DkRztP3DxC7VCUjtgxni97BDDHrgG4c0AqNydVlpfAQCcv4x6w1J2xvyu0C19isf577W0EqowUw9%2FWd1wY6sQEKCmCJWEoMNTus%2FHLEAZ75LFBTisoZHqo6IRnpfx3MkHdes%2Bm9VvBiargIB8NcAoAhO%2FpyQxHy5b%2BwpprQNJ%2B9Vf5ZqpPq2OEP0mCT4tFij%2BbkWZN5kYH8HnPfYvtpFgcHiBkXtbvtJqz4eQgcnaWpQw2y5Qld2ny91lb0%2FaygD8AVGwgdNrQt4D3fWYjUMBYMdl1cOQhZjhrWoQgrFIigJNTchi4avPH2Gy0MAm1DTI8%3D&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47UXFX7YBOL%2F20261101%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20261101T180724Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=305ffcae3131dd2645c206138f10b1a3e01519536f53d6839f157af8eb3e8771\" 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=IQoJb3JpZ2luX2VjEKL%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJHMEUCIGgGN7l2xQl4djSuAXm1AP9ecyp9%2Fb9BxElonCOLtr3PAiEAkoRVEIPOAiaJ65W7ij8mZfmO5DJFQoDBIiqlVWUlvwgquAUIaxAFGgwyNzM1NzAxOTU0MzMiDJOycTfWjy7huf8TDCqVBS03uVTrIjjzR%2B0npalSsMfk%2FUypHQ1gg0lg7mhNqA1Ojm5K0KlbzLs%2BmHjknctR6RQMtvqDRFwKioMWQVlRUac0ybFax1bHM28EDMooBoqczRf4YHilK9rZJHLk0E77eBliuy2KwS8gy6nMFFQAaMjPMPyIM7MDLHyP9aiPBCIBSBw3HodAQiRepf%2FXqLrBe%2BzHVv2Aa2jeNuiTyj37kiYx%2F1ZnO6MsdQS6ZrTve1VnUJAJUAK8HKadJS9iZI8Y6RLpN%2Bemmi6e9AuF6J4DhwdQR1IiKYJNp9atkh%2BIxTi4zSIkmyt8Q%2FKpNgrH6%2ByQy4ocvXEVfcjpd2%2Ba2CszJGg%2FBKw8t%2BsDr9ucOJSkAA6j7ffShjj90TppaFkZJOiNxH4abWnWW6t4kaoHwViMN0UCNLhgFaLNubUY2MYSaiQfEmQwiVZCz%2F52JdFkVZLOqmH5SZmTIGe3bjU1QxGbW%2BKEP9DTVWx6jab1apgP5XuFeaTwaNqwH4IOBd2aCLsjtXm5MfP4hOpHshusTkKENrCpYVzPFBa1ToEFINq29zeB22YQoenXGzKrbwu%2F1ENAvKvuVTu9gL2yeHdiGbXZmZfU2z%2Fs9TixEP3wy9PiAEVHZwEOEcYcQarcg88MJaPSWzIYC2HQPFFhYxn4sNryb0GrjySI%2Byg8BgiqOh9t7hwZktE%2FSB52YC4b6Z6KRWkc%2FJY8DPF8yVNolhc6Ou32dX3u95RbJ1A9Es1MiplanvQ0aNTQpek7d%2BOfBJLzVimUOusS4GFza5vQ25HO0vDCwTsLscJEmDrOIaLAPpNG3DkRztP3DxC7VCUjtgxni97BDDHrgG4c0AqNydVlpfAQCcv4x6w1J2xvyu0C19isf577W0EqowUw9%2FWd1wY6sQEKCmCJWEoMNTus%2FHLEAZ75LFBTisoZHqo6IRnpfx3MkHdes%2Bm9VvBiargIB8NcAoAhO%2FpyQxHy5b%2BwpprQNJ%2B9Vf5ZqpPq2OEP0mCT4tFij%2BbkWZN5kYH8HnPfYvtpFgcHiBkXtbvtJqz4eQgcnaWpQw2y5Qld2ny91lb0%2FaygD8AVGwgdNrQt4D3fWYjUMBYMdl1cOQhZjhrWoQgrFIigJNTchi4avPH2Gy0MAm1DTI8%3D&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47UXFX7YBOL%2F20261101%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20261101T180724Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=305ffcae3131dd2645c206138f10b1a3e01519536f53d6839f157af8eb3e8771 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=IQoJb3JpZ2luX2VjEKL%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJHMEUCIGgGN7l2xQl4djSuAXm1AP9ecyp9%2Fb9BxElonCOLtr3PAiEAkoRVEIPOAiaJ65W7ij8mZfmO5DJFQoDBIiqlVWUlvwgquAUIaxAFGgwyNzM1NzAxOTU0MzMiDJOycTfWjy7huf8TDCqVBS03uVTrIjjzR%2B0npalSsMfk%2FUypHQ1gg0lg7mhNqA1Ojm5K0KlbzLs%2BmHjknctR6RQMtvqDRFwKioMWQVlRUac0ybFax1bHM28EDMooBoqczRf4YHilK9rZJHLk0E77eBliuy2KwS8gy6nMFFQAaMjPMPyIM7MDLHyP9aiPBCIBSBw3HodAQiRepf%2FXqLrBe%2BzHVv2Aa2jeNuiTyj37kiYx%2F1ZnO6MsdQS6ZrTve1VnUJAJUAK8HKadJS9iZI8Y6RLpN%2Bemmi6e9AuF6J4DhwdQR1IiKYJNp9atkh%2BIxTi4zSIkmyt8Q%2FKpNgrH6%2ByQy4ocvXEVfcjpd2%2Ba2CszJGg%2FBKw8t%2BsDr9ucOJSkAA6j7ffShjj90TppaFkZJOiNxH4abWnWW6t4kaoHwViMN0UCNLhgFaLNubUY2MYSaiQfEmQwiVZCz%2F52JdFkVZLOqmH5SZmTIGe3bjU1QxGbW%2BKEP9DTVWx6jab1apgP5XuFeaTwaNqwH4IOBd2aCLsjtXm5MfP4hOpHshusTkKENrCpYVzPFBa1ToEFINq29zeB22YQoenXGzKrbwu%2F1ENAvKvuVTu9gL2yeHdiGbXZmZfU2z%2Fs9TixEP3wy9PiAEVHZwEOEcYcQarcg88MJaPSWzIYC2HQPFFhYxn4sNryb0GrjySI%2Byg8BgiqOh9t7hwZktE%2FSB52YC4b6Z6KRWkc%2FJY8DPF8yVNolhc6Ou32dX3u95RbJ1A9Es1MiplanvQ0aNTQpek7d%2BOfBJLzVimUOusS4GFza5vQ25HO0vDCwTsLscJEmDrOIaLAPpNG3DkRztP3DxC7VCUjtgxni97BDDHrgG4c0AqNydVlpfAQCcv4x6w1J2xvyu0C19isf577W0EqowUw9%2FWd1wY6sQEKCmCJWEoMNTus%2FHLEAZ75LFBTisoZHqo6IRnpfx3MkHdes%2Bm9VvBiargIB8NcAoAhO%2FpyQxHy5b%2BwpprQNJ%2B9Vf5ZqpPq2OEP0mCT4tFij%2BbkWZN5kYH8HnPfYvtpFgcHiBkXtbvtJqz4eQgcnaWpQw2y5Qld2ny91lb0%2FaygD8AVGwgdNrQt4D3fWYjUMBYMdl1cOQhZjhrWoQgrFIigJNTchi4avPH2Gy0MAm1DTI8%3D&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47UXFX7YBOL%2F20261101%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20261101T180724Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=dc2c948528d426d41ebe45c4b378f83f02ac1396859a2aef0d32268119125ce3 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=IQoJb3JpZ2luX2VjEKL%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJHMEUCIGgGN7l2xQl4djSuAXm1AP9ecyp9%2Fb9BxElonCOLtr3PAiEAkoRVEIPOAiaJ65W7ij8mZfmO5DJFQoDBIiqlVWUlvwgquAUIaxAFGgwyNzM1NzAxOTU0MzMiDJOycTfWjy7huf8TDCqVBS03uVTrIjjzR%2B0npalSsMfk%2FUypHQ1gg0lg7mhNqA1Ojm5K0KlbzLs%2BmHjknctR6RQMtvqDRFwKioMWQVlRUac0ybFax1bHM28EDMooBoqczRf4YHilK9rZJHLk0E77eBliuy2KwS8gy6nMFFQAaMjPMPyIM7MDLHyP9aiPBCIBSBw3HodAQiRepf%2FXqLrBe%2BzHVv2Aa2jeNuiTyj37kiYx%2F1ZnO6MsdQS6ZrTve1VnUJAJUAK8HKadJS9iZI8Y6RLpN%2Bemmi6e9AuF6J4DhwdQR1IiKYJNp9atkh%2BIxTi4zSIkmyt8Q%2FKpNgrH6%2ByQy4ocvXEVfcjpd2%2Ba2CszJGg%2FBKw8t%2BsDr9ucOJSkAA6j7ffShjj90TppaFkZJOiNxH4abWnWW6t4kaoHwViMN0UCNLhgFaLNubUY2MYSaiQfEmQwiVZCz%2F52JdFkVZLOqmH5SZmTIGe3bjU1QxGbW%2BKEP9DTVWx6jab1apgP5XuFeaTwaNqwH4IOBd2aCLsjtXm5MfP4hOpHshusTkKENrCpYVzPFBa1ToEFINq29zeB22YQoenXGzKrbwu%2F1ENAvKvuVTu9gL2yeHdiGbXZmZfU2z%2Fs9TixEP3wy9PiAEVHZwEOEcYcQarcg88MJaPSWzIYC2HQPFFhYxn4sNryb0GrjySI%2Byg8BgiqOh9t7hwZktE%2FSB52YC4b6Z6KRWkc%2FJY8DPF8yVNolhc6Ou32dX3u95RbJ1A9Es1MiplanvQ0aNTQpek7d%2BOfBJLzVimUOusS4GFza5vQ25HO0vDCwTsLscJEmDrOIaLAPpNG3DkRztP3DxC7VCUjtgxni97BDDHrgG4c0AqNydVlpfAQCcv4x6w1J2xvyu0C19isf577W0EqowUw9%2FWd1wY6sQEKCmCJWEoMNTus%2FHLEAZ75LFBTisoZHqo6IRnpfx3MkHdes%2Bm9VvBiargIB8NcAoAhO%2FpyQxHy5b%2BwpprQNJ%2B9Vf5ZqpPq2OEP0mCT4tFij%2BbkWZN5kYH8HnPfYvtpFgcHiBkXtbvtJqz4eQgcnaWpQw2y5Qld2ny91lb0%2FaygD8AVGwgdNrQt4D3fWYjUMBYMdl1cOQhZjhrWoQgrFIigJNTchi4avPH2Gy0MAm1DTI8%3D&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47UXFX7YBOL%2F20261101%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20261101T180724Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=dc2c948528d426d41ebe45c4b378f83f02ac1396859a2aef0d32268119125ce3\" 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=IQoJb3JpZ2luX2VjEKL%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJHMEUCIGgGN7l2xQl4djSuAXm1AP9ecyp9%2Fb9BxElonCOLtr3PAiEAkoRVEIPOAiaJ65W7ij8mZfmO5DJFQoDBIiqlVWUlvwgquAUIaxAFGgwyNzM1NzAxOTU0MzMiDJOycTfWjy7huf8TDCqVBS03uVTrIjjzR%2B0npalSsMfk%2FUypHQ1gg0lg7mhNqA1Ojm5K0KlbzLs%2BmHjknctR6RQMtvqDRFwKioMWQVlRUac0ybFax1bHM28EDMooBoqczRf4YHilK9rZJHLk0E77eBliuy2KwS8gy6nMFFQAaMjPMPyIM7MDLHyP9aiPBCIBSBw3HodAQiRepf%2FXqLrBe%2BzHVv2Aa2jeNuiTyj37kiYx%2F1ZnO6MsdQS6ZrTve1VnUJAJUAK8HKadJS9iZI8Y6RLpN%2Bemmi6e9AuF6J4DhwdQR1IiKYJNp9atkh%2BIxTi4zSIkmyt8Q%2FKpNgrH6%2ByQy4ocvXEVfcjpd2%2Ba2CszJGg%2FBKw8t%2BsDr9ucOJSkAA6j7ffShjj90TppaFkZJOiNxH4abWnWW6t4kaoHwViMN0UCNLhgFaLNubUY2MYSaiQfEmQwiVZCz%2F52JdFkVZLOqmH5SZmTIGe3bjU1QxGbW%2BKEP9DTVWx6jab1apgP5XuFeaTwaNqwH4IOBd2aCLsjtXm5MfP4hOpHshusTkKENrCpYVzPFBa1ToEFINq29zeB22YQoenXGzKrbwu%2F1ENAvKvuVTu9gL2yeHdiGbXZmZfU2z%2Fs9TixEP3wy9PiAEVHZwEOEcYcQarcg88MJaPSWzIYC2HQPFFhYxn4sNryb0GrjySI%2Byg8BgiqOh9t7hwZktE%2FSB52YC4b6Z6KRWkc%2FJY8DPF8yVNolhc6Ou32dX3u95RbJ1A9Es1MiplanvQ0aNTQpek7d%2BOfBJLzVimUOusS4GFza5vQ25HO0vDCwTsLscJEmDrOIaLAPpNG3DkRztP3DxC7VCUjtgxni97BDDHrgG4c0AqNydVlpfAQCcv4x6w1J2xvyu0C19isf577W0EqowUw9%2FWd1wY6sQEKCmCJWEoMNTus%2FHLEAZ75LFBTisoZHqo6IRnpfx3MkHdes%2Bm9VvBiargIB8NcAoAhO%2FpyQxHy5b%2BwpprQNJ%2B9Vf5ZqpPq2OEP0mCT4tFij%2BbkWZN5kYH8HnPfYvtpFgcHiBkXtbvtJqz4eQgcnaWpQw2y5Qld2ny91lb0%2FaygD8AVGwgdNrQt4D3fWYjUMBYMdl1cOQhZjhrWoQgrFIigJNTchi4avPH2Gy0MAm1DTI8%3D&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47UXFX7YBOL%2F20261101%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20261101T180724Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=b75325ebc843f145dffabcde4f44ca830ea507b3c6ec6376287f8318ec6cb5fc\" 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=IQoJb3JpZ2luX2VjEKL%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJHMEUCIGgGN7l2xQl4djSuAXm1AP9ecyp9%2Fb9BxElonCOLtr3PAiEAkoRVEIPOAiaJ65W7ij8mZfmO5DJFQoDBIiqlVWUlvwgquAUIaxAFGgwyNzM1NzAxOTU0MzMiDJOycTfWjy7huf8TDCqVBS03uVTrIjjzR%2B0npalSsMfk%2FUypHQ1gg0lg7mhNqA1Ojm5K0KlbzLs%2BmHjknctR6RQMtvqDRFwKioMWQVlRUac0ybFax1bHM28EDMooBoqczRf4YHilK9rZJHLk0E77eBliuy2KwS8gy6nMFFQAaMjPMPyIM7MDLHyP9aiPBCIBSBw3HodAQiRepf%2FXqLrBe%2BzHVv2Aa2jeNuiTyj37kiYx%2F1ZnO6MsdQS6ZrTve1VnUJAJUAK8HKadJS9iZI8Y6RLpN%2Bemmi6e9AuF6J4DhwdQR1IiKYJNp9atkh%2BIxTi4zSIkmyt8Q%2FKpNgrH6%2ByQy4ocvXEVfcjpd2%2Ba2CszJGg%2FBKw8t%2BsDr9ucOJSkAA6j7ffShjj90TppaFkZJOiNxH4abWnWW6t4kaoHwViMN0UCNLhgFaLNubUY2MYSaiQfEmQwiVZCz%2F52JdFkVZLOqmH5SZmTIGe3bjU1QxGbW%2BKEP9DTVWx6jab1apgP5XuFeaTwaNqwH4IOBd2aCLsjtXm5MfP4hOpHshusTkKENrCpYVzPFBa1ToEFINq29zeB22YQoenXGzKrbwu%2F1ENAvKvuVTu9gL2yeHdiGbXZmZfU2z%2Fs9TixEP3wy9PiAEVHZwEOEcYcQarcg88MJaPSWzIYC2HQPFFhYxn4sNryb0GrjySI%2Byg8BgiqOh9t7hwZktE%2FSB52YC4b6Z6KRWkc%2FJY8DPF8yVNolhc6Ou32dX3u95RbJ1A9Es1MiplanvQ0aNTQpek7d%2BOfBJLzVimUOusS4GFza5vQ25HO0vDCwTsLscJEmDrOIaLAPpNG3DkRztP3DxC7VCUjtgxni97BDDHrgG4c0AqNydVlpfAQCcv4x6w1J2xvyu0C19isf577W0EqowUw9%2FWd1wY6sQEKCmCJWEoMNTus%2FHLEAZ75LFBTisoZHqo6IRnpfx3MkHdes%2Bm9VvBiargIB8NcAoAhO%2FpyQxHy5b%2BwpprQNJ%2B9Vf5ZqpPq2OEP0mCT4tFij%2BbkWZN5kYH8HnPfYvtpFgcHiBkXtbvtJqz4eQgcnaWpQw2y5Qld2ny91lb0%2FaygD8AVGwgdNrQt4D3fWYjUMBYMdl1cOQhZjhrWoQgrFIigJNTchi4avPH2Gy0MAm1DTI8%3D&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47UXFX7YBOL%2F20261101%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20261101T180724Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=b75325ebc843f145dffabcde4f44ca830ea507b3c6ec6376287f8318ec6cb5fc 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=IQoJb3JpZ2luX2VjEKL%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJHMEUCIGgGN7l2xQl4djSuAXm1AP9ecyp9%2Fb9BxElonCOLtr3PAiEAkoRVEIPOAiaJ65W7ij8mZfmO5DJFQoDBIiqlVWUlvwgquAUIaxAFGgwyNzM1NzAxOTU0MzMiDJOycTfWjy7huf8TDCqVBS03uVTrIjjzR%2B0npalSsMfk%2FUypHQ1gg0lg7mhNqA1Ojm5K0KlbzLs%2BmHjknctR6RQMtvqDRFwKioMWQVlRUac0ybFax1bHM28EDMooBoqczRf4YHilK9rZJHLk0E77eBliuy2KwS8gy6nMFFQAaMjPMPyIM7MDLHyP9aiPBCIBSBw3HodAQiRepf%2FXqLrBe%2BzHVv2Aa2jeNuiTyj37kiYx%2F1ZnO6MsdQS6ZrTve1VnUJAJUAK8HKadJS9iZI8Y6RLpN%2Bemmi6e9AuF6J4DhwdQR1IiKYJNp9atkh%2BIxTi4zSIkmyt8Q%2FKpNgrH6%2ByQy4ocvXEVfcjpd2%2Ba2CszJGg%2FBKw8t%2BsDr9ucOJSkAA6j7ffShjj90TppaFkZJOiNxH4abWnWW6t4kaoHwViMN0UCNLhgFaLNubUY2MYSaiQfEmQwiVZCz%2F52JdFkVZLOqmH5SZmTIGe3bjU1QxGbW%2BKEP9DTVWx6jab1apgP5XuFeaTwaNqwH4IOBd2aCLsjtXm5MfP4hOpHshusTkKENrCpYVzPFBa1ToEFINq29zeB22YQoenXGzKrbwu%2F1ENAvKvuVTu9gL2yeHdiGbXZmZfU2z%2Fs9TixEP3wy9PiAEVHZwEOEcYcQarcg88MJaPSWzIYC2HQPFFhYxn4sNryb0GrjySI%2Byg8BgiqOh9t7hwZktE%2FSB52YC4b6Z6KRWkc%2FJY8DPF8yVNolhc6Ou32dX3u95RbJ1A9Es1MiplanvQ0aNTQpek7d%2BOfBJLzVimUOusS4GFza5vQ25HO0vDCwTsLscJEmDrOIaLAPpNG3DkRztP3DxC7VCUjtgxni97BDDHrgG4c0AqNydVlpfAQCcv4x6w1J2xvyu0C19isf577W0EqowUw9%2FWd1wY6sQEKCmCJWEoMNTus%2FHLEAZ75LFBTisoZHqo6IRnpfx3MkHdes%2Bm9VvBiargIB8NcAoAhO%2FpyQxHy5b%2BwpprQNJ%2B9Vf5ZqpPq2OEP0mCT4tFij%2BbkWZN5kYH8HnPfYvtpFgcHiBkXtbvtJqz4eQgcnaWpQw2y5Qld2ny91lb0%2FaygD8AVGwgdNrQt4D3fWYjUMBYMdl1cOQhZjhrWoQgrFIigJNTchi4avPH2Gy0MAm1DTI8%3D&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47UXFX7YBOL%2F20261101%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20261101T180724Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=1d85a81223967b13fe691287161e68c408888f6b7faae73b90215bb09ca117e8 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=IQoJb3JpZ2luX2VjEKL%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJHMEUCIGgGN7l2xQl4djSuAXm1AP9ecyp9%2Fb9BxElonCOLtr3PAiEAkoRVEIPOAiaJ65W7ij8mZfmO5DJFQoDBIiqlVWUlvwgquAUIaxAFGgwyNzM1NzAxOTU0MzMiDJOycTfWjy7huf8TDCqVBS03uVTrIjjzR%2B0npalSsMfk%2FUypHQ1gg0lg7mhNqA1Ojm5K0KlbzLs%2BmHjknctR6RQMtvqDRFwKioMWQVlRUac0ybFax1bHM28EDMooBoqczRf4YHilK9rZJHLk0E77eBliuy2KwS8gy6nMFFQAaMjPMPyIM7MDLHyP9aiPBCIBSBw3HodAQiRepf%2FXqLrBe%2BzHVv2Aa2jeNuiTyj37kiYx%2F1ZnO6MsdQS6ZrTve1VnUJAJUAK8HKadJS9iZI8Y6RLpN%2Bemmi6e9AuF6J4DhwdQR1IiKYJNp9atkh%2BIxTi4zSIkmyt8Q%2FKpNgrH6%2ByQy4ocvXEVfcjpd2%2Ba2CszJGg%2FBKw8t%2BsDr9ucOJSkAA6j7ffShjj90TppaFkZJOiNxH4abWnWW6t4kaoHwViMN0UCNLhgFaLNubUY2MYSaiQfEmQwiVZCz%2F52JdFkVZLOqmH5SZmTIGe3bjU1QxGbW%2BKEP9DTVWx6jab1apgP5XuFeaTwaNqwH4IOBd2aCLsjtXm5MfP4hOpHshusTkKENrCpYVzPFBa1ToEFINq29zeB22YQoenXGzKrbwu%2F1ENAvKvuVTu9gL2yeHdiGbXZmZfU2z%2Fs9TixEP3wy9PiAEVHZwEOEcYcQarcg88MJaPSWzIYC2HQPFFhYxn4sNryb0GrjySI%2Byg8BgiqOh9t7hwZktE%2FSB52YC4b6Z6KRWkc%2FJY8DPF8yVNolhc6Ou32dX3u95RbJ1A9Es1MiplanvQ0aNTQpek7d%2BOfBJLzVimUOusS4GFza5vQ25HO0vDCwTsLscJEmDrOIaLAPpNG3DkRztP3DxC7VCUjtgxni97BDDHrgG4c0AqNydVlpfAQCcv4x6w1J2xvyu0C19isf577W0EqowUw9%2FWd1wY6sQEKCmCJWEoMNTus%2FHLEAZ75LFBTisoZHqo6IRnpfx3MkHdes%2Bm9VvBiargIB8NcAoAhO%2FpyQxHy5b%2BwpprQNJ%2B9Vf5ZqpPq2OEP0mCT4tFij%2BbkWZN5kYH8HnPfYvtpFgcHiBkXtbvtJqz4eQgcnaWpQw2y5Qld2ny91lb0%2FaygD8AVGwgdNrQt4D3fWYjUMBYMdl1cOQhZjhrWoQgrFIigJNTchi4avPH2Gy0MAm1DTI8%3D&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47UXFX7YBOL%2F20261101%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20261101T180724Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=1d85a81223967b13fe691287161e68c408888f6b7faae73b90215bb09ca117e8\" 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}]}}