{"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 loading=\"lazy\" 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=IQoJb3JpZ2luX2VjEIH%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJHMEUCIDmWeDDc8tN9fGsmEf4DB2eLXelDf9kuft3RI3V26bfkAiEAg31gPoriml%2BwwShui1bRN%2F6NrDSba0IB92qY0HXfFXIquAUIShAFGgwyNzM1NzAxOTU0MzMiDAZk7e72KWH3N2Q%2BnSqVBUIi8nJdijaLRUjPXx5LDF8GCXNZWaYVfYzBd0sdcZinuFhYA2cOjsmNhUiRbkLazORXlV4NxzaJoO%2FUd4blamSDY3Lg2OS6Fq9kQWC4Wvxn4WkqTUAl0deRT8borl0RyzoEqTevVtpYo31mqVWjKYGcvlTH8%2BHdlQc2ft7lV4Khr7Vk9ksoXsenDV2uCxCfyo5f5UjLmOYnLhIUFyzdNXafC6S%2FKXtYkQ5LuEmZ1iaiZKStxsRtl3gECkKyR98N0qzpukVdjAvVnerqJVNzOknXbNqccub3cPYu3xKp%2FwRy6ezXSNO3wpvGizTA%2FNufUIfjJDkucXfHQSAj7vSCvzDn%2FoRYAC3PB20e2HRbOepsPUTiesAvH9nFufZG7x4Zsv7udSIFqvuvSu%2FIc4lAghbggqzGUC0Qvyg8Wl%2BYMV4pWUQh5VwIN8DVjE5%2FcLgBsxbW0RZRZ1i55cEAmfjnk%2Bpkv13XgOaMB%2BC5Itr9LhoxpH%2Bmh88k7my4qhF0nqXnvhBYBxyRqiWkad5%2FC8G%2FeYSBce8CEXfUsSApx%2BZYGoWI2OBdr%2BVBqnuoe7PANumuqLkIY2eg80Ca%2BIHLEJHTk8MZ%2FEIlaoQLQMHd%2FlMRCDtmrTp9SiVw0X4hQKBkQYizVkM7QV6xm8xz9Dlroo3yWqZHEm%2FzEbNpER0%2FKBJll87aEp0m0EntzwxVqjETO4HDZaJ5E4%2FlGXoEfG4YsTvBza3bTcbPIa%2F%2FQJp7Ha3fYKN3MjczCaPnuyiK98UmzK5unMpmVS4KQhseNG3xU3VW5d3s2JOnI6GnVBhIQ%2Bzo4LWrORnq1vLpS9vITT5bH9EIAfbV5hiHCW63RVs%2FByZeXrNDLL5ksK1%2FoEoTiKsOCX2nwhAIexMwvdmS0AY6sQGTfVrw4re3FdP56BHwftlJ1ZPwePloAMTV%2Fxg%2FJ%2Bc5yJwMc7ykUhwcwMB%2FQp9Q%2FTTSicwNuwt1Aw7Zo4xzih50anmbUfqN%2BuI9BuRF86rLDJYqA3sDFVVsr%2BQhLsabt3reYRTL%2B3ZU9WMoL20tJaWCj90eC%2FYyjhBz0GFVMJPOz%2Br5mxefuF%2BvhBE31Ps%2Fk4dO1vn2JEmSFB6%2BSScCKREija7EF7HOWmsYphGUmdn5LT4%3D&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47U77DK4D4T%2F20260513%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260513T170053Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=2b6be638d65eb187ac80c59c5a07ba3889b889a659977c45e09e42fdfd3028b1\" 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=IQoJb3JpZ2luX2VjEIH%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJHMEUCIDmWeDDc8tN9fGsmEf4DB2eLXelDf9kuft3RI3V26bfkAiEAg31gPoriml%2BwwShui1bRN%2F6NrDSba0IB92qY0HXfFXIquAUIShAFGgwyNzM1NzAxOTU0MzMiDAZk7e72KWH3N2Q%2BnSqVBUIi8nJdijaLRUjPXx5LDF8GCXNZWaYVfYzBd0sdcZinuFhYA2cOjsmNhUiRbkLazORXlV4NxzaJoO%2FUd4blamSDY3Lg2OS6Fq9kQWC4Wvxn4WkqTUAl0deRT8borl0RyzoEqTevVtpYo31mqVWjKYGcvlTH8%2BHdlQc2ft7lV4Khr7Vk9ksoXsenDV2uCxCfyo5f5UjLmOYnLhIUFyzdNXafC6S%2FKXtYkQ5LuEmZ1iaiZKStxsRtl3gECkKyR98N0qzpukVdjAvVnerqJVNzOknXbNqccub3cPYu3xKp%2FwRy6ezXSNO3wpvGizTA%2FNufUIfjJDkucXfHQSAj7vSCvzDn%2FoRYAC3PB20e2HRbOepsPUTiesAvH9nFufZG7x4Zsv7udSIFqvuvSu%2FIc4lAghbggqzGUC0Qvyg8Wl%2BYMV4pWUQh5VwIN8DVjE5%2FcLgBsxbW0RZRZ1i55cEAmfjnk%2Bpkv13XgOaMB%2BC5Itr9LhoxpH%2Bmh88k7my4qhF0nqXnvhBYBxyRqiWkad5%2FC8G%2FeYSBce8CEXfUsSApx%2BZYGoWI2OBdr%2BVBqnuoe7PANumuqLkIY2eg80Ca%2BIHLEJHTk8MZ%2FEIlaoQLQMHd%2FlMRCDtmrTp9SiVw0X4hQKBkQYizVkM7QV6xm8xz9Dlroo3yWqZHEm%2FzEbNpER0%2FKBJll87aEp0m0EntzwxVqjETO4HDZaJ5E4%2FlGXoEfG4YsTvBza3bTcbPIa%2F%2FQJp7Ha3fYKN3MjczCaPnuyiK98UmzK5unMpmVS4KQhseNG3xU3VW5d3s2JOnI6GnVBhIQ%2Bzo4LWrORnq1vLpS9vITT5bH9EIAfbV5hiHCW63RVs%2FByZeXrNDLL5ksK1%2FoEoTiKsOCX2nwhAIexMwvdmS0AY6sQGTfVrw4re3FdP56BHwftlJ1ZPwePloAMTV%2Fxg%2FJ%2Bc5yJwMc7ykUhwcwMB%2FQp9Q%2FTTSicwNuwt1Aw7Zo4xzih50anmbUfqN%2BuI9BuRF86rLDJYqA3sDFVVsr%2BQhLsabt3reYRTL%2B3ZU9WMoL20tJaWCj90eC%2FYyjhBz0GFVMJPOz%2Br5mxefuF%2BvhBE31Ps%2Fk4dO1vn2JEmSFB6%2BSScCKREija7EF7HOWmsYphGUmdn5LT4%3D&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47U77DK4D4T%2F20260513%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260513T170053Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=2b6be638d65eb187ac80c59c5a07ba3889b889a659977c45e09e42fdfd3028b1 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=IQoJb3JpZ2luX2VjEIH%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJHMEUCIDmWeDDc8tN9fGsmEf4DB2eLXelDf9kuft3RI3V26bfkAiEAg31gPoriml%2BwwShui1bRN%2F6NrDSba0IB92qY0HXfFXIquAUIShAFGgwyNzM1NzAxOTU0MzMiDAZk7e72KWH3N2Q%2BnSqVBUIi8nJdijaLRUjPXx5LDF8GCXNZWaYVfYzBd0sdcZinuFhYA2cOjsmNhUiRbkLazORXlV4NxzaJoO%2FUd4blamSDY3Lg2OS6Fq9kQWC4Wvxn4WkqTUAl0deRT8borl0RyzoEqTevVtpYo31mqVWjKYGcvlTH8%2BHdlQc2ft7lV4Khr7Vk9ksoXsenDV2uCxCfyo5f5UjLmOYnLhIUFyzdNXafC6S%2FKXtYkQ5LuEmZ1iaiZKStxsRtl3gECkKyR98N0qzpukVdjAvVnerqJVNzOknXbNqccub3cPYu3xKp%2FwRy6ezXSNO3wpvGizTA%2FNufUIfjJDkucXfHQSAj7vSCvzDn%2FoRYAC3PB20e2HRbOepsPUTiesAvH9nFufZG7x4Zsv7udSIFqvuvSu%2FIc4lAghbggqzGUC0Qvyg8Wl%2BYMV4pWUQh5VwIN8DVjE5%2FcLgBsxbW0RZRZ1i55cEAmfjnk%2Bpkv13XgOaMB%2BC5Itr9LhoxpH%2Bmh88k7my4qhF0nqXnvhBYBxyRqiWkad5%2FC8G%2FeYSBce8CEXfUsSApx%2BZYGoWI2OBdr%2BVBqnuoe7PANumuqLkIY2eg80Ca%2BIHLEJHTk8MZ%2FEIlaoQLQMHd%2FlMRCDtmrTp9SiVw0X4hQKBkQYizVkM7QV6xm8xz9Dlroo3yWqZHEm%2FzEbNpER0%2FKBJll87aEp0m0EntzwxVqjETO4HDZaJ5E4%2FlGXoEfG4YsTvBza3bTcbPIa%2F%2FQJp7Ha3fYKN3MjczCaPnuyiK98UmzK5unMpmVS4KQhseNG3xU3VW5d3s2JOnI6GnVBhIQ%2Bzo4LWrORnq1vLpS9vITT5bH9EIAfbV5hiHCW63RVs%2FByZeXrNDLL5ksK1%2FoEoTiKsOCX2nwhAIexMwvdmS0AY6sQGTfVrw4re3FdP56BHwftlJ1ZPwePloAMTV%2Fxg%2FJ%2Bc5yJwMc7ykUhwcwMB%2FQp9Q%2FTTSicwNuwt1Aw7Zo4xzih50anmbUfqN%2BuI9BuRF86rLDJYqA3sDFVVsr%2BQhLsabt3reYRTL%2B3ZU9WMoL20tJaWCj90eC%2FYyjhBz0GFVMJPOz%2Br5mxefuF%2BvhBE31Ps%2Fk4dO1vn2JEmSFB6%2BSScCKREija7EF7HOWmsYphGUmdn5LT4%3D&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47U77DK4D4T%2F20260513%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260513T170053Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=c67077c94e6507bcb8347bc6a887331f1da95f83f5a0b757c5eea2566fa50bf0 300w, https:\/\/blogs.glowscotland.org.uk\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2013\/02\/Slide123.png 600w\" sizes=\"auto, (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=IQoJb3JpZ2luX2VjEIH%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJHMEUCIDmWeDDc8tN9fGsmEf4DB2eLXelDf9kuft3RI3V26bfkAiEAg31gPoriml%2BwwShui1bRN%2F6NrDSba0IB92qY0HXfFXIquAUIShAFGgwyNzM1NzAxOTU0MzMiDAZk7e72KWH3N2Q%2BnSqVBUIi8nJdijaLRUjPXx5LDF8GCXNZWaYVfYzBd0sdcZinuFhYA2cOjsmNhUiRbkLazORXlV4NxzaJoO%2FUd4blamSDY3Lg2OS6Fq9kQWC4Wvxn4WkqTUAl0deRT8borl0RyzoEqTevVtpYo31mqVWjKYGcvlTH8%2BHdlQc2ft7lV4Khr7Vk9ksoXsenDV2uCxCfyo5f5UjLmOYnLhIUFyzdNXafC6S%2FKXtYkQ5LuEmZ1iaiZKStxsRtl3gECkKyR98N0qzpukVdjAvVnerqJVNzOknXbNqccub3cPYu3xKp%2FwRy6ezXSNO3wpvGizTA%2FNufUIfjJDkucXfHQSAj7vSCvzDn%2FoRYAC3PB20e2HRbOepsPUTiesAvH9nFufZG7x4Zsv7udSIFqvuvSu%2FIc4lAghbggqzGUC0Qvyg8Wl%2BYMV4pWUQh5VwIN8DVjE5%2FcLgBsxbW0RZRZ1i55cEAmfjnk%2Bpkv13XgOaMB%2BC5Itr9LhoxpH%2Bmh88k7my4qhF0nqXnvhBYBxyRqiWkad5%2FC8G%2FeYSBce8CEXfUsSApx%2BZYGoWI2OBdr%2BVBqnuoe7PANumuqLkIY2eg80Ca%2BIHLEJHTk8MZ%2FEIlaoQLQMHd%2FlMRCDtmrTp9SiVw0X4hQKBkQYizVkM7QV6xm8xz9Dlroo3yWqZHEm%2FzEbNpER0%2FKBJll87aEp0m0EntzwxVqjETO4HDZaJ5E4%2FlGXoEfG4YsTvBza3bTcbPIa%2F%2FQJp7Ha3fYKN3MjczCaPnuyiK98UmzK5unMpmVS4KQhseNG3xU3VW5d3s2JOnI6GnVBhIQ%2Bzo4LWrORnq1vLpS9vITT5bH9EIAfbV5hiHCW63RVs%2FByZeXrNDLL5ksK1%2FoEoTiKsOCX2nwhAIexMwvdmS0AY6sQGTfVrw4re3FdP56BHwftlJ1ZPwePloAMTV%2Fxg%2FJ%2Bc5yJwMc7ykUhwcwMB%2FQp9Q%2FTTSicwNuwt1Aw7Zo4xzih50anmbUfqN%2BuI9BuRF86rLDJYqA3sDFVVsr%2BQhLsabt3reYRTL%2B3ZU9WMoL20tJaWCj90eC%2FYyjhBz0GFVMJPOz%2Br5mxefuF%2BvhBE31Ps%2Fk4dO1vn2JEmSFB6%2BSScCKREija7EF7HOWmsYphGUmdn5LT4%3D&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47U77DK4D4T%2F20260513%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260513T170053Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=c67077c94e6507bcb8347bc6a887331f1da95f83f5a0b757c5eea2566fa50bf0\" 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 loading=\"lazy\" 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=IQoJb3JpZ2luX2VjEIH%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJHMEUCIDmWeDDc8tN9fGsmEf4DB2eLXelDf9kuft3RI3V26bfkAiEAg31gPoriml%2BwwShui1bRN%2F6NrDSba0IB92qY0HXfFXIquAUIShAFGgwyNzM1NzAxOTU0MzMiDAZk7e72KWH3N2Q%2BnSqVBUIi8nJdijaLRUjPXx5LDF8GCXNZWaYVfYzBd0sdcZinuFhYA2cOjsmNhUiRbkLazORXlV4NxzaJoO%2FUd4blamSDY3Lg2OS6Fq9kQWC4Wvxn4WkqTUAl0deRT8borl0RyzoEqTevVtpYo31mqVWjKYGcvlTH8%2BHdlQc2ft7lV4Khr7Vk9ksoXsenDV2uCxCfyo5f5UjLmOYnLhIUFyzdNXafC6S%2FKXtYkQ5LuEmZ1iaiZKStxsRtl3gECkKyR98N0qzpukVdjAvVnerqJVNzOknXbNqccub3cPYu3xKp%2FwRy6ezXSNO3wpvGizTA%2FNufUIfjJDkucXfHQSAj7vSCvzDn%2FoRYAC3PB20e2HRbOepsPUTiesAvH9nFufZG7x4Zsv7udSIFqvuvSu%2FIc4lAghbggqzGUC0Qvyg8Wl%2BYMV4pWUQh5VwIN8DVjE5%2FcLgBsxbW0RZRZ1i55cEAmfjnk%2Bpkv13XgOaMB%2BC5Itr9LhoxpH%2Bmh88k7my4qhF0nqXnvhBYBxyRqiWkad5%2FC8G%2FeYSBce8CEXfUsSApx%2BZYGoWI2OBdr%2BVBqnuoe7PANumuqLkIY2eg80Ca%2BIHLEJHTk8MZ%2FEIlaoQLQMHd%2FlMRCDtmrTp9SiVw0X4hQKBkQYizVkM7QV6xm8xz9Dlroo3yWqZHEm%2FzEbNpER0%2FKBJll87aEp0m0EntzwxVqjETO4HDZaJ5E4%2FlGXoEfG4YsTvBza3bTcbPIa%2F%2FQJp7Ha3fYKN3MjczCaPnuyiK98UmzK5unMpmVS4KQhseNG3xU3VW5d3s2JOnI6GnVBhIQ%2Bzo4LWrORnq1vLpS9vITT5bH9EIAfbV5hiHCW63RVs%2FByZeXrNDLL5ksK1%2FoEoTiKsOCX2nwhAIexMwvdmS0AY6sQGTfVrw4re3FdP56BHwftlJ1ZPwePloAMTV%2Fxg%2FJ%2Bc5yJwMc7ykUhwcwMB%2FQp9Q%2FTTSicwNuwt1Aw7Zo4xzih50anmbUfqN%2BuI9BuRF86rLDJYqA3sDFVVsr%2BQhLsabt3reYRTL%2B3ZU9WMoL20tJaWCj90eC%2FYyjhBz0GFVMJPOz%2Br5mxefuF%2BvhBE31Ps%2Fk4dO1vn2JEmSFB6%2BSScCKREija7EF7HOWmsYphGUmdn5LT4%3D&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47U77DK4D4T%2F20260513%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260513T170053Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=0dc0d5212ef46723c300fb4ae7fc427f8b6bde6a1d8ad1e02636f3f55ceb2dd0\" 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=IQoJb3JpZ2luX2VjEIH%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJHMEUCIDmWeDDc8tN9fGsmEf4DB2eLXelDf9kuft3RI3V26bfkAiEAg31gPoriml%2BwwShui1bRN%2F6NrDSba0IB92qY0HXfFXIquAUIShAFGgwyNzM1NzAxOTU0MzMiDAZk7e72KWH3N2Q%2BnSqVBUIi8nJdijaLRUjPXx5LDF8GCXNZWaYVfYzBd0sdcZinuFhYA2cOjsmNhUiRbkLazORXlV4NxzaJoO%2FUd4blamSDY3Lg2OS6Fq9kQWC4Wvxn4WkqTUAl0deRT8borl0RyzoEqTevVtpYo31mqVWjKYGcvlTH8%2BHdlQc2ft7lV4Khr7Vk9ksoXsenDV2uCxCfyo5f5UjLmOYnLhIUFyzdNXafC6S%2FKXtYkQ5LuEmZ1iaiZKStxsRtl3gECkKyR98N0qzpukVdjAvVnerqJVNzOknXbNqccub3cPYu3xKp%2FwRy6ezXSNO3wpvGizTA%2FNufUIfjJDkucXfHQSAj7vSCvzDn%2FoRYAC3PB20e2HRbOepsPUTiesAvH9nFufZG7x4Zsv7udSIFqvuvSu%2FIc4lAghbggqzGUC0Qvyg8Wl%2BYMV4pWUQh5VwIN8DVjE5%2FcLgBsxbW0RZRZ1i55cEAmfjnk%2Bpkv13XgOaMB%2BC5Itr9LhoxpH%2Bmh88k7my4qhF0nqXnvhBYBxyRqiWkad5%2FC8G%2FeYSBce8CEXfUsSApx%2BZYGoWI2OBdr%2BVBqnuoe7PANumuqLkIY2eg80Ca%2BIHLEJHTk8MZ%2FEIlaoQLQMHd%2FlMRCDtmrTp9SiVw0X4hQKBkQYizVkM7QV6xm8xz9Dlroo3yWqZHEm%2FzEbNpER0%2FKBJll87aEp0m0EntzwxVqjETO4HDZaJ5E4%2FlGXoEfG4YsTvBza3bTcbPIa%2F%2FQJp7Ha3fYKN3MjczCaPnuyiK98UmzK5unMpmVS4KQhseNG3xU3VW5d3s2JOnI6GnVBhIQ%2Bzo4LWrORnq1vLpS9vITT5bH9EIAfbV5hiHCW63RVs%2FByZeXrNDLL5ksK1%2FoEoTiKsOCX2nwhAIexMwvdmS0AY6sQGTfVrw4re3FdP56BHwftlJ1ZPwePloAMTV%2Fxg%2FJ%2Bc5yJwMc7ykUhwcwMB%2FQp9Q%2FTTSicwNuwt1Aw7Zo4xzih50anmbUfqN%2BuI9BuRF86rLDJYqA3sDFVVsr%2BQhLsabt3reYRTL%2B3ZU9WMoL20tJaWCj90eC%2FYyjhBz0GFVMJPOz%2Br5mxefuF%2BvhBE31Ps%2Fk4dO1vn2JEmSFB6%2BSScCKREija7EF7HOWmsYphGUmdn5LT4%3D&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47U77DK4D4T%2F20260513%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260513T170053Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=0dc0d5212ef46723c300fb4ae7fc427f8b6bde6a1d8ad1e02636f3f55ceb2dd0 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=IQoJb3JpZ2luX2VjEIH%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJHMEUCIDmWeDDc8tN9fGsmEf4DB2eLXelDf9kuft3RI3V26bfkAiEAg31gPoriml%2BwwShui1bRN%2F6NrDSba0IB92qY0HXfFXIquAUIShAFGgwyNzM1NzAxOTU0MzMiDAZk7e72KWH3N2Q%2BnSqVBUIi8nJdijaLRUjPXx5LDF8GCXNZWaYVfYzBd0sdcZinuFhYA2cOjsmNhUiRbkLazORXlV4NxzaJoO%2FUd4blamSDY3Lg2OS6Fq9kQWC4Wvxn4WkqTUAl0deRT8borl0RyzoEqTevVtpYo31mqVWjKYGcvlTH8%2BHdlQc2ft7lV4Khr7Vk9ksoXsenDV2uCxCfyo5f5UjLmOYnLhIUFyzdNXafC6S%2FKXtYkQ5LuEmZ1iaiZKStxsRtl3gECkKyR98N0qzpukVdjAvVnerqJVNzOknXbNqccub3cPYu3xKp%2FwRy6ezXSNO3wpvGizTA%2FNufUIfjJDkucXfHQSAj7vSCvzDn%2FoRYAC3PB20e2HRbOepsPUTiesAvH9nFufZG7x4Zsv7udSIFqvuvSu%2FIc4lAghbggqzGUC0Qvyg8Wl%2BYMV4pWUQh5VwIN8DVjE5%2FcLgBsxbW0RZRZ1i55cEAmfjnk%2Bpkv13XgOaMB%2BC5Itr9LhoxpH%2Bmh88k7my4qhF0nqXnvhBYBxyRqiWkad5%2FC8G%2FeYSBce8CEXfUsSApx%2BZYGoWI2OBdr%2BVBqnuoe7PANumuqLkIY2eg80Ca%2BIHLEJHTk8MZ%2FEIlaoQLQMHd%2FlMRCDtmrTp9SiVw0X4hQKBkQYizVkM7QV6xm8xz9Dlroo3yWqZHEm%2FzEbNpER0%2FKBJll87aEp0m0EntzwxVqjETO4HDZaJ5E4%2FlGXoEfG4YsTvBza3bTcbPIa%2F%2FQJp7Ha3fYKN3MjczCaPnuyiK98UmzK5unMpmVS4KQhseNG3xU3VW5d3s2JOnI6GnVBhIQ%2Bzo4LWrORnq1vLpS9vITT5bH9EIAfbV5hiHCW63RVs%2FByZeXrNDLL5ksK1%2FoEoTiKsOCX2nwhAIexMwvdmS0AY6sQGTfVrw4re3FdP56BHwftlJ1ZPwePloAMTV%2Fxg%2FJ%2Bc5yJwMc7ykUhwcwMB%2FQp9Q%2FTTSicwNuwt1Aw7Zo4xzih50anmbUfqN%2BuI9BuRF86rLDJYqA3sDFVVsr%2BQhLsabt3reYRTL%2B3ZU9WMoL20tJaWCj90eC%2FYyjhBz0GFVMJPOz%2Br5mxefuF%2BvhBE31Ps%2Fk4dO1vn2JEmSFB6%2BSScCKREija7EF7HOWmsYphGUmdn5LT4%3D&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47U77DK4D4T%2F20260513%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260513T170053Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=6c2ba1e529328f9ca487884c1554f1e1f7a4dc574cc0ea8f9981eda05779e8f1 300w, https:\/\/blogs.glowscotland.org.uk\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2013\/02\/Slide133.png 600w\" sizes=\"auto, (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=IQoJb3JpZ2luX2VjEIH%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJHMEUCIDmWeDDc8tN9fGsmEf4DB2eLXelDf9kuft3RI3V26bfkAiEAg31gPoriml%2BwwShui1bRN%2F6NrDSba0IB92qY0HXfFXIquAUIShAFGgwyNzM1NzAxOTU0MzMiDAZk7e72KWH3N2Q%2BnSqVBUIi8nJdijaLRUjPXx5LDF8GCXNZWaYVfYzBd0sdcZinuFhYA2cOjsmNhUiRbkLazORXlV4NxzaJoO%2FUd4blamSDY3Lg2OS6Fq9kQWC4Wvxn4WkqTUAl0deRT8borl0RyzoEqTevVtpYo31mqVWjKYGcvlTH8%2BHdlQc2ft7lV4Khr7Vk9ksoXsenDV2uCxCfyo5f5UjLmOYnLhIUFyzdNXafC6S%2FKXtYkQ5LuEmZ1iaiZKStxsRtl3gECkKyR98N0qzpukVdjAvVnerqJVNzOknXbNqccub3cPYu3xKp%2FwRy6ezXSNO3wpvGizTA%2FNufUIfjJDkucXfHQSAj7vSCvzDn%2FoRYAC3PB20e2HRbOepsPUTiesAvH9nFufZG7x4Zsv7udSIFqvuvSu%2FIc4lAghbggqzGUC0Qvyg8Wl%2BYMV4pWUQh5VwIN8DVjE5%2FcLgBsxbW0RZRZ1i55cEAmfjnk%2Bpkv13XgOaMB%2BC5Itr9LhoxpH%2Bmh88k7my4qhF0nqXnvhBYBxyRqiWkad5%2FC8G%2FeYSBce8CEXfUsSApx%2BZYGoWI2OBdr%2BVBqnuoe7PANumuqLkIY2eg80Ca%2BIHLEJHTk8MZ%2FEIlaoQLQMHd%2FlMRCDtmrTp9SiVw0X4hQKBkQYizVkM7QV6xm8xz9Dlroo3yWqZHEm%2FzEbNpER0%2FKBJll87aEp0m0EntzwxVqjETO4HDZaJ5E4%2FlGXoEfG4YsTvBza3bTcbPIa%2F%2FQJp7Ha3fYKN3MjczCaPnuyiK98UmzK5unMpmVS4KQhseNG3xU3VW5d3s2JOnI6GnVBhIQ%2Bzo4LWrORnq1vLpS9vITT5bH9EIAfbV5hiHCW63RVs%2FByZeXrNDLL5ksK1%2FoEoTiKsOCX2nwhAIexMwvdmS0AY6sQGTfVrw4re3FdP56BHwftlJ1ZPwePloAMTV%2Fxg%2FJ%2Bc5yJwMc7ykUhwcwMB%2FQp9Q%2FTTSicwNuwt1Aw7Zo4xzih50anmbUfqN%2BuI9BuRF86rLDJYqA3sDFVVsr%2BQhLsabt3reYRTL%2B3ZU9WMoL20tJaWCj90eC%2FYyjhBz0GFVMJPOz%2Br5mxefuF%2BvhBE31Ps%2Fk4dO1vn2JEmSFB6%2BSScCKREija7EF7HOWmsYphGUmdn5LT4%3D&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47U77DK4D4T%2F20260513%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260513T170053Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=6c2ba1e529328f9ca487884c1554f1e1f7a4dc574cc0ea8f9981eda05779e8f1\" 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 loading=\"lazy\" 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=IQoJb3JpZ2luX2VjEIH%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJHMEUCIDmWeDDc8tN9fGsmEf4DB2eLXelDf9kuft3RI3V26bfkAiEAg31gPoriml%2BwwShui1bRN%2F6NrDSba0IB92qY0HXfFXIquAUIShAFGgwyNzM1NzAxOTU0MzMiDAZk7e72KWH3N2Q%2BnSqVBUIi8nJdijaLRUjPXx5LDF8GCXNZWaYVfYzBd0sdcZinuFhYA2cOjsmNhUiRbkLazORXlV4NxzaJoO%2FUd4blamSDY3Lg2OS6Fq9kQWC4Wvxn4WkqTUAl0deRT8borl0RyzoEqTevVtpYo31mqVWjKYGcvlTH8%2BHdlQc2ft7lV4Khr7Vk9ksoXsenDV2uCxCfyo5f5UjLmOYnLhIUFyzdNXafC6S%2FKXtYkQ5LuEmZ1iaiZKStxsRtl3gECkKyR98N0qzpukVdjAvVnerqJVNzOknXbNqccub3cPYu3xKp%2FwRy6ezXSNO3wpvGizTA%2FNufUIfjJDkucXfHQSAj7vSCvzDn%2FoRYAC3PB20e2HRbOepsPUTiesAvH9nFufZG7x4Zsv7udSIFqvuvSu%2FIc4lAghbggqzGUC0Qvyg8Wl%2BYMV4pWUQh5VwIN8DVjE5%2FcLgBsxbW0RZRZ1i55cEAmfjnk%2Bpkv13XgOaMB%2BC5Itr9LhoxpH%2Bmh88k7my4qhF0nqXnvhBYBxyRqiWkad5%2FC8G%2FeYSBce8CEXfUsSApx%2BZYGoWI2OBdr%2BVBqnuoe7PANumuqLkIY2eg80Ca%2BIHLEJHTk8MZ%2FEIlaoQLQMHd%2FlMRCDtmrTp9SiVw0X4hQKBkQYizVkM7QV6xm8xz9Dlroo3yWqZHEm%2FzEbNpER0%2FKBJll87aEp0m0EntzwxVqjETO4HDZaJ5E4%2FlGXoEfG4YsTvBza3bTcbPIa%2F%2FQJp7Ha3fYKN3MjczCaPnuyiK98UmzK5unMpmVS4KQhseNG3xU3VW5d3s2JOnI6GnVBhIQ%2Bzo4LWrORnq1vLpS9vITT5bH9EIAfbV5hiHCW63RVs%2FByZeXrNDLL5ksK1%2FoEoTiKsOCX2nwhAIexMwvdmS0AY6sQGTfVrw4re3FdP56BHwftlJ1ZPwePloAMTV%2Fxg%2FJ%2Bc5yJwMc7ykUhwcwMB%2FQp9Q%2FTTSicwNuwt1Aw7Zo4xzih50anmbUfqN%2BuI9BuRF86rLDJYqA3sDFVVsr%2BQhLsabt3reYRTL%2B3ZU9WMoL20tJaWCj90eC%2FYyjhBz0GFVMJPOz%2Br5mxefuF%2BvhBE31Ps%2Fk4dO1vn2JEmSFB6%2BSScCKREija7EF7HOWmsYphGUmdn5LT4%3D&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47U77DK4D4T%2F20260513%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260513T170053Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=28a6ee02282f9f91ed355c507bca0fa4e871e3f1f3404fc0c841c8452bccbbf8\" 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=IQoJb3JpZ2luX2VjEIH%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJHMEUCIDmWeDDc8tN9fGsmEf4DB2eLXelDf9kuft3RI3V26bfkAiEAg31gPoriml%2BwwShui1bRN%2F6NrDSba0IB92qY0HXfFXIquAUIShAFGgwyNzM1NzAxOTU0MzMiDAZk7e72KWH3N2Q%2BnSqVBUIi8nJdijaLRUjPXx5LDF8GCXNZWaYVfYzBd0sdcZinuFhYA2cOjsmNhUiRbkLazORXlV4NxzaJoO%2FUd4blamSDY3Lg2OS6Fq9kQWC4Wvxn4WkqTUAl0deRT8borl0RyzoEqTevVtpYo31mqVWjKYGcvlTH8%2BHdlQc2ft7lV4Khr7Vk9ksoXsenDV2uCxCfyo5f5UjLmOYnLhIUFyzdNXafC6S%2FKXtYkQ5LuEmZ1iaiZKStxsRtl3gECkKyR98N0qzpukVdjAvVnerqJVNzOknXbNqccub3cPYu3xKp%2FwRy6ezXSNO3wpvGizTA%2FNufUIfjJDkucXfHQSAj7vSCvzDn%2FoRYAC3PB20e2HRbOepsPUTiesAvH9nFufZG7x4Zsv7udSIFqvuvSu%2FIc4lAghbggqzGUC0Qvyg8Wl%2BYMV4pWUQh5VwIN8DVjE5%2FcLgBsxbW0RZRZ1i55cEAmfjnk%2Bpkv13XgOaMB%2BC5Itr9LhoxpH%2Bmh88k7my4qhF0nqXnvhBYBxyRqiWkad5%2FC8G%2FeYSBce8CEXfUsSApx%2BZYGoWI2OBdr%2BVBqnuoe7PANumuqLkIY2eg80Ca%2BIHLEJHTk8MZ%2FEIlaoQLQMHd%2FlMRCDtmrTp9SiVw0X4hQKBkQYizVkM7QV6xm8xz9Dlroo3yWqZHEm%2FzEbNpER0%2FKBJll87aEp0m0EntzwxVqjETO4HDZaJ5E4%2FlGXoEfG4YsTvBza3bTcbPIa%2F%2FQJp7Ha3fYKN3MjczCaPnuyiK98UmzK5unMpmVS4KQhseNG3xU3VW5d3s2JOnI6GnVBhIQ%2Bzo4LWrORnq1vLpS9vITT5bH9EIAfbV5hiHCW63RVs%2FByZeXrNDLL5ksK1%2FoEoTiKsOCX2nwhAIexMwvdmS0AY6sQGTfVrw4re3FdP56BHwftlJ1ZPwePloAMTV%2Fxg%2FJ%2Bc5yJwMc7ykUhwcwMB%2FQp9Q%2FTTSicwNuwt1Aw7Zo4xzih50anmbUfqN%2BuI9BuRF86rLDJYqA3sDFVVsr%2BQhLsabt3reYRTL%2B3ZU9WMoL20tJaWCj90eC%2FYyjhBz0GFVMJPOz%2Br5mxefuF%2BvhBE31Ps%2Fk4dO1vn2JEmSFB6%2BSScCKREija7EF7HOWmsYphGUmdn5LT4%3D&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47U77DK4D4T%2F20260513%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260513T170053Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=28a6ee02282f9f91ed355c507bca0fa4e871e3f1f3404fc0c841c8452bccbbf8 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=IQoJb3JpZ2luX2VjEIH%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJHMEUCIDmWeDDc8tN9fGsmEf4DB2eLXelDf9kuft3RI3V26bfkAiEAg31gPoriml%2BwwShui1bRN%2F6NrDSba0IB92qY0HXfFXIquAUIShAFGgwyNzM1NzAxOTU0MzMiDAZk7e72KWH3N2Q%2BnSqVBUIi8nJdijaLRUjPXx5LDF8GCXNZWaYVfYzBd0sdcZinuFhYA2cOjsmNhUiRbkLazORXlV4NxzaJoO%2FUd4blamSDY3Lg2OS6Fq9kQWC4Wvxn4WkqTUAl0deRT8borl0RyzoEqTevVtpYo31mqVWjKYGcvlTH8%2BHdlQc2ft7lV4Khr7Vk9ksoXsenDV2uCxCfyo5f5UjLmOYnLhIUFyzdNXafC6S%2FKXtYkQ5LuEmZ1iaiZKStxsRtl3gECkKyR98N0qzpukVdjAvVnerqJVNzOknXbNqccub3cPYu3xKp%2FwRy6ezXSNO3wpvGizTA%2FNufUIfjJDkucXfHQSAj7vSCvzDn%2FoRYAC3PB20e2HRbOepsPUTiesAvH9nFufZG7x4Zsv7udSIFqvuvSu%2FIc4lAghbggqzGUC0Qvyg8Wl%2BYMV4pWUQh5VwIN8DVjE5%2FcLgBsxbW0RZRZ1i55cEAmfjnk%2Bpkv13XgOaMB%2BC5Itr9LhoxpH%2Bmh88k7my4qhF0nqXnvhBYBxyRqiWkad5%2FC8G%2FeYSBce8CEXfUsSApx%2BZYGoWI2OBdr%2BVBqnuoe7PANumuqLkIY2eg80Ca%2BIHLEJHTk8MZ%2FEIlaoQLQMHd%2FlMRCDtmrTp9SiVw0X4hQKBkQYizVkM7QV6xm8xz9Dlroo3yWqZHEm%2FzEbNpER0%2FKBJll87aEp0m0EntzwxVqjETO4HDZaJ5E4%2FlGXoEfG4YsTvBza3bTcbPIa%2F%2FQJp7Ha3fYKN3MjczCaPnuyiK98UmzK5unMpmVS4KQhseNG3xU3VW5d3s2JOnI6GnVBhIQ%2Bzo4LWrORnq1vLpS9vITT5bH9EIAfbV5hiHCW63RVs%2FByZeXrNDLL5ksK1%2FoEoTiKsOCX2nwhAIexMwvdmS0AY6sQGTfVrw4re3FdP56BHwftlJ1ZPwePloAMTV%2Fxg%2FJ%2Bc5yJwMc7ykUhwcwMB%2FQp9Q%2FTTSicwNuwt1Aw7Zo4xzih50anmbUfqN%2BuI9BuRF86rLDJYqA3sDFVVsr%2BQhLsabt3reYRTL%2B3ZU9WMoL20tJaWCj90eC%2FYyjhBz0GFVMJPOz%2Br5mxefuF%2BvhBE31Ps%2Fk4dO1vn2JEmSFB6%2BSScCKREija7EF7HOWmsYphGUmdn5LT4%3D&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47U77DK4D4T%2F20260513%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260513T170053Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=af2507353d23ebd6cb163ea510b1360fc162839119d9400dc2b800edcbf0410a 300w, https:\/\/blogs.glowscotland.org.uk\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2013\/02\/Slide143.png 600w\" sizes=\"auto, (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=IQoJb3JpZ2luX2VjEIH%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJHMEUCIDmWeDDc8tN9fGsmEf4DB2eLXelDf9kuft3RI3V26bfkAiEAg31gPoriml%2BwwShui1bRN%2F6NrDSba0IB92qY0HXfFXIquAUIShAFGgwyNzM1NzAxOTU0MzMiDAZk7e72KWH3N2Q%2BnSqVBUIi8nJdijaLRUjPXx5LDF8GCXNZWaYVfYzBd0sdcZinuFhYA2cOjsmNhUiRbkLazORXlV4NxzaJoO%2FUd4blamSDY3Lg2OS6Fq9kQWC4Wvxn4WkqTUAl0deRT8borl0RyzoEqTevVtpYo31mqVWjKYGcvlTH8%2BHdlQc2ft7lV4Khr7Vk9ksoXsenDV2uCxCfyo5f5UjLmOYnLhIUFyzdNXafC6S%2FKXtYkQ5LuEmZ1iaiZKStxsRtl3gECkKyR98N0qzpukVdjAvVnerqJVNzOknXbNqccub3cPYu3xKp%2FwRy6ezXSNO3wpvGizTA%2FNufUIfjJDkucXfHQSAj7vSCvzDn%2FoRYAC3PB20e2HRbOepsPUTiesAvH9nFufZG7x4Zsv7udSIFqvuvSu%2FIc4lAghbggqzGUC0Qvyg8Wl%2BYMV4pWUQh5VwIN8DVjE5%2FcLgBsxbW0RZRZ1i55cEAmfjnk%2Bpkv13XgOaMB%2BC5Itr9LhoxpH%2Bmh88k7my4qhF0nqXnvhBYBxyRqiWkad5%2FC8G%2FeYSBce8CEXfUsSApx%2BZYGoWI2OBdr%2BVBqnuoe7PANumuqLkIY2eg80Ca%2BIHLEJHTk8MZ%2FEIlaoQLQMHd%2FlMRCDtmrTp9SiVw0X4hQKBkQYizVkM7QV6xm8xz9Dlroo3yWqZHEm%2FzEbNpER0%2FKBJll87aEp0m0EntzwxVqjETO4HDZaJ5E4%2FlGXoEfG4YsTvBza3bTcbPIa%2F%2FQJp7Ha3fYKN3MjczCaPnuyiK98UmzK5unMpmVS4KQhseNG3xU3VW5d3s2JOnI6GnVBhIQ%2Bzo4LWrORnq1vLpS9vITT5bH9EIAfbV5hiHCW63RVs%2FByZeXrNDLL5ksK1%2FoEoTiKsOCX2nwhAIexMwvdmS0AY6sQGTfVrw4re3FdP56BHwftlJ1ZPwePloAMTV%2Fxg%2FJ%2Bc5yJwMc7ykUhwcwMB%2FQp9Q%2FTTSicwNuwt1Aw7Zo4xzih50anmbUfqN%2BuI9BuRF86rLDJYqA3sDFVVsr%2BQhLsabt3reYRTL%2B3ZU9WMoL20tJaWCj90eC%2FYyjhBz0GFVMJPOz%2Br5mxefuF%2BvhBE31Ps%2Fk4dO1vn2JEmSFB6%2BSScCKREija7EF7HOWmsYphGUmdn5LT4%3D&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47U77DK4D4T%2F20260513%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260513T170053Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=af2507353d23ebd6cb163ea510b1360fc162839119d9400dc2b800edcbf0410a\" 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 loading=\"lazy\" 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=IQoJb3JpZ2luX2VjEIH%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJHMEUCIDmWeDDc8tN9fGsmEf4DB2eLXelDf9kuft3RI3V26bfkAiEAg31gPoriml%2BwwShui1bRN%2F6NrDSba0IB92qY0HXfFXIquAUIShAFGgwyNzM1NzAxOTU0MzMiDAZk7e72KWH3N2Q%2BnSqVBUIi8nJdijaLRUjPXx5LDF8GCXNZWaYVfYzBd0sdcZinuFhYA2cOjsmNhUiRbkLazORXlV4NxzaJoO%2FUd4blamSDY3Lg2OS6Fq9kQWC4Wvxn4WkqTUAl0deRT8borl0RyzoEqTevVtpYo31mqVWjKYGcvlTH8%2BHdlQc2ft7lV4Khr7Vk9ksoXsenDV2uCxCfyo5f5UjLmOYnLhIUFyzdNXafC6S%2FKXtYkQ5LuEmZ1iaiZKStxsRtl3gECkKyR98N0qzpukVdjAvVnerqJVNzOknXbNqccub3cPYu3xKp%2FwRy6ezXSNO3wpvGizTA%2FNufUIfjJDkucXfHQSAj7vSCvzDn%2FoRYAC3PB20e2HRbOepsPUTiesAvH9nFufZG7x4Zsv7udSIFqvuvSu%2FIc4lAghbggqzGUC0Qvyg8Wl%2BYMV4pWUQh5VwIN8DVjE5%2FcLgBsxbW0RZRZ1i55cEAmfjnk%2Bpkv13XgOaMB%2BC5Itr9LhoxpH%2Bmh88k7my4qhF0nqXnvhBYBxyRqiWkad5%2FC8G%2FeYSBce8CEXfUsSApx%2BZYGoWI2OBdr%2BVBqnuoe7PANumuqLkIY2eg80Ca%2BIHLEJHTk8MZ%2FEIlaoQLQMHd%2FlMRCDtmrTp9SiVw0X4hQKBkQYizVkM7QV6xm8xz9Dlroo3yWqZHEm%2FzEbNpER0%2FKBJll87aEp0m0EntzwxVqjETO4HDZaJ5E4%2FlGXoEfG4YsTvBza3bTcbPIa%2F%2FQJp7Ha3fYKN3MjczCaPnuyiK98UmzK5unMpmVS4KQhseNG3xU3VW5d3s2JOnI6GnVBhIQ%2Bzo4LWrORnq1vLpS9vITT5bH9EIAfbV5hiHCW63RVs%2FByZeXrNDLL5ksK1%2FoEoTiKsOCX2nwhAIexMwvdmS0AY6sQGTfVrw4re3FdP56BHwftlJ1ZPwePloAMTV%2Fxg%2FJ%2Bc5yJwMc7ykUhwcwMB%2FQp9Q%2FTTSicwNuwt1Aw7Zo4xzih50anmbUfqN%2BuI9BuRF86rLDJYqA3sDFVVsr%2BQhLsabt3reYRTL%2B3ZU9WMoL20tJaWCj90eC%2FYyjhBz0GFVMJPOz%2Br5mxefuF%2BvhBE31Ps%2Fk4dO1vn2JEmSFB6%2BSScCKREija7EF7HOWmsYphGUmdn5LT4%3D&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47U77DK4D4T%2F20260513%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260513T170053Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=f5d63f410ce92cebe91a8ccef725edb139ecd2a208f7a2b1b3d0ae5e578be788\" 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=IQoJb3JpZ2luX2VjEIH%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJHMEUCIDmWeDDc8tN9fGsmEf4DB2eLXelDf9kuft3RI3V26bfkAiEAg31gPoriml%2BwwShui1bRN%2F6NrDSba0IB92qY0HXfFXIquAUIShAFGgwyNzM1NzAxOTU0MzMiDAZk7e72KWH3N2Q%2BnSqVBUIi8nJdijaLRUjPXx5LDF8GCXNZWaYVfYzBd0sdcZinuFhYA2cOjsmNhUiRbkLazORXlV4NxzaJoO%2FUd4blamSDY3Lg2OS6Fq9kQWC4Wvxn4WkqTUAl0deRT8borl0RyzoEqTevVtpYo31mqVWjKYGcvlTH8%2BHdlQc2ft7lV4Khr7Vk9ksoXsenDV2uCxCfyo5f5UjLmOYnLhIUFyzdNXafC6S%2FKXtYkQ5LuEmZ1iaiZKStxsRtl3gECkKyR98N0qzpukVdjAvVnerqJVNzOknXbNqccub3cPYu3xKp%2FwRy6ezXSNO3wpvGizTA%2FNufUIfjJDkucXfHQSAj7vSCvzDn%2FoRYAC3PB20e2HRbOepsPUTiesAvH9nFufZG7x4Zsv7udSIFqvuvSu%2FIc4lAghbggqzGUC0Qvyg8Wl%2BYMV4pWUQh5VwIN8DVjE5%2FcLgBsxbW0RZRZ1i55cEAmfjnk%2Bpkv13XgOaMB%2BC5Itr9LhoxpH%2Bmh88k7my4qhF0nqXnvhBYBxyRqiWkad5%2FC8G%2FeYSBce8CEXfUsSApx%2BZYGoWI2OBdr%2BVBqnuoe7PANumuqLkIY2eg80Ca%2BIHLEJHTk8MZ%2FEIlaoQLQMHd%2FlMRCDtmrTp9SiVw0X4hQKBkQYizVkM7QV6xm8xz9Dlroo3yWqZHEm%2FzEbNpER0%2FKBJll87aEp0m0EntzwxVqjETO4HDZaJ5E4%2FlGXoEfG4YsTvBza3bTcbPIa%2F%2FQJp7Ha3fYKN3MjczCaPnuyiK98UmzK5unMpmVS4KQhseNG3xU3VW5d3s2JOnI6GnVBhIQ%2Bzo4LWrORnq1vLpS9vITT5bH9EIAfbV5hiHCW63RVs%2FByZeXrNDLL5ksK1%2FoEoTiKsOCX2nwhAIexMwvdmS0AY6sQGTfVrw4re3FdP56BHwftlJ1ZPwePloAMTV%2Fxg%2FJ%2Bc5yJwMc7ykUhwcwMB%2FQp9Q%2FTTSicwNuwt1Aw7Zo4xzih50anmbUfqN%2BuI9BuRF86rLDJYqA3sDFVVsr%2BQhLsabt3reYRTL%2B3ZU9WMoL20tJaWCj90eC%2FYyjhBz0GFVMJPOz%2Br5mxefuF%2BvhBE31Ps%2Fk4dO1vn2JEmSFB6%2BSScCKREija7EF7HOWmsYphGUmdn5LT4%3D&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47U77DK4D4T%2F20260513%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260513T170053Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=f5d63f410ce92cebe91a8ccef725edb139ecd2a208f7a2b1b3d0ae5e578be788 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=IQoJb3JpZ2luX2VjEIH%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJHMEUCIDmWeDDc8tN9fGsmEf4DB2eLXelDf9kuft3RI3V26bfkAiEAg31gPoriml%2BwwShui1bRN%2F6NrDSba0IB92qY0HXfFXIquAUIShAFGgwyNzM1NzAxOTU0MzMiDAZk7e72KWH3N2Q%2BnSqVBUIi8nJdijaLRUjPXx5LDF8GCXNZWaYVfYzBd0sdcZinuFhYA2cOjsmNhUiRbkLazORXlV4NxzaJoO%2FUd4blamSDY3Lg2OS6Fq9kQWC4Wvxn4WkqTUAl0deRT8borl0RyzoEqTevVtpYo31mqVWjKYGcvlTH8%2BHdlQc2ft7lV4Khr7Vk9ksoXsenDV2uCxCfyo5f5UjLmOYnLhIUFyzdNXafC6S%2FKXtYkQ5LuEmZ1iaiZKStxsRtl3gECkKyR98N0qzpukVdjAvVnerqJVNzOknXbNqccub3cPYu3xKp%2FwRy6ezXSNO3wpvGizTA%2FNufUIfjJDkucXfHQSAj7vSCvzDn%2FoRYAC3PB20e2HRbOepsPUTiesAvH9nFufZG7x4Zsv7udSIFqvuvSu%2FIc4lAghbggqzGUC0Qvyg8Wl%2BYMV4pWUQh5VwIN8DVjE5%2FcLgBsxbW0RZRZ1i55cEAmfjnk%2Bpkv13XgOaMB%2BC5Itr9LhoxpH%2Bmh88k7my4qhF0nqXnvhBYBxyRqiWkad5%2FC8G%2FeYSBce8CEXfUsSApx%2BZYGoWI2OBdr%2BVBqnuoe7PANumuqLkIY2eg80Ca%2BIHLEJHTk8MZ%2FEIlaoQLQMHd%2FlMRCDtmrTp9SiVw0X4hQKBkQYizVkM7QV6xm8xz9Dlroo3yWqZHEm%2FzEbNpER0%2FKBJll87aEp0m0EntzwxVqjETO4HDZaJ5E4%2FlGXoEfG4YsTvBza3bTcbPIa%2F%2FQJp7Ha3fYKN3MjczCaPnuyiK98UmzK5unMpmVS4KQhseNG3xU3VW5d3s2JOnI6GnVBhIQ%2Bzo4LWrORnq1vLpS9vITT5bH9EIAfbV5hiHCW63RVs%2FByZeXrNDLL5ksK1%2FoEoTiKsOCX2nwhAIexMwvdmS0AY6sQGTfVrw4re3FdP56BHwftlJ1ZPwePloAMTV%2Fxg%2FJ%2Bc5yJwMc7ykUhwcwMB%2FQp9Q%2FTTSicwNuwt1Aw7Zo4xzih50anmbUfqN%2BuI9BuRF86rLDJYqA3sDFVVsr%2BQhLsabt3reYRTL%2B3ZU9WMoL20tJaWCj90eC%2FYyjhBz0GFVMJPOz%2Br5mxefuF%2BvhBE31Ps%2Fk4dO1vn2JEmSFB6%2BSScCKREija7EF7HOWmsYphGUmdn5LT4%3D&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47U77DK4D4T%2F20260513%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260513T170053Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=9b69c112508f3deea8920d4acbd68d5ad750de88767c32b4037c56ee0f7dc840 300w, https:\/\/blogs.glowscotland.org.uk\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2013\/02\/Slide153.png 600w\" sizes=\"auto, (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=IQoJb3JpZ2luX2VjEIH%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJHMEUCIDmWeDDc8tN9fGsmEf4DB2eLXelDf9kuft3RI3V26bfkAiEAg31gPoriml%2BwwShui1bRN%2F6NrDSba0IB92qY0HXfFXIquAUIShAFGgwyNzM1NzAxOTU0MzMiDAZk7e72KWH3N2Q%2BnSqVBUIi8nJdijaLRUjPXx5LDF8GCXNZWaYVfYzBd0sdcZinuFhYA2cOjsmNhUiRbkLazORXlV4NxzaJoO%2FUd4blamSDY3Lg2OS6Fq9kQWC4Wvxn4WkqTUAl0deRT8borl0RyzoEqTevVtpYo31mqVWjKYGcvlTH8%2BHdlQc2ft7lV4Khr7Vk9ksoXsenDV2uCxCfyo5f5UjLmOYnLhIUFyzdNXafC6S%2FKXtYkQ5LuEmZ1iaiZKStxsRtl3gECkKyR98N0qzpukVdjAvVnerqJVNzOknXbNqccub3cPYu3xKp%2FwRy6ezXSNO3wpvGizTA%2FNufUIfjJDkucXfHQSAj7vSCvzDn%2FoRYAC3PB20e2HRbOepsPUTiesAvH9nFufZG7x4Zsv7udSIFqvuvSu%2FIc4lAghbggqzGUC0Qvyg8Wl%2BYMV4pWUQh5VwIN8DVjE5%2FcLgBsxbW0RZRZ1i55cEAmfjnk%2Bpkv13XgOaMB%2BC5Itr9LhoxpH%2Bmh88k7my4qhF0nqXnvhBYBxyRqiWkad5%2FC8G%2FeYSBce8CEXfUsSApx%2BZYGoWI2OBdr%2BVBqnuoe7PANumuqLkIY2eg80Ca%2BIHLEJHTk8MZ%2FEIlaoQLQMHd%2FlMRCDtmrTp9SiVw0X4hQKBkQYizVkM7QV6xm8xz9Dlroo3yWqZHEm%2FzEbNpER0%2FKBJll87aEp0m0EntzwxVqjETO4HDZaJ5E4%2FlGXoEfG4YsTvBza3bTcbPIa%2F%2FQJp7Ha3fYKN3MjczCaPnuyiK98UmzK5unMpmVS4KQhseNG3xU3VW5d3s2JOnI6GnVBhIQ%2Bzo4LWrORnq1vLpS9vITT5bH9EIAfbV5hiHCW63RVs%2FByZeXrNDLL5ksK1%2FoEoTiKsOCX2nwhAIexMwvdmS0AY6sQGTfVrw4re3FdP56BHwftlJ1ZPwePloAMTV%2Fxg%2FJ%2Bc5yJwMc7ykUhwcwMB%2FQp9Q%2FTTSicwNuwt1Aw7Zo4xzih50anmbUfqN%2BuI9BuRF86rLDJYqA3sDFVVsr%2BQhLsabt3reYRTL%2B3ZU9WMoL20tJaWCj90eC%2FYyjhBz0GFVMJPOz%2Br5mxefuF%2BvhBE31Ps%2Fk4dO1vn2JEmSFB6%2BSScCKREija7EF7HOWmsYphGUmdn5LT4%3D&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47U77DK4D4T%2F20260513%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260513T170053Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=9b69c112508f3deea8920d4acbd68d5ad750de88767c32b4037c56ee0f7dc840\" 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 loading=\"lazy\" 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=IQoJb3JpZ2luX2VjEIH%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJHMEUCIDmWeDDc8tN9fGsmEf4DB2eLXelDf9kuft3RI3V26bfkAiEAg31gPoriml%2BwwShui1bRN%2F6NrDSba0IB92qY0HXfFXIquAUIShAFGgwyNzM1NzAxOTU0MzMiDAZk7e72KWH3N2Q%2BnSqVBUIi8nJdijaLRUjPXx5LDF8GCXNZWaYVfYzBd0sdcZinuFhYA2cOjsmNhUiRbkLazORXlV4NxzaJoO%2FUd4blamSDY3Lg2OS6Fq9kQWC4Wvxn4WkqTUAl0deRT8borl0RyzoEqTevVtpYo31mqVWjKYGcvlTH8%2BHdlQc2ft7lV4Khr7Vk9ksoXsenDV2uCxCfyo5f5UjLmOYnLhIUFyzdNXafC6S%2FKXtYkQ5LuEmZ1iaiZKStxsRtl3gECkKyR98N0qzpukVdjAvVnerqJVNzOknXbNqccub3cPYu3xKp%2FwRy6ezXSNO3wpvGizTA%2FNufUIfjJDkucXfHQSAj7vSCvzDn%2FoRYAC3PB20e2HRbOepsPUTiesAvH9nFufZG7x4Zsv7udSIFqvuvSu%2FIc4lAghbggqzGUC0Qvyg8Wl%2BYMV4pWUQh5VwIN8DVjE5%2FcLgBsxbW0RZRZ1i55cEAmfjnk%2Bpkv13XgOaMB%2BC5Itr9LhoxpH%2Bmh88k7my4qhF0nqXnvhBYBxyRqiWkad5%2FC8G%2FeYSBce8CEXfUsSApx%2BZYGoWI2OBdr%2BVBqnuoe7PANumuqLkIY2eg80Ca%2BIHLEJHTk8MZ%2FEIlaoQLQMHd%2FlMRCDtmrTp9SiVw0X4hQKBkQYizVkM7QV6xm8xz9Dlroo3yWqZHEm%2FzEbNpER0%2FKBJll87aEp0m0EntzwxVqjETO4HDZaJ5E4%2FlGXoEfG4YsTvBza3bTcbPIa%2F%2FQJp7Ha3fYKN3MjczCaPnuyiK98UmzK5unMpmVS4KQhseNG3xU3VW5d3s2JOnI6GnVBhIQ%2Bzo4LWrORnq1vLpS9vITT5bH9EIAfbV5hiHCW63RVs%2FByZeXrNDLL5ksK1%2FoEoTiKsOCX2nwhAIexMwvdmS0AY6sQGTfVrw4re3FdP56BHwftlJ1ZPwePloAMTV%2Fxg%2FJ%2Bc5yJwMc7ykUhwcwMB%2FQp9Q%2FTTSicwNuwt1Aw7Zo4xzih50anmbUfqN%2BuI9BuRF86rLDJYqA3sDFVVsr%2BQhLsabt3reYRTL%2B3ZU9WMoL20tJaWCj90eC%2FYyjhBz0GFVMJPOz%2Br5mxefuF%2BvhBE31Ps%2Fk4dO1vn2JEmSFB6%2BSScCKREija7EF7HOWmsYphGUmdn5LT4%3D&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47U77DK4D4T%2F20260513%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260513T170053Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=4fd49c145829e88930b137cbf71511f87f49f55ec8a36e5dfdbdd3308ea88069\" 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=IQoJb3JpZ2luX2VjEIH%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJHMEUCIDmWeDDc8tN9fGsmEf4DB2eLXelDf9kuft3RI3V26bfkAiEAg31gPoriml%2BwwShui1bRN%2F6NrDSba0IB92qY0HXfFXIquAUIShAFGgwyNzM1NzAxOTU0MzMiDAZk7e72KWH3N2Q%2BnSqVBUIi8nJdijaLRUjPXx5LDF8GCXNZWaYVfYzBd0sdcZinuFhYA2cOjsmNhUiRbkLazORXlV4NxzaJoO%2FUd4blamSDY3Lg2OS6Fq9kQWC4Wvxn4WkqTUAl0deRT8borl0RyzoEqTevVtpYo31mqVWjKYGcvlTH8%2BHdlQc2ft7lV4Khr7Vk9ksoXsenDV2uCxCfyo5f5UjLmOYnLhIUFyzdNXafC6S%2FKXtYkQ5LuEmZ1iaiZKStxsRtl3gECkKyR98N0qzpukVdjAvVnerqJVNzOknXbNqccub3cPYu3xKp%2FwRy6ezXSNO3wpvGizTA%2FNufUIfjJDkucXfHQSAj7vSCvzDn%2FoRYAC3PB20e2HRbOepsPUTiesAvH9nFufZG7x4Zsv7udSIFqvuvSu%2FIc4lAghbggqzGUC0Qvyg8Wl%2BYMV4pWUQh5VwIN8DVjE5%2FcLgBsxbW0RZRZ1i55cEAmfjnk%2Bpkv13XgOaMB%2BC5Itr9LhoxpH%2Bmh88k7my4qhF0nqXnvhBYBxyRqiWkad5%2FC8G%2FeYSBce8CEXfUsSApx%2BZYGoWI2OBdr%2BVBqnuoe7PANumuqLkIY2eg80Ca%2BIHLEJHTk8MZ%2FEIlaoQLQMHd%2FlMRCDtmrTp9SiVw0X4hQKBkQYizVkM7QV6xm8xz9Dlroo3yWqZHEm%2FzEbNpER0%2FKBJll87aEp0m0EntzwxVqjETO4HDZaJ5E4%2FlGXoEfG4YsTvBza3bTcbPIa%2F%2FQJp7Ha3fYKN3MjczCaPnuyiK98UmzK5unMpmVS4KQhseNG3xU3VW5d3s2JOnI6GnVBhIQ%2Bzo4LWrORnq1vLpS9vITT5bH9EIAfbV5hiHCW63RVs%2FByZeXrNDLL5ksK1%2FoEoTiKsOCX2nwhAIexMwvdmS0AY6sQGTfVrw4re3FdP56BHwftlJ1ZPwePloAMTV%2Fxg%2FJ%2Bc5yJwMc7ykUhwcwMB%2FQp9Q%2FTTSicwNuwt1Aw7Zo4xzih50anmbUfqN%2BuI9BuRF86rLDJYqA3sDFVVsr%2BQhLsabt3reYRTL%2B3ZU9WMoL20tJaWCj90eC%2FYyjhBz0GFVMJPOz%2Br5mxefuF%2BvhBE31Ps%2Fk4dO1vn2JEmSFB6%2BSScCKREija7EF7HOWmsYphGUmdn5LT4%3D&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47U77DK4D4T%2F20260513%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260513T170053Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=4fd49c145829e88930b137cbf71511f87f49f55ec8a36e5dfdbdd3308ea88069 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=IQoJb3JpZ2luX2VjEIH%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJHMEUCIDmWeDDc8tN9fGsmEf4DB2eLXelDf9kuft3RI3V26bfkAiEAg31gPoriml%2BwwShui1bRN%2F6NrDSba0IB92qY0HXfFXIquAUIShAFGgwyNzM1NzAxOTU0MzMiDAZk7e72KWH3N2Q%2BnSqVBUIi8nJdijaLRUjPXx5LDF8GCXNZWaYVfYzBd0sdcZinuFhYA2cOjsmNhUiRbkLazORXlV4NxzaJoO%2FUd4blamSDY3Lg2OS6Fq9kQWC4Wvxn4WkqTUAl0deRT8borl0RyzoEqTevVtpYo31mqVWjKYGcvlTH8%2BHdlQc2ft7lV4Khr7Vk9ksoXsenDV2uCxCfyo5f5UjLmOYnLhIUFyzdNXafC6S%2FKXtYkQ5LuEmZ1iaiZKStxsRtl3gECkKyR98N0qzpukVdjAvVnerqJVNzOknXbNqccub3cPYu3xKp%2FwRy6ezXSNO3wpvGizTA%2FNufUIfjJDkucXfHQSAj7vSCvzDn%2FoRYAC3PB20e2HRbOepsPUTiesAvH9nFufZG7x4Zsv7udSIFqvuvSu%2FIc4lAghbggqzGUC0Qvyg8Wl%2BYMV4pWUQh5VwIN8DVjE5%2FcLgBsxbW0RZRZ1i55cEAmfjnk%2Bpkv13XgOaMB%2BC5Itr9LhoxpH%2Bmh88k7my4qhF0nqXnvhBYBxyRqiWkad5%2FC8G%2FeYSBce8CEXfUsSApx%2BZYGoWI2OBdr%2BVBqnuoe7PANumuqLkIY2eg80Ca%2BIHLEJHTk8MZ%2FEIlaoQLQMHd%2FlMRCDtmrTp9SiVw0X4hQKBkQYizVkM7QV6xm8xz9Dlroo3yWqZHEm%2FzEbNpER0%2FKBJll87aEp0m0EntzwxVqjETO4HDZaJ5E4%2FlGXoEfG4YsTvBza3bTcbPIa%2F%2FQJp7Ha3fYKN3MjczCaPnuyiK98UmzK5unMpmVS4KQhseNG3xU3VW5d3s2JOnI6GnVBhIQ%2Bzo4LWrORnq1vLpS9vITT5bH9EIAfbV5hiHCW63RVs%2FByZeXrNDLL5ksK1%2FoEoTiKsOCX2nwhAIexMwvdmS0AY6sQGTfVrw4re3FdP56BHwftlJ1ZPwePloAMTV%2Fxg%2FJ%2Bc5yJwMc7ykUhwcwMB%2FQp9Q%2FTTSicwNuwt1Aw7Zo4xzih50anmbUfqN%2BuI9BuRF86rLDJYqA3sDFVVsr%2BQhLsabt3reYRTL%2B3ZU9WMoL20tJaWCj90eC%2FYyjhBz0GFVMJPOz%2Br5mxefuF%2BvhBE31Ps%2Fk4dO1vn2JEmSFB6%2BSScCKREija7EF7HOWmsYphGUmdn5LT4%3D&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47U77DK4D4T%2F20260513%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260513T170053Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=f29c6b3ec0ce7e7bfd9b48022bc3d05167e9bfb18641c8f51afbdaf65fdeb5e8 300w, https:\/\/blogs.glowscotland.org.uk\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2013\/02\/Slide163.png 600w\" sizes=\"auto, (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=IQoJb3JpZ2luX2VjEIH%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJHMEUCIDmWeDDc8tN9fGsmEf4DB2eLXelDf9kuft3RI3V26bfkAiEAg31gPoriml%2BwwShui1bRN%2F6NrDSba0IB92qY0HXfFXIquAUIShAFGgwyNzM1NzAxOTU0MzMiDAZk7e72KWH3N2Q%2BnSqVBUIi8nJdijaLRUjPXx5LDF8GCXNZWaYVfYzBd0sdcZinuFhYA2cOjsmNhUiRbkLazORXlV4NxzaJoO%2FUd4blamSDY3Lg2OS6Fq9kQWC4Wvxn4WkqTUAl0deRT8borl0RyzoEqTevVtpYo31mqVWjKYGcvlTH8%2BHdlQc2ft7lV4Khr7Vk9ksoXsenDV2uCxCfyo5f5UjLmOYnLhIUFyzdNXafC6S%2FKXtYkQ5LuEmZ1iaiZKStxsRtl3gECkKyR98N0qzpukVdjAvVnerqJVNzOknXbNqccub3cPYu3xKp%2FwRy6ezXSNO3wpvGizTA%2FNufUIfjJDkucXfHQSAj7vSCvzDn%2FoRYAC3PB20e2HRbOepsPUTiesAvH9nFufZG7x4Zsv7udSIFqvuvSu%2FIc4lAghbggqzGUC0Qvyg8Wl%2BYMV4pWUQh5VwIN8DVjE5%2FcLgBsxbW0RZRZ1i55cEAmfjnk%2Bpkv13XgOaMB%2BC5Itr9LhoxpH%2Bmh88k7my4qhF0nqXnvhBYBxyRqiWkad5%2FC8G%2FeYSBce8CEXfUsSApx%2BZYGoWI2OBdr%2BVBqnuoe7PANumuqLkIY2eg80Ca%2BIHLEJHTk8MZ%2FEIlaoQLQMHd%2FlMRCDtmrTp9SiVw0X4hQKBkQYizVkM7QV6xm8xz9Dlroo3yWqZHEm%2FzEbNpER0%2FKBJll87aEp0m0EntzwxVqjETO4HDZaJ5E4%2FlGXoEfG4YsTvBza3bTcbPIa%2F%2FQJp7Ha3fYKN3MjczCaPnuyiK98UmzK5unMpmVS4KQhseNG3xU3VW5d3s2JOnI6GnVBhIQ%2Bzo4LWrORnq1vLpS9vITT5bH9EIAfbV5hiHCW63RVs%2FByZeXrNDLL5ksK1%2FoEoTiKsOCX2nwhAIexMwvdmS0AY6sQGTfVrw4re3FdP56BHwftlJ1ZPwePloAMTV%2Fxg%2FJ%2Bc5yJwMc7ykUhwcwMB%2FQp9Q%2FTTSicwNuwt1Aw7Zo4xzih50anmbUfqN%2BuI9BuRF86rLDJYqA3sDFVVsr%2BQhLsabt3reYRTL%2B3ZU9WMoL20tJaWCj90eC%2FYyjhBz0GFVMJPOz%2Br5mxefuF%2BvhBE31Ps%2Fk4dO1vn2JEmSFB6%2BSScCKREija7EF7HOWmsYphGUmdn5LT4%3D&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47U77DK4D4T%2F20260513%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260513T170053Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=f29c6b3ec0ce7e7bfd9b48022bc3d05167e9bfb18641c8f51afbdaf65fdeb5e8\" 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 loading=\"lazy\" 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=IQoJb3JpZ2luX2VjEIH%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJHMEUCIDmWeDDc8tN9fGsmEf4DB2eLXelDf9kuft3RI3V26bfkAiEAg31gPoriml%2BwwShui1bRN%2F6NrDSba0IB92qY0HXfFXIquAUIShAFGgwyNzM1NzAxOTU0MzMiDAZk7e72KWH3N2Q%2BnSqVBUIi8nJdijaLRUjPXx5LDF8GCXNZWaYVfYzBd0sdcZinuFhYA2cOjsmNhUiRbkLazORXlV4NxzaJoO%2FUd4blamSDY3Lg2OS6Fq9kQWC4Wvxn4WkqTUAl0deRT8borl0RyzoEqTevVtpYo31mqVWjKYGcvlTH8%2BHdlQc2ft7lV4Khr7Vk9ksoXsenDV2uCxCfyo5f5UjLmOYnLhIUFyzdNXafC6S%2FKXtYkQ5LuEmZ1iaiZKStxsRtl3gECkKyR98N0qzpukVdjAvVnerqJVNzOknXbNqccub3cPYu3xKp%2FwRy6ezXSNO3wpvGizTA%2FNufUIfjJDkucXfHQSAj7vSCvzDn%2FoRYAC3PB20e2HRbOepsPUTiesAvH9nFufZG7x4Zsv7udSIFqvuvSu%2FIc4lAghbggqzGUC0Qvyg8Wl%2BYMV4pWUQh5VwIN8DVjE5%2FcLgBsxbW0RZRZ1i55cEAmfjnk%2Bpkv13XgOaMB%2BC5Itr9LhoxpH%2Bmh88k7my4qhF0nqXnvhBYBxyRqiWkad5%2FC8G%2FeYSBce8CEXfUsSApx%2BZYGoWI2OBdr%2BVBqnuoe7PANumuqLkIY2eg80Ca%2BIHLEJHTk8MZ%2FEIlaoQLQMHd%2FlMRCDtmrTp9SiVw0X4hQKBkQYizVkM7QV6xm8xz9Dlroo3yWqZHEm%2FzEbNpER0%2FKBJll87aEp0m0EntzwxVqjETO4HDZaJ5E4%2FlGXoEfG4YsTvBza3bTcbPIa%2F%2FQJp7Ha3fYKN3MjczCaPnuyiK98UmzK5unMpmVS4KQhseNG3xU3VW5d3s2JOnI6GnVBhIQ%2Bzo4LWrORnq1vLpS9vITT5bH9EIAfbV5hiHCW63RVs%2FByZeXrNDLL5ksK1%2FoEoTiKsOCX2nwhAIexMwvdmS0AY6sQGTfVrw4re3FdP56BHwftlJ1ZPwePloAMTV%2Fxg%2FJ%2Bc5yJwMc7ykUhwcwMB%2FQp9Q%2FTTSicwNuwt1Aw7Zo4xzih50anmbUfqN%2BuI9BuRF86rLDJYqA3sDFVVsr%2BQhLsabt3reYRTL%2B3ZU9WMoL20tJaWCj90eC%2FYyjhBz0GFVMJPOz%2Br5mxefuF%2BvhBE31Ps%2Fk4dO1vn2JEmSFB6%2BSScCKREija7EF7HOWmsYphGUmdn5LT4%3D&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47U77DK4D4T%2F20260513%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260513T170054Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=08483e713d1496b9666381986bc77b2f14ae7f0adcb6eb665056881792fe5993\" 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=IQoJb3JpZ2luX2VjEIH%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJHMEUCIDmWeDDc8tN9fGsmEf4DB2eLXelDf9kuft3RI3V26bfkAiEAg31gPoriml%2BwwShui1bRN%2F6NrDSba0IB92qY0HXfFXIquAUIShAFGgwyNzM1NzAxOTU0MzMiDAZk7e72KWH3N2Q%2BnSqVBUIi8nJdijaLRUjPXx5LDF8GCXNZWaYVfYzBd0sdcZinuFhYA2cOjsmNhUiRbkLazORXlV4NxzaJoO%2FUd4blamSDY3Lg2OS6Fq9kQWC4Wvxn4WkqTUAl0deRT8borl0RyzoEqTevVtpYo31mqVWjKYGcvlTH8%2BHdlQc2ft7lV4Khr7Vk9ksoXsenDV2uCxCfyo5f5UjLmOYnLhIUFyzdNXafC6S%2FKXtYkQ5LuEmZ1iaiZKStxsRtl3gECkKyR98N0qzpukVdjAvVnerqJVNzOknXbNqccub3cPYu3xKp%2FwRy6ezXSNO3wpvGizTA%2FNufUIfjJDkucXfHQSAj7vSCvzDn%2FoRYAC3PB20e2HRbOepsPUTiesAvH9nFufZG7x4Zsv7udSIFqvuvSu%2FIc4lAghbggqzGUC0Qvyg8Wl%2BYMV4pWUQh5VwIN8DVjE5%2FcLgBsxbW0RZRZ1i55cEAmfjnk%2Bpkv13XgOaMB%2BC5Itr9LhoxpH%2Bmh88k7my4qhF0nqXnvhBYBxyRqiWkad5%2FC8G%2FeYSBce8CEXfUsSApx%2BZYGoWI2OBdr%2BVBqnuoe7PANumuqLkIY2eg80Ca%2BIHLEJHTk8MZ%2FEIlaoQLQMHd%2FlMRCDtmrTp9SiVw0X4hQKBkQYizVkM7QV6xm8xz9Dlroo3yWqZHEm%2FzEbNpER0%2FKBJll87aEp0m0EntzwxVqjETO4HDZaJ5E4%2FlGXoEfG4YsTvBza3bTcbPIa%2F%2FQJp7Ha3fYKN3MjczCaPnuyiK98UmzK5unMpmVS4KQhseNG3xU3VW5d3s2JOnI6GnVBhIQ%2Bzo4LWrORnq1vLpS9vITT5bH9EIAfbV5hiHCW63RVs%2FByZeXrNDLL5ksK1%2FoEoTiKsOCX2nwhAIexMwvdmS0AY6sQGTfVrw4re3FdP56BHwftlJ1ZPwePloAMTV%2Fxg%2FJ%2Bc5yJwMc7ykUhwcwMB%2FQp9Q%2FTTSicwNuwt1Aw7Zo4xzih50anmbUfqN%2BuI9BuRF86rLDJYqA3sDFVVsr%2BQhLsabt3reYRTL%2B3ZU9WMoL20tJaWCj90eC%2FYyjhBz0GFVMJPOz%2Br5mxefuF%2BvhBE31Ps%2Fk4dO1vn2JEmSFB6%2BSScCKREija7EF7HOWmsYphGUmdn5LT4%3D&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47U77DK4D4T%2F20260513%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260513T170053Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=01be7cf425eae9c74764a15fa9b1addeee5fb3388edada47a62fc6dc8f328c0e 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=IQoJb3JpZ2luX2VjEIH%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJHMEUCIDmWeDDc8tN9fGsmEf4DB2eLXelDf9kuft3RI3V26bfkAiEAg31gPoriml%2BwwShui1bRN%2F6NrDSba0IB92qY0HXfFXIquAUIShAFGgwyNzM1NzAxOTU0MzMiDAZk7e72KWH3N2Q%2BnSqVBUIi8nJdijaLRUjPXx5LDF8GCXNZWaYVfYzBd0sdcZinuFhYA2cOjsmNhUiRbkLazORXlV4NxzaJoO%2FUd4blamSDY3Lg2OS6Fq9kQWC4Wvxn4WkqTUAl0deRT8borl0RyzoEqTevVtpYo31mqVWjKYGcvlTH8%2BHdlQc2ft7lV4Khr7Vk9ksoXsenDV2uCxCfyo5f5UjLmOYnLhIUFyzdNXafC6S%2FKXtYkQ5LuEmZ1iaiZKStxsRtl3gECkKyR98N0qzpukVdjAvVnerqJVNzOknXbNqccub3cPYu3xKp%2FwRy6ezXSNO3wpvGizTA%2FNufUIfjJDkucXfHQSAj7vSCvzDn%2FoRYAC3PB20e2HRbOepsPUTiesAvH9nFufZG7x4Zsv7udSIFqvuvSu%2FIc4lAghbggqzGUC0Qvyg8Wl%2BYMV4pWUQh5VwIN8DVjE5%2FcLgBsxbW0RZRZ1i55cEAmfjnk%2Bpkv13XgOaMB%2BC5Itr9LhoxpH%2Bmh88k7my4qhF0nqXnvhBYBxyRqiWkad5%2FC8G%2FeYSBce8CEXfUsSApx%2BZYGoWI2OBdr%2BVBqnuoe7PANumuqLkIY2eg80Ca%2BIHLEJHTk8MZ%2FEIlaoQLQMHd%2FlMRCDtmrTp9SiVw0X4hQKBkQYizVkM7QV6xm8xz9Dlroo3yWqZHEm%2FzEbNpER0%2FKBJll87aEp0m0EntzwxVqjETO4HDZaJ5E4%2FlGXoEfG4YsTvBza3bTcbPIa%2F%2FQJp7Ha3fYKN3MjczCaPnuyiK98UmzK5unMpmVS4KQhseNG3xU3VW5d3s2JOnI6GnVBhIQ%2Bzo4LWrORnq1vLpS9vITT5bH9EIAfbV5hiHCW63RVs%2FByZeXrNDLL5ksK1%2FoEoTiKsOCX2nwhAIexMwvdmS0AY6sQGTfVrw4re3FdP56BHwftlJ1ZPwePloAMTV%2Fxg%2FJ%2Bc5yJwMc7ykUhwcwMB%2FQp9Q%2FTTSicwNuwt1Aw7Zo4xzih50anmbUfqN%2BuI9BuRF86rLDJYqA3sDFVVsr%2BQhLsabt3reYRTL%2B3ZU9WMoL20tJaWCj90eC%2FYyjhBz0GFVMJPOz%2Br5mxefuF%2BvhBE31Ps%2Fk4dO1vn2JEmSFB6%2BSScCKREija7EF7HOWmsYphGUmdn5LT4%3D&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47U77DK4D4T%2F20260513%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260513T170053Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=9cff8086318d01b838e6dc094bb3581159f930b4b57672b3f6979686091a970b 300w, https:\/\/blogs.glowscotland.org.uk\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2013\/02\/Slide173.png 600w\" sizes=\"auto, (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=IQoJb3JpZ2luX2VjEIH%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJHMEUCIDmWeDDc8tN9fGsmEf4DB2eLXelDf9kuft3RI3V26bfkAiEAg31gPoriml%2BwwShui1bRN%2F6NrDSba0IB92qY0HXfFXIquAUIShAFGgwyNzM1NzAxOTU0MzMiDAZk7e72KWH3N2Q%2BnSqVBUIi8nJdijaLRUjPXx5LDF8GCXNZWaYVfYzBd0sdcZinuFhYA2cOjsmNhUiRbkLazORXlV4NxzaJoO%2FUd4blamSDY3Lg2OS6Fq9kQWC4Wvxn4WkqTUAl0deRT8borl0RyzoEqTevVtpYo31mqVWjKYGcvlTH8%2BHdlQc2ft7lV4Khr7Vk9ksoXsenDV2uCxCfyo5f5UjLmOYnLhIUFyzdNXafC6S%2FKXtYkQ5LuEmZ1iaiZKStxsRtl3gECkKyR98N0qzpukVdjAvVnerqJVNzOknXbNqccub3cPYu3xKp%2FwRy6ezXSNO3wpvGizTA%2FNufUIfjJDkucXfHQSAj7vSCvzDn%2FoRYAC3PB20e2HRbOepsPUTiesAvH9nFufZG7x4Zsv7udSIFqvuvSu%2FIc4lAghbggqzGUC0Qvyg8Wl%2BYMV4pWUQh5VwIN8DVjE5%2FcLgBsxbW0RZRZ1i55cEAmfjnk%2Bpkv13XgOaMB%2BC5Itr9LhoxpH%2Bmh88k7my4qhF0nqXnvhBYBxyRqiWkad5%2FC8G%2FeYSBce8CEXfUsSApx%2BZYGoWI2OBdr%2BVBqnuoe7PANumuqLkIY2eg80Ca%2BIHLEJHTk8MZ%2FEIlaoQLQMHd%2FlMRCDtmrTp9SiVw0X4hQKBkQYizVkM7QV6xm8xz9Dlroo3yWqZHEm%2FzEbNpER0%2FKBJll87aEp0m0EntzwxVqjETO4HDZaJ5E4%2FlGXoEfG4YsTvBza3bTcbPIa%2F%2FQJp7Ha3fYKN3MjczCaPnuyiK98UmzK5unMpmVS4KQhseNG3xU3VW5d3s2JOnI6GnVBhIQ%2Bzo4LWrORnq1vLpS9vITT5bH9EIAfbV5hiHCW63RVs%2FByZeXrNDLL5ksK1%2FoEoTiKsOCX2nwhAIexMwvdmS0AY6sQGTfVrw4re3FdP56BHwftlJ1ZPwePloAMTV%2Fxg%2FJ%2Bc5yJwMc7ykUhwcwMB%2FQp9Q%2FTTSicwNuwt1Aw7Zo4xzih50anmbUfqN%2BuI9BuRF86rLDJYqA3sDFVVsr%2BQhLsabt3reYRTL%2B3ZU9WMoL20tJaWCj90eC%2FYyjhBz0GFVMJPOz%2Br5mxefuF%2BvhBE31Ps%2Fk4dO1vn2JEmSFB6%2BSScCKREija7EF7HOWmsYphGUmdn5LT4%3D&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47U77DK4D4T%2F20260513%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260513T170054Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=5acffe020b9c6174d04196ca2c2462f4e343c7738b7dea9815d0459a04ccdac8\" 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 loading=\"lazy\" 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=IQoJb3JpZ2luX2VjEIH%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJHMEUCIDmWeDDc8tN9fGsmEf4DB2eLXelDf9kuft3RI3V26bfkAiEAg31gPoriml%2BwwShui1bRN%2F6NrDSba0IB92qY0HXfFXIquAUIShAFGgwyNzM1NzAxOTU0MzMiDAZk7e72KWH3N2Q%2BnSqVBUIi8nJdijaLRUjPXx5LDF8GCXNZWaYVfYzBd0sdcZinuFhYA2cOjsmNhUiRbkLazORXlV4NxzaJoO%2FUd4blamSDY3Lg2OS6Fq9kQWC4Wvxn4WkqTUAl0deRT8borl0RyzoEqTevVtpYo31mqVWjKYGcvlTH8%2BHdlQc2ft7lV4Khr7Vk9ksoXsenDV2uCxCfyo5f5UjLmOYnLhIUFyzdNXafC6S%2FKXtYkQ5LuEmZ1iaiZKStxsRtl3gECkKyR98N0qzpukVdjAvVnerqJVNzOknXbNqccub3cPYu3xKp%2FwRy6ezXSNO3wpvGizTA%2FNufUIfjJDkucXfHQSAj7vSCvzDn%2FoRYAC3PB20e2HRbOepsPUTiesAvH9nFufZG7x4Zsv7udSIFqvuvSu%2FIc4lAghbggqzGUC0Qvyg8Wl%2BYMV4pWUQh5VwIN8DVjE5%2FcLgBsxbW0RZRZ1i55cEAmfjnk%2Bpkv13XgOaMB%2BC5Itr9LhoxpH%2Bmh88k7my4qhF0nqXnvhBYBxyRqiWkad5%2FC8G%2FeYSBce8CEXfUsSApx%2BZYGoWI2OBdr%2BVBqnuoe7PANumuqLkIY2eg80Ca%2BIHLEJHTk8MZ%2FEIlaoQLQMHd%2FlMRCDtmrTp9SiVw0X4hQKBkQYizVkM7QV6xm8xz9Dlroo3yWqZHEm%2FzEbNpER0%2FKBJll87aEp0m0EntzwxVqjETO4HDZaJ5E4%2FlGXoEfG4YsTvBza3bTcbPIa%2F%2FQJp7Ha3fYKN3MjczCaPnuyiK98UmzK5unMpmVS4KQhseNG3xU3VW5d3s2JOnI6GnVBhIQ%2Bzo4LWrORnq1vLpS9vITT5bH9EIAfbV5hiHCW63RVs%2FByZeXrNDLL5ksK1%2FoEoTiKsOCX2nwhAIexMwvdmS0AY6sQGTfVrw4re3FdP56BHwftlJ1ZPwePloAMTV%2Fxg%2FJ%2Bc5yJwMc7ykUhwcwMB%2FQp9Q%2FTTSicwNuwt1Aw7Zo4xzih50anmbUfqN%2BuI9BuRF86rLDJYqA3sDFVVsr%2BQhLsabt3reYRTL%2B3ZU9WMoL20tJaWCj90eC%2FYyjhBz0GFVMJPOz%2Br5mxefuF%2BvhBE31Ps%2Fk4dO1vn2JEmSFB6%2BSScCKREija7EF7HOWmsYphGUmdn5LT4%3D&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47U77DK4D4T%2F20260513%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260513T170054Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=347896509d2edbf4f7145dbf0ac9bb4a3648e588ae1eae1d94fae45df9cee21a\" 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=IQoJb3JpZ2luX2VjEIH%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJHMEUCIDmWeDDc8tN9fGsmEf4DB2eLXelDf9kuft3RI3V26bfkAiEAg31gPoriml%2BwwShui1bRN%2F6NrDSba0IB92qY0HXfFXIquAUIShAFGgwyNzM1NzAxOTU0MzMiDAZk7e72KWH3N2Q%2BnSqVBUIi8nJdijaLRUjPXx5LDF8GCXNZWaYVfYzBd0sdcZinuFhYA2cOjsmNhUiRbkLazORXlV4NxzaJoO%2FUd4blamSDY3Lg2OS6Fq9kQWC4Wvxn4WkqTUAl0deRT8borl0RyzoEqTevVtpYo31mqVWjKYGcvlTH8%2BHdlQc2ft7lV4Khr7Vk9ksoXsenDV2uCxCfyo5f5UjLmOYnLhIUFyzdNXafC6S%2FKXtYkQ5LuEmZ1iaiZKStxsRtl3gECkKyR98N0qzpukVdjAvVnerqJVNzOknXbNqccub3cPYu3xKp%2FwRy6ezXSNO3wpvGizTA%2FNufUIfjJDkucXfHQSAj7vSCvzDn%2FoRYAC3PB20e2HRbOepsPUTiesAvH9nFufZG7x4Zsv7udSIFqvuvSu%2FIc4lAghbggqzGUC0Qvyg8Wl%2BYMV4pWUQh5VwIN8DVjE5%2FcLgBsxbW0RZRZ1i55cEAmfjnk%2Bpkv13XgOaMB%2BC5Itr9LhoxpH%2Bmh88k7my4qhF0nqXnvhBYBxyRqiWkad5%2FC8G%2FeYSBce8CEXfUsSApx%2BZYGoWI2OBdr%2BVBqnuoe7PANumuqLkIY2eg80Ca%2BIHLEJHTk8MZ%2FEIlaoQLQMHd%2FlMRCDtmrTp9SiVw0X4hQKBkQYizVkM7QV6xm8xz9Dlroo3yWqZHEm%2FzEbNpER0%2FKBJll87aEp0m0EntzwxVqjETO4HDZaJ5E4%2FlGXoEfG4YsTvBza3bTcbPIa%2F%2FQJp7Ha3fYKN3MjczCaPnuyiK98UmzK5unMpmVS4KQhseNG3xU3VW5d3s2JOnI6GnVBhIQ%2Bzo4LWrORnq1vLpS9vITT5bH9EIAfbV5hiHCW63RVs%2FByZeXrNDLL5ksK1%2FoEoTiKsOCX2nwhAIexMwvdmS0AY6sQGTfVrw4re3FdP56BHwftlJ1ZPwePloAMTV%2Fxg%2FJ%2Bc5yJwMc7ykUhwcwMB%2FQp9Q%2FTTSicwNuwt1Aw7Zo4xzih50anmbUfqN%2BuI9BuRF86rLDJYqA3sDFVVsr%2BQhLsabt3reYRTL%2B3ZU9WMoL20tJaWCj90eC%2FYyjhBz0GFVMJPOz%2Br5mxefuF%2BvhBE31Ps%2Fk4dO1vn2JEmSFB6%2BSScCKREija7EF7HOWmsYphGUmdn5LT4%3D&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47U77DK4D4T%2F20260513%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260513T170054Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=347896509d2edbf4f7145dbf0ac9bb4a3648e588ae1eae1d94fae45df9cee21a 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=IQoJb3JpZ2luX2VjEIH%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJHMEUCIDmWeDDc8tN9fGsmEf4DB2eLXelDf9kuft3RI3V26bfkAiEAg31gPoriml%2BwwShui1bRN%2F6NrDSba0IB92qY0HXfFXIquAUIShAFGgwyNzM1NzAxOTU0MzMiDAZk7e72KWH3N2Q%2BnSqVBUIi8nJdijaLRUjPXx5LDF8GCXNZWaYVfYzBd0sdcZinuFhYA2cOjsmNhUiRbkLazORXlV4NxzaJoO%2FUd4blamSDY3Lg2OS6Fq9kQWC4Wvxn4WkqTUAl0deRT8borl0RyzoEqTevVtpYo31mqVWjKYGcvlTH8%2BHdlQc2ft7lV4Khr7Vk9ksoXsenDV2uCxCfyo5f5UjLmOYnLhIUFyzdNXafC6S%2FKXtYkQ5LuEmZ1iaiZKStxsRtl3gECkKyR98N0qzpukVdjAvVnerqJVNzOknXbNqccub3cPYu3xKp%2FwRy6ezXSNO3wpvGizTA%2FNufUIfjJDkucXfHQSAj7vSCvzDn%2FoRYAC3PB20e2HRbOepsPUTiesAvH9nFufZG7x4Zsv7udSIFqvuvSu%2FIc4lAghbggqzGUC0Qvyg8Wl%2BYMV4pWUQh5VwIN8DVjE5%2FcLgBsxbW0RZRZ1i55cEAmfjnk%2Bpkv13XgOaMB%2BC5Itr9LhoxpH%2Bmh88k7my4qhF0nqXnvhBYBxyRqiWkad5%2FC8G%2FeYSBce8CEXfUsSApx%2BZYGoWI2OBdr%2BVBqnuoe7PANumuqLkIY2eg80Ca%2BIHLEJHTk8MZ%2FEIlaoQLQMHd%2FlMRCDtmrTp9SiVw0X4hQKBkQYizVkM7QV6xm8xz9Dlroo3yWqZHEm%2FzEbNpER0%2FKBJll87aEp0m0EntzwxVqjETO4HDZaJ5E4%2FlGXoEfG4YsTvBza3bTcbPIa%2F%2FQJp7Ha3fYKN3MjczCaPnuyiK98UmzK5unMpmVS4KQhseNG3xU3VW5d3s2JOnI6GnVBhIQ%2Bzo4LWrORnq1vLpS9vITT5bH9EIAfbV5hiHCW63RVs%2FByZeXrNDLL5ksK1%2FoEoTiKsOCX2nwhAIexMwvdmS0AY6sQGTfVrw4re3FdP56BHwftlJ1ZPwePloAMTV%2Fxg%2FJ%2Bc5yJwMc7ykUhwcwMB%2FQp9Q%2FTTSicwNuwt1Aw7Zo4xzih50anmbUfqN%2BuI9BuRF86rLDJYqA3sDFVVsr%2BQhLsabt3reYRTL%2B3ZU9WMoL20tJaWCj90eC%2FYyjhBz0GFVMJPOz%2Br5mxefuF%2BvhBE31Ps%2Fk4dO1vn2JEmSFB6%2BSScCKREija7EF7HOWmsYphGUmdn5LT4%3D&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47U77DK4D4T%2F20260513%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260513T170054Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=24ab4ab13a0fd32d47509ac59b5039334b4949ce4b1c59a2df39344958310c23 300w, https:\/\/blogs.glowscotland.org.uk\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2013\/02\/Slide183.png 600w\" sizes=\"auto, (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=IQoJb3JpZ2luX2VjEIH%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJHMEUCIDmWeDDc8tN9fGsmEf4DB2eLXelDf9kuft3RI3V26bfkAiEAg31gPoriml%2BwwShui1bRN%2F6NrDSba0IB92qY0HXfFXIquAUIShAFGgwyNzM1NzAxOTU0MzMiDAZk7e72KWH3N2Q%2BnSqVBUIi8nJdijaLRUjPXx5LDF8GCXNZWaYVfYzBd0sdcZinuFhYA2cOjsmNhUiRbkLazORXlV4NxzaJoO%2FUd4blamSDY3Lg2OS6Fq9kQWC4Wvxn4WkqTUAl0deRT8borl0RyzoEqTevVtpYo31mqVWjKYGcvlTH8%2BHdlQc2ft7lV4Khr7Vk9ksoXsenDV2uCxCfyo5f5UjLmOYnLhIUFyzdNXafC6S%2FKXtYkQ5LuEmZ1iaiZKStxsRtl3gECkKyR98N0qzpukVdjAvVnerqJVNzOknXbNqccub3cPYu3xKp%2FwRy6ezXSNO3wpvGizTA%2FNufUIfjJDkucXfHQSAj7vSCvzDn%2FoRYAC3PB20e2HRbOepsPUTiesAvH9nFufZG7x4Zsv7udSIFqvuvSu%2FIc4lAghbggqzGUC0Qvyg8Wl%2BYMV4pWUQh5VwIN8DVjE5%2FcLgBsxbW0RZRZ1i55cEAmfjnk%2Bpkv13XgOaMB%2BC5Itr9LhoxpH%2Bmh88k7my4qhF0nqXnvhBYBxyRqiWkad5%2FC8G%2FeYSBce8CEXfUsSApx%2BZYGoWI2OBdr%2BVBqnuoe7PANumuqLkIY2eg80Ca%2BIHLEJHTk8MZ%2FEIlaoQLQMHd%2FlMRCDtmrTp9SiVw0X4hQKBkQYizVkM7QV6xm8xz9Dlroo3yWqZHEm%2FzEbNpER0%2FKBJll87aEp0m0EntzwxVqjETO4HDZaJ5E4%2FlGXoEfG4YsTvBza3bTcbPIa%2F%2FQJp7Ha3fYKN3MjczCaPnuyiK98UmzK5unMpmVS4KQhseNG3xU3VW5d3s2JOnI6GnVBhIQ%2Bzo4LWrORnq1vLpS9vITT5bH9EIAfbV5hiHCW63RVs%2FByZeXrNDLL5ksK1%2FoEoTiKsOCX2nwhAIexMwvdmS0AY6sQGTfVrw4re3FdP56BHwftlJ1ZPwePloAMTV%2Fxg%2FJ%2Bc5yJwMc7ykUhwcwMB%2FQp9Q%2FTTSicwNuwt1Aw7Zo4xzih50anmbUfqN%2BuI9BuRF86rLDJYqA3sDFVVsr%2BQhLsabt3reYRTL%2B3ZU9WMoL20tJaWCj90eC%2FYyjhBz0GFVMJPOz%2Br5mxefuF%2BvhBE31Ps%2Fk4dO1vn2JEmSFB6%2BSScCKREija7EF7HOWmsYphGUmdn5LT4%3D&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47U77DK4D4T%2F20260513%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260513T170054Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=24ab4ab13a0fd32d47509ac59b5039334b4949ce4b1c59a2df39344958310c23\" 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 loading=\"lazy\" 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=IQoJb3JpZ2luX2VjEIH%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJHMEUCIDmWeDDc8tN9fGsmEf4DB2eLXelDf9kuft3RI3V26bfkAiEAg31gPoriml%2BwwShui1bRN%2F6NrDSba0IB92qY0HXfFXIquAUIShAFGgwyNzM1NzAxOTU0MzMiDAZk7e72KWH3N2Q%2BnSqVBUIi8nJdijaLRUjPXx5LDF8GCXNZWaYVfYzBd0sdcZinuFhYA2cOjsmNhUiRbkLazORXlV4NxzaJoO%2FUd4blamSDY3Lg2OS6Fq9kQWC4Wvxn4WkqTUAl0deRT8borl0RyzoEqTevVtpYo31mqVWjKYGcvlTH8%2BHdlQc2ft7lV4Khr7Vk9ksoXsenDV2uCxCfyo5f5UjLmOYnLhIUFyzdNXafC6S%2FKXtYkQ5LuEmZ1iaiZKStxsRtl3gECkKyR98N0qzpukVdjAvVnerqJVNzOknXbNqccub3cPYu3xKp%2FwRy6ezXSNO3wpvGizTA%2FNufUIfjJDkucXfHQSAj7vSCvzDn%2FoRYAC3PB20e2HRbOepsPUTiesAvH9nFufZG7x4Zsv7udSIFqvuvSu%2FIc4lAghbggqzGUC0Qvyg8Wl%2BYMV4pWUQh5VwIN8DVjE5%2FcLgBsxbW0RZRZ1i55cEAmfjnk%2Bpkv13XgOaMB%2BC5Itr9LhoxpH%2Bmh88k7my4qhF0nqXnvhBYBxyRqiWkad5%2FC8G%2FeYSBce8CEXfUsSApx%2BZYGoWI2OBdr%2BVBqnuoe7PANumuqLkIY2eg80Ca%2BIHLEJHTk8MZ%2FEIlaoQLQMHd%2FlMRCDtmrTp9SiVw0X4hQKBkQYizVkM7QV6xm8xz9Dlroo3yWqZHEm%2FzEbNpER0%2FKBJll87aEp0m0EntzwxVqjETO4HDZaJ5E4%2FlGXoEfG4YsTvBza3bTcbPIa%2F%2FQJp7Ha3fYKN3MjczCaPnuyiK98UmzK5unMpmVS4KQhseNG3xU3VW5d3s2JOnI6GnVBhIQ%2Bzo4LWrORnq1vLpS9vITT5bH9EIAfbV5hiHCW63RVs%2FByZeXrNDLL5ksK1%2FoEoTiKsOCX2nwhAIexMwvdmS0AY6sQGTfVrw4re3FdP56BHwftlJ1ZPwePloAMTV%2Fxg%2FJ%2Bc5yJwMc7ykUhwcwMB%2FQp9Q%2FTTSicwNuwt1Aw7Zo4xzih50anmbUfqN%2BuI9BuRF86rLDJYqA3sDFVVsr%2BQhLsabt3reYRTL%2B3ZU9WMoL20tJaWCj90eC%2FYyjhBz0GFVMJPOz%2Br5mxefuF%2BvhBE31Ps%2Fk4dO1vn2JEmSFB6%2BSScCKREija7EF7HOWmsYphGUmdn5LT4%3D&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47U77DK4D4T%2F20260513%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260513T170054Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=56bfa8ad6662381fdb382a60508653aff8de33a4abb789ff7fa79e61bf1a7a54\" 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=IQoJb3JpZ2luX2VjEIH%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJHMEUCIDmWeDDc8tN9fGsmEf4DB2eLXelDf9kuft3RI3V26bfkAiEAg31gPoriml%2BwwShui1bRN%2F6NrDSba0IB92qY0HXfFXIquAUIShAFGgwyNzM1NzAxOTU0MzMiDAZk7e72KWH3N2Q%2BnSqVBUIi8nJdijaLRUjPXx5LDF8GCXNZWaYVfYzBd0sdcZinuFhYA2cOjsmNhUiRbkLazORXlV4NxzaJoO%2FUd4blamSDY3Lg2OS6Fq9kQWC4Wvxn4WkqTUAl0deRT8borl0RyzoEqTevVtpYo31mqVWjKYGcvlTH8%2BHdlQc2ft7lV4Khr7Vk9ksoXsenDV2uCxCfyo5f5UjLmOYnLhIUFyzdNXafC6S%2FKXtYkQ5LuEmZ1iaiZKStxsRtl3gECkKyR98N0qzpukVdjAvVnerqJVNzOknXbNqccub3cPYu3xKp%2FwRy6ezXSNO3wpvGizTA%2FNufUIfjJDkucXfHQSAj7vSCvzDn%2FoRYAC3PB20e2HRbOepsPUTiesAvH9nFufZG7x4Zsv7udSIFqvuvSu%2FIc4lAghbggqzGUC0Qvyg8Wl%2BYMV4pWUQh5VwIN8DVjE5%2FcLgBsxbW0RZRZ1i55cEAmfjnk%2Bpkv13XgOaMB%2BC5Itr9LhoxpH%2Bmh88k7my4qhF0nqXnvhBYBxyRqiWkad5%2FC8G%2FeYSBce8CEXfUsSApx%2BZYGoWI2OBdr%2BVBqnuoe7PANumuqLkIY2eg80Ca%2BIHLEJHTk8MZ%2FEIlaoQLQMHd%2FlMRCDtmrTp9SiVw0X4hQKBkQYizVkM7QV6xm8xz9Dlroo3yWqZHEm%2FzEbNpER0%2FKBJll87aEp0m0EntzwxVqjETO4HDZaJ5E4%2FlGXoEfG4YsTvBza3bTcbPIa%2F%2FQJp7Ha3fYKN3MjczCaPnuyiK98UmzK5unMpmVS4KQhseNG3xU3VW5d3s2JOnI6GnVBhIQ%2Bzo4LWrORnq1vLpS9vITT5bH9EIAfbV5hiHCW63RVs%2FByZeXrNDLL5ksK1%2FoEoTiKsOCX2nwhAIexMwvdmS0AY6sQGTfVrw4re3FdP56BHwftlJ1ZPwePloAMTV%2Fxg%2FJ%2Bc5yJwMc7ykUhwcwMB%2FQp9Q%2FTTSicwNuwt1Aw7Zo4xzih50anmbUfqN%2BuI9BuRF86rLDJYqA3sDFVVsr%2BQhLsabt3reYRTL%2B3ZU9WMoL20tJaWCj90eC%2FYyjhBz0GFVMJPOz%2Br5mxefuF%2BvhBE31Ps%2Fk4dO1vn2JEmSFB6%2BSScCKREija7EF7HOWmsYphGUmdn5LT4%3D&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47U77DK4D4T%2F20260513%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260513T170054Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=56bfa8ad6662381fdb382a60508653aff8de33a4abb789ff7fa79e61bf1a7a54 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=IQoJb3JpZ2luX2VjEIH%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJHMEUCIDmWeDDc8tN9fGsmEf4DB2eLXelDf9kuft3RI3V26bfkAiEAg31gPoriml%2BwwShui1bRN%2F6NrDSba0IB92qY0HXfFXIquAUIShAFGgwyNzM1NzAxOTU0MzMiDAZk7e72KWH3N2Q%2BnSqVBUIi8nJdijaLRUjPXx5LDF8GCXNZWaYVfYzBd0sdcZinuFhYA2cOjsmNhUiRbkLazORXlV4NxzaJoO%2FUd4blamSDY3Lg2OS6Fq9kQWC4Wvxn4WkqTUAl0deRT8borl0RyzoEqTevVtpYo31mqVWjKYGcvlTH8%2BHdlQc2ft7lV4Khr7Vk9ksoXsenDV2uCxCfyo5f5UjLmOYnLhIUFyzdNXafC6S%2FKXtYkQ5LuEmZ1iaiZKStxsRtl3gECkKyR98N0qzpukVdjAvVnerqJVNzOknXbNqccub3cPYu3xKp%2FwRy6ezXSNO3wpvGizTA%2FNufUIfjJDkucXfHQSAj7vSCvzDn%2FoRYAC3PB20e2HRbOepsPUTiesAvH9nFufZG7x4Zsv7udSIFqvuvSu%2FIc4lAghbggqzGUC0Qvyg8Wl%2BYMV4pWUQh5VwIN8DVjE5%2FcLgBsxbW0RZRZ1i55cEAmfjnk%2Bpkv13XgOaMB%2BC5Itr9LhoxpH%2Bmh88k7my4qhF0nqXnvhBYBxyRqiWkad5%2FC8G%2FeYSBce8CEXfUsSApx%2BZYGoWI2OBdr%2BVBqnuoe7PANumuqLkIY2eg80Ca%2BIHLEJHTk8MZ%2FEIlaoQLQMHd%2FlMRCDtmrTp9SiVw0X4hQKBkQYizVkM7QV6xm8xz9Dlroo3yWqZHEm%2FzEbNpER0%2FKBJll87aEp0m0EntzwxVqjETO4HDZaJ5E4%2FlGXoEfG4YsTvBza3bTcbPIa%2F%2FQJp7Ha3fYKN3MjczCaPnuyiK98UmzK5unMpmVS4KQhseNG3xU3VW5d3s2JOnI6GnVBhIQ%2Bzo4LWrORnq1vLpS9vITT5bH9EIAfbV5hiHCW63RVs%2FByZeXrNDLL5ksK1%2FoEoTiKsOCX2nwhAIexMwvdmS0AY6sQGTfVrw4re3FdP56BHwftlJ1ZPwePloAMTV%2Fxg%2FJ%2Bc5yJwMc7ykUhwcwMB%2FQp9Q%2FTTSicwNuwt1Aw7Zo4xzih50anmbUfqN%2BuI9BuRF86rLDJYqA3sDFVVsr%2BQhLsabt3reYRTL%2B3ZU9WMoL20tJaWCj90eC%2FYyjhBz0GFVMJPOz%2Br5mxefuF%2BvhBE31Ps%2Fk4dO1vn2JEmSFB6%2BSScCKREija7EF7HOWmsYphGUmdn5LT4%3D&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47U77DK4D4T%2F20260513%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260513T170054Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=9cb6d244d7b9645f4722004eeb0883d919c164a51738b0ffcf95a7512b9047bc 300w, https:\/\/blogs.glowscotland.org.uk\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2013\/02\/Slide193.png 600w\" sizes=\"auto, (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=IQoJb3JpZ2luX2VjEIH%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJHMEUCIDmWeDDc8tN9fGsmEf4DB2eLXelDf9kuft3RI3V26bfkAiEAg31gPoriml%2BwwShui1bRN%2F6NrDSba0IB92qY0HXfFXIquAUIShAFGgwyNzM1NzAxOTU0MzMiDAZk7e72KWH3N2Q%2BnSqVBUIi8nJdijaLRUjPXx5LDF8GCXNZWaYVfYzBd0sdcZinuFhYA2cOjsmNhUiRbkLazORXlV4NxzaJoO%2FUd4blamSDY3Lg2OS6Fq9kQWC4Wvxn4WkqTUAl0deRT8borl0RyzoEqTevVtpYo31mqVWjKYGcvlTH8%2BHdlQc2ft7lV4Khr7Vk9ksoXsenDV2uCxCfyo5f5UjLmOYnLhIUFyzdNXafC6S%2FKXtYkQ5LuEmZ1iaiZKStxsRtl3gECkKyR98N0qzpukVdjAvVnerqJVNzOknXbNqccub3cPYu3xKp%2FwRy6ezXSNO3wpvGizTA%2FNufUIfjJDkucXfHQSAj7vSCvzDn%2FoRYAC3PB20e2HRbOepsPUTiesAvH9nFufZG7x4Zsv7udSIFqvuvSu%2FIc4lAghbggqzGUC0Qvyg8Wl%2BYMV4pWUQh5VwIN8DVjE5%2FcLgBsxbW0RZRZ1i55cEAmfjnk%2Bpkv13XgOaMB%2BC5Itr9LhoxpH%2Bmh88k7my4qhF0nqXnvhBYBxyRqiWkad5%2FC8G%2FeYSBce8CEXfUsSApx%2BZYGoWI2OBdr%2BVBqnuoe7PANumuqLkIY2eg80Ca%2BIHLEJHTk8MZ%2FEIlaoQLQMHd%2FlMRCDtmrTp9SiVw0X4hQKBkQYizVkM7QV6xm8xz9Dlroo3yWqZHEm%2FzEbNpER0%2FKBJll87aEp0m0EntzwxVqjETO4HDZaJ5E4%2FlGXoEfG4YsTvBza3bTcbPIa%2F%2FQJp7Ha3fYKN3MjczCaPnuyiK98UmzK5unMpmVS4KQhseNG3xU3VW5d3s2JOnI6GnVBhIQ%2Bzo4LWrORnq1vLpS9vITT5bH9EIAfbV5hiHCW63RVs%2FByZeXrNDLL5ksK1%2FoEoTiKsOCX2nwhAIexMwvdmS0AY6sQGTfVrw4re3FdP56BHwftlJ1ZPwePloAMTV%2Fxg%2FJ%2Bc5yJwMc7ykUhwcwMB%2FQp9Q%2FTTSicwNuwt1Aw7Zo4xzih50anmbUfqN%2BuI9BuRF86rLDJYqA3sDFVVsr%2BQhLsabt3reYRTL%2B3ZU9WMoL20tJaWCj90eC%2FYyjhBz0GFVMJPOz%2Br5mxefuF%2BvhBE31Ps%2Fk4dO1vn2JEmSFB6%2BSScCKREija7EF7HOWmsYphGUmdn5LT4%3D&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47U77DK4D4T%2F20260513%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260513T170054Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=9cb6d244d7b9645f4722004eeb0883d919c164a51738b0ffcf95a7512b9047bc\" 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 loading=\"lazy\" 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=IQoJb3JpZ2luX2VjEIH%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJHMEUCIDmWeDDc8tN9fGsmEf4DB2eLXelDf9kuft3RI3V26bfkAiEAg31gPoriml%2BwwShui1bRN%2F6NrDSba0IB92qY0HXfFXIquAUIShAFGgwyNzM1NzAxOTU0MzMiDAZk7e72KWH3N2Q%2BnSqVBUIi8nJdijaLRUjPXx5LDF8GCXNZWaYVfYzBd0sdcZinuFhYA2cOjsmNhUiRbkLazORXlV4NxzaJoO%2FUd4blamSDY3Lg2OS6Fq9kQWC4Wvxn4WkqTUAl0deRT8borl0RyzoEqTevVtpYo31mqVWjKYGcvlTH8%2BHdlQc2ft7lV4Khr7Vk9ksoXsenDV2uCxCfyo5f5UjLmOYnLhIUFyzdNXafC6S%2FKXtYkQ5LuEmZ1iaiZKStxsRtl3gECkKyR98N0qzpukVdjAvVnerqJVNzOknXbNqccub3cPYu3xKp%2FwRy6ezXSNO3wpvGizTA%2FNufUIfjJDkucXfHQSAj7vSCvzDn%2FoRYAC3PB20e2HRbOepsPUTiesAvH9nFufZG7x4Zsv7udSIFqvuvSu%2FIc4lAghbggqzGUC0Qvyg8Wl%2BYMV4pWUQh5VwIN8DVjE5%2FcLgBsxbW0RZRZ1i55cEAmfjnk%2Bpkv13XgOaMB%2BC5Itr9LhoxpH%2Bmh88k7my4qhF0nqXnvhBYBxyRqiWkad5%2FC8G%2FeYSBce8CEXfUsSApx%2BZYGoWI2OBdr%2BVBqnuoe7PANumuqLkIY2eg80Ca%2BIHLEJHTk8MZ%2FEIlaoQLQMHd%2FlMRCDtmrTp9SiVw0X4hQKBkQYizVkM7QV6xm8xz9Dlroo3yWqZHEm%2FzEbNpER0%2FKBJll87aEp0m0EntzwxVqjETO4HDZaJ5E4%2FlGXoEfG4YsTvBza3bTcbPIa%2F%2FQJp7Ha3fYKN3MjczCaPnuyiK98UmzK5unMpmVS4KQhseNG3xU3VW5d3s2JOnI6GnVBhIQ%2Bzo4LWrORnq1vLpS9vITT5bH9EIAfbV5hiHCW63RVs%2FByZeXrNDLL5ksK1%2FoEoTiKsOCX2nwhAIexMwvdmS0AY6sQGTfVrw4re3FdP56BHwftlJ1ZPwePloAMTV%2Fxg%2FJ%2Bc5yJwMc7ykUhwcwMB%2FQp9Q%2FTTSicwNuwt1Aw7Zo4xzih50anmbUfqN%2BuI9BuRF86rLDJYqA3sDFVVsr%2BQhLsabt3reYRTL%2B3ZU9WMoL20tJaWCj90eC%2FYyjhBz0GFVMJPOz%2Br5mxefuF%2BvhBE31Ps%2Fk4dO1vn2JEmSFB6%2BSScCKREija7EF7HOWmsYphGUmdn5LT4%3D&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47U77DK4D4T%2F20260513%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260513T170054Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=094b6278f9a0d9b5a8d9120efbf2571132404289589a18808a8f604d2c9e4bc2\" 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=IQoJb3JpZ2luX2VjEIH%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJHMEUCIDmWeDDc8tN9fGsmEf4DB2eLXelDf9kuft3RI3V26bfkAiEAg31gPoriml%2BwwShui1bRN%2F6NrDSba0IB92qY0HXfFXIquAUIShAFGgwyNzM1NzAxOTU0MzMiDAZk7e72KWH3N2Q%2BnSqVBUIi8nJdijaLRUjPXx5LDF8GCXNZWaYVfYzBd0sdcZinuFhYA2cOjsmNhUiRbkLazORXlV4NxzaJoO%2FUd4blamSDY3Lg2OS6Fq9kQWC4Wvxn4WkqTUAl0deRT8borl0RyzoEqTevVtpYo31mqVWjKYGcvlTH8%2BHdlQc2ft7lV4Khr7Vk9ksoXsenDV2uCxCfyo5f5UjLmOYnLhIUFyzdNXafC6S%2FKXtYkQ5LuEmZ1iaiZKStxsRtl3gECkKyR98N0qzpukVdjAvVnerqJVNzOknXbNqccub3cPYu3xKp%2FwRy6ezXSNO3wpvGizTA%2FNufUIfjJDkucXfHQSAj7vSCvzDn%2FoRYAC3PB20e2HRbOepsPUTiesAvH9nFufZG7x4Zsv7udSIFqvuvSu%2FIc4lAghbggqzGUC0Qvyg8Wl%2BYMV4pWUQh5VwIN8DVjE5%2FcLgBsxbW0RZRZ1i55cEAmfjnk%2Bpkv13XgOaMB%2BC5Itr9LhoxpH%2Bmh88k7my4qhF0nqXnvhBYBxyRqiWkad5%2FC8G%2FeYSBce8CEXfUsSApx%2BZYGoWI2OBdr%2BVBqnuoe7PANumuqLkIY2eg80Ca%2BIHLEJHTk8MZ%2FEIlaoQLQMHd%2FlMRCDtmrTp9SiVw0X4hQKBkQYizVkM7QV6xm8xz9Dlroo3yWqZHEm%2FzEbNpER0%2FKBJll87aEp0m0EntzwxVqjETO4HDZaJ5E4%2FlGXoEfG4YsTvBza3bTcbPIa%2F%2FQJp7Ha3fYKN3MjczCaPnuyiK98UmzK5unMpmVS4KQhseNG3xU3VW5d3s2JOnI6GnVBhIQ%2Bzo4LWrORnq1vLpS9vITT5bH9EIAfbV5hiHCW63RVs%2FByZeXrNDLL5ksK1%2FoEoTiKsOCX2nwhAIexMwvdmS0AY6sQGTfVrw4re3FdP56BHwftlJ1ZPwePloAMTV%2Fxg%2FJ%2Bc5yJwMc7ykUhwcwMB%2FQp9Q%2FTTSicwNuwt1Aw7Zo4xzih50anmbUfqN%2BuI9BuRF86rLDJYqA3sDFVVsr%2BQhLsabt3reYRTL%2B3ZU9WMoL20tJaWCj90eC%2FYyjhBz0GFVMJPOz%2Br5mxefuF%2BvhBE31Ps%2Fk4dO1vn2JEmSFB6%2BSScCKREija7EF7HOWmsYphGUmdn5LT4%3D&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47U77DK4D4T%2F20260513%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260513T170054Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=094b6278f9a0d9b5a8d9120efbf2571132404289589a18808a8f604d2c9e4bc2 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=IQoJb3JpZ2luX2VjEIH%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJHMEUCIDmWeDDc8tN9fGsmEf4DB2eLXelDf9kuft3RI3V26bfkAiEAg31gPoriml%2BwwShui1bRN%2F6NrDSba0IB92qY0HXfFXIquAUIShAFGgwyNzM1NzAxOTU0MzMiDAZk7e72KWH3N2Q%2BnSqVBUIi8nJdijaLRUjPXx5LDF8GCXNZWaYVfYzBd0sdcZinuFhYA2cOjsmNhUiRbkLazORXlV4NxzaJoO%2FUd4blamSDY3Lg2OS6Fq9kQWC4Wvxn4WkqTUAl0deRT8borl0RyzoEqTevVtpYo31mqVWjKYGcvlTH8%2BHdlQc2ft7lV4Khr7Vk9ksoXsenDV2uCxCfyo5f5UjLmOYnLhIUFyzdNXafC6S%2FKXtYkQ5LuEmZ1iaiZKStxsRtl3gECkKyR98N0qzpukVdjAvVnerqJVNzOknXbNqccub3cPYu3xKp%2FwRy6ezXSNO3wpvGizTA%2FNufUIfjJDkucXfHQSAj7vSCvzDn%2FoRYAC3PB20e2HRbOepsPUTiesAvH9nFufZG7x4Zsv7udSIFqvuvSu%2FIc4lAghbggqzGUC0Qvyg8Wl%2BYMV4pWUQh5VwIN8DVjE5%2FcLgBsxbW0RZRZ1i55cEAmfjnk%2Bpkv13XgOaMB%2BC5Itr9LhoxpH%2Bmh88k7my4qhF0nqXnvhBYBxyRqiWkad5%2FC8G%2FeYSBce8CEXfUsSApx%2BZYGoWI2OBdr%2BVBqnuoe7PANumuqLkIY2eg80Ca%2BIHLEJHTk8MZ%2FEIlaoQLQMHd%2FlMRCDtmrTp9SiVw0X4hQKBkQYizVkM7QV6xm8xz9Dlroo3yWqZHEm%2FzEbNpER0%2FKBJll87aEp0m0EntzwxVqjETO4HDZaJ5E4%2FlGXoEfG4YsTvBza3bTcbPIa%2F%2FQJp7Ha3fYKN3MjczCaPnuyiK98UmzK5unMpmVS4KQhseNG3xU3VW5d3s2JOnI6GnVBhIQ%2Bzo4LWrORnq1vLpS9vITT5bH9EIAfbV5hiHCW63RVs%2FByZeXrNDLL5ksK1%2FoEoTiKsOCX2nwhAIexMwvdmS0AY6sQGTfVrw4re3FdP56BHwftlJ1ZPwePloAMTV%2Fxg%2FJ%2Bc5yJwMc7ykUhwcwMB%2FQp9Q%2FTTSicwNuwt1Aw7Zo4xzih50anmbUfqN%2BuI9BuRF86rLDJYqA3sDFVVsr%2BQhLsabt3reYRTL%2B3ZU9WMoL20tJaWCj90eC%2FYyjhBz0GFVMJPOz%2Br5mxefuF%2BvhBE31Ps%2Fk4dO1vn2JEmSFB6%2BSScCKREija7EF7HOWmsYphGUmdn5LT4%3D&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47U77DK4D4T%2F20260513%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260513T170054Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=397e1f2e7a6569455c342540dc3f3c2baf9a7557328cea963260a39eee8cc444 300w, https:\/\/blogs.glowscotland.org.uk\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2013\/02\/Slide202.png 600w\" sizes=\"auto, (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=IQoJb3JpZ2luX2VjEIH%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJHMEUCIDmWeDDc8tN9fGsmEf4DB2eLXelDf9kuft3RI3V26bfkAiEAg31gPoriml%2BwwShui1bRN%2F6NrDSba0IB92qY0HXfFXIquAUIShAFGgwyNzM1NzAxOTU0MzMiDAZk7e72KWH3N2Q%2BnSqVBUIi8nJdijaLRUjPXx5LDF8GCXNZWaYVfYzBd0sdcZinuFhYA2cOjsmNhUiRbkLazORXlV4NxzaJoO%2FUd4blamSDY3Lg2OS6Fq9kQWC4Wvxn4WkqTUAl0deRT8borl0RyzoEqTevVtpYo31mqVWjKYGcvlTH8%2BHdlQc2ft7lV4Khr7Vk9ksoXsenDV2uCxCfyo5f5UjLmOYnLhIUFyzdNXafC6S%2FKXtYkQ5LuEmZ1iaiZKStxsRtl3gECkKyR98N0qzpukVdjAvVnerqJVNzOknXbNqccub3cPYu3xKp%2FwRy6ezXSNO3wpvGizTA%2FNufUIfjJDkucXfHQSAj7vSCvzDn%2FoRYAC3PB20e2HRbOepsPUTiesAvH9nFufZG7x4Zsv7udSIFqvuvSu%2FIc4lAghbggqzGUC0Qvyg8Wl%2BYMV4pWUQh5VwIN8DVjE5%2FcLgBsxbW0RZRZ1i55cEAmfjnk%2Bpkv13XgOaMB%2BC5Itr9LhoxpH%2Bmh88k7my4qhF0nqXnvhBYBxyRqiWkad5%2FC8G%2FeYSBce8CEXfUsSApx%2BZYGoWI2OBdr%2BVBqnuoe7PANumuqLkIY2eg80Ca%2BIHLEJHTk8MZ%2FEIlaoQLQMHd%2FlMRCDtmrTp9SiVw0X4hQKBkQYizVkM7QV6xm8xz9Dlroo3yWqZHEm%2FzEbNpER0%2FKBJll87aEp0m0EntzwxVqjETO4HDZaJ5E4%2FlGXoEfG4YsTvBza3bTcbPIa%2F%2FQJp7Ha3fYKN3MjczCaPnuyiK98UmzK5unMpmVS4KQhseNG3xU3VW5d3s2JOnI6GnVBhIQ%2Bzo4LWrORnq1vLpS9vITT5bH9EIAfbV5hiHCW63RVs%2FByZeXrNDLL5ksK1%2FoEoTiKsOCX2nwhAIexMwvdmS0AY6sQGTfVrw4re3FdP56BHwftlJ1ZPwePloAMTV%2Fxg%2FJ%2Bc5yJwMc7ykUhwcwMB%2FQp9Q%2FTTSicwNuwt1Aw7Zo4xzih50anmbUfqN%2BuI9BuRF86rLDJYqA3sDFVVsr%2BQhLsabt3reYRTL%2B3ZU9WMoL20tJaWCj90eC%2FYyjhBz0GFVMJPOz%2Br5mxefuF%2BvhBE31Ps%2Fk4dO1vn2JEmSFB6%2BSScCKREija7EF7HOWmsYphGUmdn5LT4%3D&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47U77DK4D4T%2F20260513%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260513T170054Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=397e1f2e7a6569455c342540dc3f3c2baf9a7557328cea963260a39eee8cc444\" 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}]}}