{"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=IQoJb3JpZ2luX2VjEJL%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJHMEUCIQDV18Oo7MTeIGlI5dOtfYcPgJihgt6FDR1N7k2Re3pOoQIgd2au0VvJR22CPbJITF8dyTwlJfvChE0kGUTSbQ9FdjQquAUIWxAFGgwyNzM1NzAxOTU0MzMiDNQweSErN9xBSEbB6CqVBQD9AWHl7ZavPNgiVYtx9UVNeFZ0V1sniRReACfzN%2Bix%2BeLQPFgM9r5oBgxIByyK2%2FTEKrFL45pXQ%2BuFznivv814j87KiRGsi79Eimtr5YMJjHT3q53I4epkPxZk9NcnZhIlqRuBIkiGbwYZ5aE7f52v9Nema6Q9WOgUp5D0zPYKGR%2F7ImtadOlKuZr80EWNJsVijrX%2BIpc5K5p6HDTNL8fMOaIn1OugbrHam7RaE3%2BVPHNQM8aDNttXQUeoXw6%2Bh1EFBombaIzaSkbe8S%2FWO4KtMtas92g%2BsM9DBvq6Syb5XCVVOCy3F3xYXXN9A%2Fhl9vZL5ekMqWYZ2PyqHx2ABklYwcFep0C%2Br7PdO9ej6ktmx4sCHe1YRNM96tLVEbkmMt4rF%2BbZ%2Bwr3kS4SZidjECc8f%2F5D4IAdCk%2FnUG%2BwMXofrDurtYUiNKDYWmYBu2OYWWHTAezIpW1fUGOZ5fNYAg7JQN5Z2oZSREdDzDUCs%2BNvDb7SzsqlWZsA11sXrhz%2FFK9MBKeTY0XH7So6E1Vu%2BNxj2s%2BqiadUFabL8gSKj8iLCgl6scoYx2h8L4ClZ416e4YOGRikVH3EhyYO2skfqVD%2BI60Q3jZGa7FEpDk6jlvH6abFLw4YdDw9R%2Bthm1hpirjzq38490VECXvOfiSWLF19PbRn6N9VjRdEQ4Bi9qCCx2IvLVnmEOSduLJaENzkSQmOd5jhBmtlTGctlJM5OXr0fr1pV%2B9lKSYd%2FOSQxyFriizl5dH2xUshr1%2B7XEupvHo%2B0zaJsU6jLY4lyQXbPqRPEC2nnS6fphoXf7ovNHNOTMDuM7Uvlp5xBu7QHj541%2FZnBwhHHW8aMBqGg6kf%2FBjQ%2FdoCWjHh5M85dA2TTUntR%2BeU7YYww%2FGlzwY6sQGVBTThexnBSQFhdBlQoGAWKaVVhUE79sQKe3ikVZRXjZbewdIxTgHU8N4TMFjITHrAvIC2tmcIKO6nWFa2qw1mxOelb7rkregF9nxAaWD6ZE5L1PfCYUoz9JfjU6OqtNSVHN2HNjh80fyHmgBCnMfOk4wQrSgUL3ByiNegqTLxBxE%2BLgIi0Cd%2BIiVMWpbUOllluZKWn%2B%2FDO%2Fx1JYHGTZ%2FpSbJqqLh2eqXCXNvMYKhKGpg%3D&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47UWS26F442%2F20260423%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260423T023626Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=d52b88ae9eef5fe731f2bf44a3f683e5ccc4f7bcf24776aec98aa278789a7f9a\" 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=IQoJb3JpZ2luX2VjEJL%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJHMEUCIQDV18Oo7MTeIGlI5dOtfYcPgJihgt6FDR1N7k2Re3pOoQIgd2au0VvJR22CPbJITF8dyTwlJfvChE0kGUTSbQ9FdjQquAUIWxAFGgwyNzM1NzAxOTU0MzMiDNQweSErN9xBSEbB6CqVBQD9AWHl7ZavPNgiVYtx9UVNeFZ0V1sniRReACfzN%2Bix%2BeLQPFgM9r5oBgxIByyK2%2FTEKrFL45pXQ%2BuFznivv814j87KiRGsi79Eimtr5YMJjHT3q53I4epkPxZk9NcnZhIlqRuBIkiGbwYZ5aE7f52v9Nema6Q9WOgUp5D0zPYKGR%2F7ImtadOlKuZr80EWNJsVijrX%2BIpc5K5p6HDTNL8fMOaIn1OugbrHam7RaE3%2BVPHNQM8aDNttXQUeoXw6%2Bh1EFBombaIzaSkbe8S%2FWO4KtMtas92g%2BsM9DBvq6Syb5XCVVOCy3F3xYXXN9A%2Fhl9vZL5ekMqWYZ2PyqHx2ABklYwcFep0C%2Br7PdO9ej6ktmx4sCHe1YRNM96tLVEbkmMt4rF%2BbZ%2Bwr3kS4SZidjECc8f%2F5D4IAdCk%2FnUG%2BwMXofrDurtYUiNKDYWmYBu2OYWWHTAezIpW1fUGOZ5fNYAg7JQN5Z2oZSREdDzDUCs%2BNvDb7SzsqlWZsA11sXrhz%2FFK9MBKeTY0XH7So6E1Vu%2BNxj2s%2BqiadUFabL8gSKj8iLCgl6scoYx2h8L4ClZ416e4YOGRikVH3EhyYO2skfqVD%2BI60Q3jZGa7FEpDk6jlvH6abFLw4YdDw9R%2Bthm1hpirjzq38490VECXvOfiSWLF19PbRn6N9VjRdEQ4Bi9qCCx2IvLVnmEOSduLJaENzkSQmOd5jhBmtlTGctlJM5OXr0fr1pV%2B9lKSYd%2FOSQxyFriizl5dH2xUshr1%2B7XEupvHo%2B0zaJsU6jLY4lyQXbPqRPEC2nnS6fphoXf7ovNHNOTMDuM7Uvlp5xBu7QHj541%2FZnBwhHHW8aMBqGg6kf%2FBjQ%2FdoCWjHh5M85dA2TTUntR%2BeU7YYww%2FGlzwY6sQGVBTThexnBSQFhdBlQoGAWKaVVhUE79sQKe3ikVZRXjZbewdIxTgHU8N4TMFjITHrAvIC2tmcIKO6nWFa2qw1mxOelb7rkregF9nxAaWD6ZE5L1PfCYUoz9JfjU6OqtNSVHN2HNjh80fyHmgBCnMfOk4wQrSgUL3ByiNegqTLxBxE%2BLgIi0Cd%2BIiVMWpbUOllluZKWn%2B%2FDO%2Fx1JYHGTZ%2FpSbJqqLh2eqXCXNvMYKhKGpg%3D&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47UWS26F442%2F20260423%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260423T023626Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=d52b88ae9eef5fe731f2bf44a3f683e5ccc4f7bcf24776aec98aa278789a7f9a 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=IQoJb3JpZ2luX2VjEJL%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJHMEUCIQDV18Oo7MTeIGlI5dOtfYcPgJihgt6FDR1N7k2Re3pOoQIgd2au0VvJR22CPbJITF8dyTwlJfvChE0kGUTSbQ9FdjQquAUIWxAFGgwyNzM1NzAxOTU0MzMiDNQweSErN9xBSEbB6CqVBQD9AWHl7ZavPNgiVYtx9UVNeFZ0V1sniRReACfzN%2Bix%2BeLQPFgM9r5oBgxIByyK2%2FTEKrFL45pXQ%2BuFznivv814j87KiRGsi79Eimtr5YMJjHT3q53I4epkPxZk9NcnZhIlqRuBIkiGbwYZ5aE7f52v9Nema6Q9WOgUp5D0zPYKGR%2F7ImtadOlKuZr80EWNJsVijrX%2BIpc5K5p6HDTNL8fMOaIn1OugbrHam7RaE3%2BVPHNQM8aDNttXQUeoXw6%2Bh1EFBombaIzaSkbe8S%2FWO4KtMtas92g%2BsM9DBvq6Syb5XCVVOCy3F3xYXXN9A%2Fhl9vZL5ekMqWYZ2PyqHx2ABklYwcFep0C%2Br7PdO9ej6ktmx4sCHe1YRNM96tLVEbkmMt4rF%2BbZ%2Bwr3kS4SZidjECc8f%2F5D4IAdCk%2FnUG%2BwMXofrDurtYUiNKDYWmYBu2OYWWHTAezIpW1fUGOZ5fNYAg7JQN5Z2oZSREdDzDUCs%2BNvDb7SzsqlWZsA11sXrhz%2FFK9MBKeTY0XH7So6E1Vu%2BNxj2s%2BqiadUFabL8gSKj8iLCgl6scoYx2h8L4ClZ416e4YOGRikVH3EhyYO2skfqVD%2BI60Q3jZGa7FEpDk6jlvH6abFLw4YdDw9R%2Bthm1hpirjzq38490VECXvOfiSWLF19PbRn6N9VjRdEQ4Bi9qCCx2IvLVnmEOSduLJaENzkSQmOd5jhBmtlTGctlJM5OXr0fr1pV%2B9lKSYd%2FOSQxyFriizl5dH2xUshr1%2B7XEupvHo%2B0zaJsU6jLY4lyQXbPqRPEC2nnS6fphoXf7ovNHNOTMDuM7Uvlp5xBu7QHj541%2FZnBwhHHW8aMBqGg6kf%2FBjQ%2FdoCWjHh5M85dA2TTUntR%2BeU7YYww%2FGlzwY6sQGVBTThexnBSQFhdBlQoGAWKaVVhUE79sQKe3ikVZRXjZbewdIxTgHU8N4TMFjITHrAvIC2tmcIKO6nWFa2qw1mxOelb7rkregF9nxAaWD6ZE5L1PfCYUoz9JfjU6OqtNSVHN2HNjh80fyHmgBCnMfOk4wQrSgUL3ByiNegqTLxBxE%2BLgIi0Cd%2BIiVMWpbUOllluZKWn%2B%2FDO%2Fx1JYHGTZ%2FpSbJqqLh2eqXCXNvMYKhKGpg%3D&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47UWS26F442%2F20260423%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260423T023626Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=e484fab96ac707ff47f68477c65919784f0f11f13678419521fb90a26eefe1cb 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=IQoJb3JpZ2luX2VjEJL%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJHMEUCIQDV18Oo7MTeIGlI5dOtfYcPgJihgt6FDR1N7k2Re3pOoQIgd2au0VvJR22CPbJITF8dyTwlJfvChE0kGUTSbQ9FdjQquAUIWxAFGgwyNzM1NzAxOTU0MzMiDNQweSErN9xBSEbB6CqVBQD9AWHl7ZavPNgiVYtx9UVNeFZ0V1sniRReACfzN%2Bix%2BeLQPFgM9r5oBgxIByyK2%2FTEKrFL45pXQ%2BuFznivv814j87KiRGsi79Eimtr5YMJjHT3q53I4epkPxZk9NcnZhIlqRuBIkiGbwYZ5aE7f52v9Nema6Q9WOgUp5D0zPYKGR%2F7ImtadOlKuZr80EWNJsVijrX%2BIpc5K5p6HDTNL8fMOaIn1OugbrHam7RaE3%2BVPHNQM8aDNttXQUeoXw6%2Bh1EFBombaIzaSkbe8S%2FWO4KtMtas92g%2BsM9DBvq6Syb5XCVVOCy3F3xYXXN9A%2Fhl9vZL5ekMqWYZ2PyqHx2ABklYwcFep0C%2Br7PdO9ej6ktmx4sCHe1YRNM96tLVEbkmMt4rF%2BbZ%2Bwr3kS4SZidjECc8f%2F5D4IAdCk%2FnUG%2BwMXofrDurtYUiNKDYWmYBu2OYWWHTAezIpW1fUGOZ5fNYAg7JQN5Z2oZSREdDzDUCs%2BNvDb7SzsqlWZsA11sXrhz%2FFK9MBKeTY0XH7So6E1Vu%2BNxj2s%2BqiadUFabL8gSKj8iLCgl6scoYx2h8L4ClZ416e4YOGRikVH3EhyYO2skfqVD%2BI60Q3jZGa7FEpDk6jlvH6abFLw4YdDw9R%2Bthm1hpirjzq38490VECXvOfiSWLF19PbRn6N9VjRdEQ4Bi9qCCx2IvLVnmEOSduLJaENzkSQmOd5jhBmtlTGctlJM5OXr0fr1pV%2B9lKSYd%2FOSQxyFriizl5dH2xUshr1%2B7XEupvHo%2B0zaJsU6jLY4lyQXbPqRPEC2nnS6fphoXf7ovNHNOTMDuM7Uvlp5xBu7QHj541%2FZnBwhHHW8aMBqGg6kf%2FBjQ%2FdoCWjHh5M85dA2TTUntR%2BeU7YYww%2FGlzwY6sQGVBTThexnBSQFhdBlQoGAWKaVVhUE79sQKe3ikVZRXjZbewdIxTgHU8N4TMFjITHrAvIC2tmcIKO6nWFa2qw1mxOelb7rkregF9nxAaWD6ZE5L1PfCYUoz9JfjU6OqtNSVHN2HNjh80fyHmgBCnMfOk4wQrSgUL3ByiNegqTLxBxE%2BLgIi0Cd%2BIiVMWpbUOllluZKWn%2B%2FDO%2Fx1JYHGTZ%2FpSbJqqLh2eqXCXNvMYKhKGpg%3D&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47UWS26F442%2F20260423%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260423T023626Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=e484fab96ac707ff47f68477c65919784f0f11f13678419521fb90a26eefe1cb\" 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=IQoJb3JpZ2luX2VjEJL%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJHMEUCIQDV18Oo7MTeIGlI5dOtfYcPgJihgt6FDR1N7k2Re3pOoQIgd2au0VvJR22CPbJITF8dyTwlJfvChE0kGUTSbQ9FdjQquAUIWxAFGgwyNzM1NzAxOTU0MzMiDNQweSErN9xBSEbB6CqVBQD9AWHl7ZavPNgiVYtx9UVNeFZ0V1sniRReACfzN%2Bix%2BeLQPFgM9r5oBgxIByyK2%2FTEKrFL45pXQ%2BuFznivv814j87KiRGsi79Eimtr5YMJjHT3q53I4epkPxZk9NcnZhIlqRuBIkiGbwYZ5aE7f52v9Nema6Q9WOgUp5D0zPYKGR%2F7ImtadOlKuZr80EWNJsVijrX%2BIpc5K5p6HDTNL8fMOaIn1OugbrHam7RaE3%2BVPHNQM8aDNttXQUeoXw6%2Bh1EFBombaIzaSkbe8S%2FWO4KtMtas92g%2BsM9DBvq6Syb5XCVVOCy3F3xYXXN9A%2Fhl9vZL5ekMqWYZ2PyqHx2ABklYwcFep0C%2Br7PdO9ej6ktmx4sCHe1YRNM96tLVEbkmMt4rF%2BbZ%2Bwr3kS4SZidjECc8f%2F5D4IAdCk%2FnUG%2BwMXofrDurtYUiNKDYWmYBu2OYWWHTAezIpW1fUGOZ5fNYAg7JQN5Z2oZSREdDzDUCs%2BNvDb7SzsqlWZsA11sXrhz%2FFK9MBKeTY0XH7So6E1Vu%2BNxj2s%2BqiadUFabL8gSKj8iLCgl6scoYx2h8L4ClZ416e4YOGRikVH3EhyYO2skfqVD%2BI60Q3jZGa7FEpDk6jlvH6abFLw4YdDw9R%2Bthm1hpirjzq38490VECXvOfiSWLF19PbRn6N9VjRdEQ4Bi9qCCx2IvLVnmEOSduLJaENzkSQmOd5jhBmtlTGctlJM5OXr0fr1pV%2B9lKSYd%2FOSQxyFriizl5dH2xUshr1%2B7XEupvHo%2B0zaJsU6jLY4lyQXbPqRPEC2nnS6fphoXf7ovNHNOTMDuM7Uvlp5xBu7QHj541%2FZnBwhHHW8aMBqGg6kf%2FBjQ%2FdoCWjHh5M85dA2TTUntR%2BeU7YYww%2FGlzwY6sQGVBTThexnBSQFhdBlQoGAWKaVVhUE79sQKe3ikVZRXjZbewdIxTgHU8N4TMFjITHrAvIC2tmcIKO6nWFa2qw1mxOelb7rkregF9nxAaWD6ZE5L1PfCYUoz9JfjU6OqtNSVHN2HNjh80fyHmgBCnMfOk4wQrSgUL3ByiNegqTLxBxE%2BLgIi0Cd%2BIiVMWpbUOllluZKWn%2B%2FDO%2Fx1JYHGTZ%2FpSbJqqLh2eqXCXNvMYKhKGpg%3D&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47UWS26F442%2F20260423%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260423T023626Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=4adb57a6b46fd687733fabbc6214833d678c15a7ccc74f5535e5faf73d9a1eec\" 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=IQoJb3JpZ2luX2VjEJL%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJHMEUCIQDV18Oo7MTeIGlI5dOtfYcPgJihgt6FDR1N7k2Re3pOoQIgd2au0VvJR22CPbJITF8dyTwlJfvChE0kGUTSbQ9FdjQquAUIWxAFGgwyNzM1NzAxOTU0MzMiDNQweSErN9xBSEbB6CqVBQD9AWHl7ZavPNgiVYtx9UVNeFZ0V1sniRReACfzN%2Bix%2BeLQPFgM9r5oBgxIByyK2%2FTEKrFL45pXQ%2BuFznivv814j87KiRGsi79Eimtr5YMJjHT3q53I4epkPxZk9NcnZhIlqRuBIkiGbwYZ5aE7f52v9Nema6Q9WOgUp5D0zPYKGR%2F7ImtadOlKuZr80EWNJsVijrX%2BIpc5K5p6HDTNL8fMOaIn1OugbrHam7RaE3%2BVPHNQM8aDNttXQUeoXw6%2Bh1EFBombaIzaSkbe8S%2FWO4KtMtas92g%2BsM9DBvq6Syb5XCVVOCy3F3xYXXN9A%2Fhl9vZL5ekMqWYZ2PyqHx2ABklYwcFep0C%2Br7PdO9ej6ktmx4sCHe1YRNM96tLVEbkmMt4rF%2BbZ%2Bwr3kS4SZidjECc8f%2F5D4IAdCk%2FnUG%2BwMXofrDurtYUiNKDYWmYBu2OYWWHTAezIpW1fUGOZ5fNYAg7JQN5Z2oZSREdDzDUCs%2BNvDb7SzsqlWZsA11sXrhz%2FFK9MBKeTY0XH7So6E1Vu%2BNxj2s%2BqiadUFabL8gSKj8iLCgl6scoYx2h8L4ClZ416e4YOGRikVH3EhyYO2skfqVD%2BI60Q3jZGa7FEpDk6jlvH6abFLw4YdDw9R%2Bthm1hpirjzq38490VECXvOfiSWLF19PbRn6N9VjRdEQ4Bi9qCCx2IvLVnmEOSduLJaENzkSQmOd5jhBmtlTGctlJM5OXr0fr1pV%2B9lKSYd%2FOSQxyFriizl5dH2xUshr1%2B7XEupvHo%2B0zaJsU6jLY4lyQXbPqRPEC2nnS6fphoXf7ovNHNOTMDuM7Uvlp5xBu7QHj541%2FZnBwhHHW8aMBqGg6kf%2FBjQ%2FdoCWjHh5M85dA2TTUntR%2BeU7YYww%2FGlzwY6sQGVBTThexnBSQFhdBlQoGAWKaVVhUE79sQKe3ikVZRXjZbewdIxTgHU8N4TMFjITHrAvIC2tmcIKO6nWFa2qw1mxOelb7rkregF9nxAaWD6ZE5L1PfCYUoz9JfjU6OqtNSVHN2HNjh80fyHmgBCnMfOk4wQrSgUL3ByiNegqTLxBxE%2BLgIi0Cd%2BIiVMWpbUOllluZKWn%2B%2FDO%2Fx1JYHGTZ%2FpSbJqqLh2eqXCXNvMYKhKGpg%3D&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47UWS26F442%2F20260423%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260423T023626Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=4adb57a6b46fd687733fabbc6214833d678c15a7ccc74f5535e5faf73d9a1eec 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=IQoJb3JpZ2luX2VjEJL%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJHMEUCIQDV18Oo7MTeIGlI5dOtfYcPgJihgt6FDR1N7k2Re3pOoQIgd2au0VvJR22CPbJITF8dyTwlJfvChE0kGUTSbQ9FdjQquAUIWxAFGgwyNzM1NzAxOTU0MzMiDNQweSErN9xBSEbB6CqVBQD9AWHl7ZavPNgiVYtx9UVNeFZ0V1sniRReACfzN%2Bix%2BeLQPFgM9r5oBgxIByyK2%2FTEKrFL45pXQ%2BuFznivv814j87KiRGsi79Eimtr5YMJjHT3q53I4epkPxZk9NcnZhIlqRuBIkiGbwYZ5aE7f52v9Nema6Q9WOgUp5D0zPYKGR%2F7ImtadOlKuZr80EWNJsVijrX%2BIpc5K5p6HDTNL8fMOaIn1OugbrHam7RaE3%2BVPHNQM8aDNttXQUeoXw6%2Bh1EFBombaIzaSkbe8S%2FWO4KtMtas92g%2BsM9DBvq6Syb5XCVVOCy3F3xYXXN9A%2Fhl9vZL5ekMqWYZ2PyqHx2ABklYwcFep0C%2Br7PdO9ej6ktmx4sCHe1YRNM96tLVEbkmMt4rF%2BbZ%2Bwr3kS4SZidjECc8f%2F5D4IAdCk%2FnUG%2BwMXofrDurtYUiNKDYWmYBu2OYWWHTAezIpW1fUGOZ5fNYAg7JQN5Z2oZSREdDzDUCs%2BNvDb7SzsqlWZsA11sXrhz%2FFK9MBKeTY0XH7So6E1Vu%2BNxj2s%2BqiadUFabL8gSKj8iLCgl6scoYx2h8L4ClZ416e4YOGRikVH3EhyYO2skfqVD%2BI60Q3jZGa7FEpDk6jlvH6abFLw4YdDw9R%2Bthm1hpirjzq38490VECXvOfiSWLF19PbRn6N9VjRdEQ4Bi9qCCx2IvLVnmEOSduLJaENzkSQmOd5jhBmtlTGctlJM5OXr0fr1pV%2B9lKSYd%2FOSQxyFriizl5dH2xUshr1%2B7XEupvHo%2B0zaJsU6jLY4lyQXbPqRPEC2nnS6fphoXf7ovNHNOTMDuM7Uvlp5xBu7QHj541%2FZnBwhHHW8aMBqGg6kf%2FBjQ%2FdoCWjHh5M85dA2TTUntR%2BeU7YYww%2FGlzwY6sQGVBTThexnBSQFhdBlQoGAWKaVVhUE79sQKe3ikVZRXjZbewdIxTgHU8N4TMFjITHrAvIC2tmcIKO6nWFa2qw1mxOelb7rkregF9nxAaWD6ZE5L1PfCYUoz9JfjU6OqtNSVHN2HNjh80fyHmgBCnMfOk4wQrSgUL3ByiNegqTLxBxE%2BLgIi0Cd%2BIiVMWpbUOllluZKWn%2B%2FDO%2Fx1JYHGTZ%2FpSbJqqLh2eqXCXNvMYKhKGpg%3D&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47UWS26F442%2F20260423%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260423T023626Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=0918bd415156c888e307fa00109a45ce8a839fd330b7ebb33113d53475aa05d3 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=IQoJb3JpZ2luX2VjEJL%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJHMEUCIQDV18Oo7MTeIGlI5dOtfYcPgJihgt6FDR1N7k2Re3pOoQIgd2au0VvJR22CPbJITF8dyTwlJfvChE0kGUTSbQ9FdjQquAUIWxAFGgwyNzM1NzAxOTU0MzMiDNQweSErN9xBSEbB6CqVBQD9AWHl7ZavPNgiVYtx9UVNeFZ0V1sniRReACfzN%2Bix%2BeLQPFgM9r5oBgxIByyK2%2FTEKrFL45pXQ%2BuFznivv814j87KiRGsi79Eimtr5YMJjHT3q53I4epkPxZk9NcnZhIlqRuBIkiGbwYZ5aE7f52v9Nema6Q9WOgUp5D0zPYKGR%2F7ImtadOlKuZr80EWNJsVijrX%2BIpc5K5p6HDTNL8fMOaIn1OugbrHam7RaE3%2BVPHNQM8aDNttXQUeoXw6%2Bh1EFBombaIzaSkbe8S%2FWO4KtMtas92g%2BsM9DBvq6Syb5XCVVOCy3F3xYXXN9A%2Fhl9vZL5ekMqWYZ2PyqHx2ABklYwcFep0C%2Br7PdO9ej6ktmx4sCHe1YRNM96tLVEbkmMt4rF%2BbZ%2Bwr3kS4SZidjECc8f%2F5D4IAdCk%2FnUG%2BwMXofrDurtYUiNKDYWmYBu2OYWWHTAezIpW1fUGOZ5fNYAg7JQN5Z2oZSREdDzDUCs%2BNvDb7SzsqlWZsA11sXrhz%2FFK9MBKeTY0XH7So6E1Vu%2BNxj2s%2BqiadUFabL8gSKj8iLCgl6scoYx2h8L4ClZ416e4YOGRikVH3EhyYO2skfqVD%2BI60Q3jZGa7FEpDk6jlvH6abFLw4YdDw9R%2Bthm1hpirjzq38490VECXvOfiSWLF19PbRn6N9VjRdEQ4Bi9qCCx2IvLVnmEOSduLJaENzkSQmOd5jhBmtlTGctlJM5OXr0fr1pV%2B9lKSYd%2FOSQxyFriizl5dH2xUshr1%2B7XEupvHo%2B0zaJsU6jLY4lyQXbPqRPEC2nnS6fphoXf7ovNHNOTMDuM7Uvlp5xBu7QHj541%2FZnBwhHHW8aMBqGg6kf%2FBjQ%2FdoCWjHh5M85dA2TTUntR%2BeU7YYww%2FGlzwY6sQGVBTThexnBSQFhdBlQoGAWKaVVhUE79sQKe3ikVZRXjZbewdIxTgHU8N4TMFjITHrAvIC2tmcIKO6nWFa2qw1mxOelb7rkregF9nxAaWD6ZE5L1PfCYUoz9JfjU6OqtNSVHN2HNjh80fyHmgBCnMfOk4wQrSgUL3ByiNegqTLxBxE%2BLgIi0Cd%2BIiVMWpbUOllluZKWn%2B%2FDO%2Fx1JYHGTZ%2FpSbJqqLh2eqXCXNvMYKhKGpg%3D&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47UWS26F442%2F20260423%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260423T023626Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=0918bd415156c888e307fa00109a45ce8a839fd330b7ebb33113d53475aa05d3\" 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=IQoJb3JpZ2luX2VjEJL%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJHMEUCIQDV18Oo7MTeIGlI5dOtfYcPgJihgt6FDR1N7k2Re3pOoQIgd2au0VvJR22CPbJITF8dyTwlJfvChE0kGUTSbQ9FdjQquAUIWxAFGgwyNzM1NzAxOTU0MzMiDNQweSErN9xBSEbB6CqVBQD9AWHl7ZavPNgiVYtx9UVNeFZ0V1sniRReACfzN%2Bix%2BeLQPFgM9r5oBgxIByyK2%2FTEKrFL45pXQ%2BuFznivv814j87KiRGsi79Eimtr5YMJjHT3q53I4epkPxZk9NcnZhIlqRuBIkiGbwYZ5aE7f52v9Nema6Q9WOgUp5D0zPYKGR%2F7ImtadOlKuZr80EWNJsVijrX%2BIpc5K5p6HDTNL8fMOaIn1OugbrHam7RaE3%2BVPHNQM8aDNttXQUeoXw6%2Bh1EFBombaIzaSkbe8S%2FWO4KtMtas92g%2BsM9DBvq6Syb5XCVVOCy3F3xYXXN9A%2Fhl9vZL5ekMqWYZ2PyqHx2ABklYwcFep0C%2Br7PdO9ej6ktmx4sCHe1YRNM96tLVEbkmMt4rF%2BbZ%2Bwr3kS4SZidjECc8f%2F5D4IAdCk%2FnUG%2BwMXofrDurtYUiNKDYWmYBu2OYWWHTAezIpW1fUGOZ5fNYAg7JQN5Z2oZSREdDzDUCs%2BNvDb7SzsqlWZsA11sXrhz%2FFK9MBKeTY0XH7So6E1Vu%2BNxj2s%2BqiadUFabL8gSKj8iLCgl6scoYx2h8L4ClZ416e4YOGRikVH3EhyYO2skfqVD%2BI60Q3jZGa7FEpDk6jlvH6abFLw4YdDw9R%2Bthm1hpirjzq38490VECXvOfiSWLF19PbRn6N9VjRdEQ4Bi9qCCx2IvLVnmEOSduLJaENzkSQmOd5jhBmtlTGctlJM5OXr0fr1pV%2B9lKSYd%2FOSQxyFriizl5dH2xUshr1%2B7XEupvHo%2B0zaJsU6jLY4lyQXbPqRPEC2nnS6fphoXf7ovNHNOTMDuM7Uvlp5xBu7QHj541%2FZnBwhHHW8aMBqGg6kf%2FBjQ%2FdoCWjHh5M85dA2TTUntR%2BeU7YYww%2FGlzwY6sQGVBTThexnBSQFhdBlQoGAWKaVVhUE79sQKe3ikVZRXjZbewdIxTgHU8N4TMFjITHrAvIC2tmcIKO6nWFa2qw1mxOelb7rkregF9nxAaWD6ZE5L1PfCYUoz9JfjU6OqtNSVHN2HNjh80fyHmgBCnMfOk4wQrSgUL3ByiNegqTLxBxE%2BLgIi0Cd%2BIiVMWpbUOllluZKWn%2B%2FDO%2Fx1JYHGTZ%2FpSbJqqLh2eqXCXNvMYKhKGpg%3D&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47UWS26F442%2F20260423%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260423T023626Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=907d7737075b946474e888d20217ca41cc8e02838c05d6e28495b1d638ac2913\" 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=IQoJb3JpZ2luX2VjEJL%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJHMEUCIQDV18Oo7MTeIGlI5dOtfYcPgJihgt6FDR1N7k2Re3pOoQIgd2au0VvJR22CPbJITF8dyTwlJfvChE0kGUTSbQ9FdjQquAUIWxAFGgwyNzM1NzAxOTU0MzMiDNQweSErN9xBSEbB6CqVBQD9AWHl7ZavPNgiVYtx9UVNeFZ0V1sniRReACfzN%2Bix%2BeLQPFgM9r5oBgxIByyK2%2FTEKrFL45pXQ%2BuFznivv814j87KiRGsi79Eimtr5YMJjHT3q53I4epkPxZk9NcnZhIlqRuBIkiGbwYZ5aE7f52v9Nema6Q9WOgUp5D0zPYKGR%2F7ImtadOlKuZr80EWNJsVijrX%2BIpc5K5p6HDTNL8fMOaIn1OugbrHam7RaE3%2BVPHNQM8aDNttXQUeoXw6%2Bh1EFBombaIzaSkbe8S%2FWO4KtMtas92g%2BsM9DBvq6Syb5XCVVOCy3F3xYXXN9A%2Fhl9vZL5ekMqWYZ2PyqHx2ABklYwcFep0C%2Br7PdO9ej6ktmx4sCHe1YRNM96tLVEbkmMt4rF%2BbZ%2Bwr3kS4SZidjECc8f%2F5D4IAdCk%2FnUG%2BwMXofrDurtYUiNKDYWmYBu2OYWWHTAezIpW1fUGOZ5fNYAg7JQN5Z2oZSREdDzDUCs%2BNvDb7SzsqlWZsA11sXrhz%2FFK9MBKeTY0XH7So6E1Vu%2BNxj2s%2BqiadUFabL8gSKj8iLCgl6scoYx2h8L4ClZ416e4YOGRikVH3EhyYO2skfqVD%2BI60Q3jZGa7FEpDk6jlvH6abFLw4YdDw9R%2Bthm1hpirjzq38490VECXvOfiSWLF19PbRn6N9VjRdEQ4Bi9qCCx2IvLVnmEOSduLJaENzkSQmOd5jhBmtlTGctlJM5OXr0fr1pV%2B9lKSYd%2FOSQxyFriizl5dH2xUshr1%2B7XEupvHo%2B0zaJsU6jLY4lyQXbPqRPEC2nnS6fphoXf7ovNHNOTMDuM7Uvlp5xBu7QHj541%2FZnBwhHHW8aMBqGg6kf%2FBjQ%2FdoCWjHh5M85dA2TTUntR%2BeU7YYww%2FGlzwY6sQGVBTThexnBSQFhdBlQoGAWKaVVhUE79sQKe3ikVZRXjZbewdIxTgHU8N4TMFjITHrAvIC2tmcIKO6nWFa2qw1mxOelb7rkregF9nxAaWD6ZE5L1PfCYUoz9JfjU6OqtNSVHN2HNjh80fyHmgBCnMfOk4wQrSgUL3ByiNegqTLxBxE%2BLgIi0Cd%2BIiVMWpbUOllluZKWn%2B%2FDO%2Fx1JYHGTZ%2FpSbJqqLh2eqXCXNvMYKhKGpg%3D&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47UWS26F442%2F20260423%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260423T023626Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=907d7737075b946474e888d20217ca41cc8e02838c05d6e28495b1d638ac2913 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=IQoJb3JpZ2luX2VjEJL%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJHMEUCIQDV18Oo7MTeIGlI5dOtfYcPgJihgt6FDR1N7k2Re3pOoQIgd2au0VvJR22CPbJITF8dyTwlJfvChE0kGUTSbQ9FdjQquAUIWxAFGgwyNzM1NzAxOTU0MzMiDNQweSErN9xBSEbB6CqVBQD9AWHl7ZavPNgiVYtx9UVNeFZ0V1sniRReACfzN%2Bix%2BeLQPFgM9r5oBgxIByyK2%2FTEKrFL45pXQ%2BuFznivv814j87KiRGsi79Eimtr5YMJjHT3q53I4epkPxZk9NcnZhIlqRuBIkiGbwYZ5aE7f52v9Nema6Q9WOgUp5D0zPYKGR%2F7ImtadOlKuZr80EWNJsVijrX%2BIpc5K5p6HDTNL8fMOaIn1OugbrHam7RaE3%2BVPHNQM8aDNttXQUeoXw6%2Bh1EFBombaIzaSkbe8S%2FWO4KtMtas92g%2BsM9DBvq6Syb5XCVVOCy3F3xYXXN9A%2Fhl9vZL5ekMqWYZ2PyqHx2ABklYwcFep0C%2Br7PdO9ej6ktmx4sCHe1YRNM96tLVEbkmMt4rF%2BbZ%2Bwr3kS4SZidjECc8f%2F5D4IAdCk%2FnUG%2BwMXofrDurtYUiNKDYWmYBu2OYWWHTAezIpW1fUGOZ5fNYAg7JQN5Z2oZSREdDzDUCs%2BNvDb7SzsqlWZsA11sXrhz%2FFK9MBKeTY0XH7So6E1Vu%2BNxj2s%2BqiadUFabL8gSKj8iLCgl6scoYx2h8L4ClZ416e4YOGRikVH3EhyYO2skfqVD%2BI60Q3jZGa7FEpDk6jlvH6abFLw4YdDw9R%2Bthm1hpirjzq38490VECXvOfiSWLF19PbRn6N9VjRdEQ4Bi9qCCx2IvLVnmEOSduLJaENzkSQmOd5jhBmtlTGctlJM5OXr0fr1pV%2B9lKSYd%2FOSQxyFriizl5dH2xUshr1%2B7XEupvHo%2B0zaJsU6jLY4lyQXbPqRPEC2nnS6fphoXf7ovNHNOTMDuM7Uvlp5xBu7QHj541%2FZnBwhHHW8aMBqGg6kf%2FBjQ%2FdoCWjHh5M85dA2TTUntR%2BeU7YYww%2FGlzwY6sQGVBTThexnBSQFhdBlQoGAWKaVVhUE79sQKe3ikVZRXjZbewdIxTgHU8N4TMFjITHrAvIC2tmcIKO6nWFa2qw1mxOelb7rkregF9nxAaWD6ZE5L1PfCYUoz9JfjU6OqtNSVHN2HNjh80fyHmgBCnMfOk4wQrSgUL3ByiNegqTLxBxE%2BLgIi0Cd%2BIiVMWpbUOllluZKWn%2B%2FDO%2Fx1JYHGTZ%2FpSbJqqLh2eqXCXNvMYKhKGpg%3D&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47UWS26F442%2F20260423%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260423T023626Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=f208b82b1067bb4ddc05da37e5cf60067e68b0423764f9df85334d7d755c5bc9 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=IQoJb3JpZ2luX2VjEJL%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJHMEUCIQDV18Oo7MTeIGlI5dOtfYcPgJihgt6FDR1N7k2Re3pOoQIgd2au0VvJR22CPbJITF8dyTwlJfvChE0kGUTSbQ9FdjQquAUIWxAFGgwyNzM1NzAxOTU0MzMiDNQweSErN9xBSEbB6CqVBQD9AWHl7ZavPNgiVYtx9UVNeFZ0V1sniRReACfzN%2Bix%2BeLQPFgM9r5oBgxIByyK2%2FTEKrFL45pXQ%2BuFznivv814j87KiRGsi79Eimtr5YMJjHT3q53I4epkPxZk9NcnZhIlqRuBIkiGbwYZ5aE7f52v9Nema6Q9WOgUp5D0zPYKGR%2F7ImtadOlKuZr80EWNJsVijrX%2BIpc5K5p6HDTNL8fMOaIn1OugbrHam7RaE3%2BVPHNQM8aDNttXQUeoXw6%2Bh1EFBombaIzaSkbe8S%2FWO4KtMtas92g%2BsM9DBvq6Syb5XCVVOCy3F3xYXXN9A%2Fhl9vZL5ekMqWYZ2PyqHx2ABklYwcFep0C%2Br7PdO9ej6ktmx4sCHe1YRNM96tLVEbkmMt4rF%2BbZ%2Bwr3kS4SZidjECc8f%2F5D4IAdCk%2FnUG%2BwMXofrDurtYUiNKDYWmYBu2OYWWHTAezIpW1fUGOZ5fNYAg7JQN5Z2oZSREdDzDUCs%2BNvDb7SzsqlWZsA11sXrhz%2FFK9MBKeTY0XH7So6E1Vu%2BNxj2s%2BqiadUFabL8gSKj8iLCgl6scoYx2h8L4ClZ416e4YOGRikVH3EhyYO2skfqVD%2BI60Q3jZGa7FEpDk6jlvH6abFLw4YdDw9R%2Bthm1hpirjzq38490VECXvOfiSWLF19PbRn6N9VjRdEQ4Bi9qCCx2IvLVnmEOSduLJaENzkSQmOd5jhBmtlTGctlJM5OXr0fr1pV%2B9lKSYd%2FOSQxyFriizl5dH2xUshr1%2B7XEupvHo%2B0zaJsU6jLY4lyQXbPqRPEC2nnS6fphoXf7ovNHNOTMDuM7Uvlp5xBu7QHj541%2FZnBwhHHW8aMBqGg6kf%2FBjQ%2FdoCWjHh5M85dA2TTUntR%2BeU7YYww%2FGlzwY6sQGVBTThexnBSQFhdBlQoGAWKaVVhUE79sQKe3ikVZRXjZbewdIxTgHU8N4TMFjITHrAvIC2tmcIKO6nWFa2qw1mxOelb7rkregF9nxAaWD6ZE5L1PfCYUoz9JfjU6OqtNSVHN2HNjh80fyHmgBCnMfOk4wQrSgUL3ByiNegqTLxBxE%2BLgIi0Cd%2BIiVMWpbUOllluZKWn%2B%2FDO%2Fx1JYHGTZ%2FpSbJqqLh2eqXCXNvMYKhKGpg%3D&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47UWS26F442%2F20260423%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260423T023626Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=f208b82b1067bb4ddc05da37e5cf60067e68b0423764f9df85334d7d755c5bc9\" 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=IQoJb3JpZ2luX2VjEJL%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJHMEUCIQDV18Oo7MTeIGlI5dOtfYcPgJihgt6FDR1N7k2Re3pOoQIgd2au0VvJR22CPbJITF8dyTwlJfvChE0kGUTSbQ9FdjQquAUIWxAFGgwyNzM1NzAxOTU0MzMiDNQweSErN9xBSEbB6CqVBQD9AWHl7ZavPNgiVYtx9UVNeFZ0V1sniRReACfzN%2Bix%2BeLQPFgM9r5oBgxIByyK2%2FTEKrFL45pXQ%2BuFznivv814j87KiRGsi79Eimtr5YMJjHT3q53I4epkPxZk9NcnZhIlqRuBIkiGbwYZ5aE7f52v9Nema6Q9WOgUp5D0zPYKGR%2F7ImtadOlKuZr80EWNJsVijrX%2BIpc5K5p6HDTNL8fMOaIn1OugbrHam7RaE3%2BVPHNQM8aDNttXQUeoXw6%2Bh1EFBombaIzaSkbe8S%2FWO4KtMtas92g%2BsM9DBvq6Syb5XCVVOCy3F3xYXXN9A%2Fhl9vZL5ekMqWYZ2PyqHx2ABklYwcFep0C%2Br7PdO9ej6ktmx4sCHe1YRNM96tLVEbkmMt4rF%2BbZ%2Bwr3kS4SZidjECc8f%2F5D4IAdCk%2FnUG%2BwMXofrDurtYUiNKDYWmYBu2OYWWHTAezIpW1fUGOZ5fNYAg7JQN5Z2oZSREdDzDUCs%2BNvDb7SzsqlWZsA11sXrhz%2FFK9MBKeTY0XH7So6E1Vu%2BNxj2s%2BqiadUFabL8gSKj8iLCgl6scoYx2h8L4ClZ416e4YOGRikVH3EhyYO2skfqVD%2BI60Q3jZGa7FEpDk6jlvH6abFLw4YdDw9R%2Bthm1hpirjzq38490VECXvOfiSWLF19PbRn6N9VjRdEQ4Bi9qCCx2IvLVnmEOSduLJaENzkSQmOd5jhBmtlTGctlJM5OXr0fr1pV%2B9lKSYd%2FOSQxyFriizl5dH2xUshr1%2B7XEupvHo%2B0zaJsU6jLY4lyQXbPqRPEC2nnS6fphoXf7ovNHNOTMDuM7Uvlp5xBu7QHj541%2FZnBwhHHW8aMBqGg6kf%2FBjQ%2FdoCWjHh5M85dA2TTUntR%2BeU7YYww%2FGlzwY6sQGVBTThexnBSQFhdBlQoGAWKaVVhUE79sQKe3ikVZRXjZbewdIxTgHU8N4TMFjITHrAvIC2tmcIKO6nWFa2qw1mxOelb7rkregF9nxAaWD6ZE5L1PfCYUoz9JfjU6OqtNSVHN2HNjh80fyHmgBCnMfOk4wQrSgUL3ByiNegqTLxBxE%2BLgIi0Cd%2BIiVMWpbUOllluZKWn%2B%2FDO%2Fx1JYHGTZ%2FpSbJqqLh2eqXCXNvMYKhKGpg%3D&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47UWS26F442%2F20260423%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260423T023626Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=37417d0ce132271fc65c94e9358be836b386192040dfd0182498874331edec8d\" 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=IQoJb3JpZ2luX2VjEJL%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJHMEUCIQDV18Oo7MTeIGlI5dOtfYcPgJihgt6FDR1N7k2Re3pOoQIgd2au0VvJR22CPbJITF8dyTwlJfvChE0kGUTSbQ9FdjQquAUIWxAFGgwyNzM1NzAxOTU0MzMiDNQweSErN9xBSEbB6CqVBQD9AWHl7ZavPNgiVYtx9UVNeFZ0V1sniRReACfzN%2Bix%2BeLQPFgM9r5oBgxIByyK2%2FTEKrFL45pXQ%2BuFznivv814j87KiRGsi79Eimtr5YMJjHT3q53I4epkPxZk9NcnZhIlqRuBIkiGbwYZ5aE7f52v9Nema6Q9WOgUp5D0zPYKGR%2F7ImtadOlKuZr80EWNJsVijrX%2BIpc5K5p6HDTNL8fMOaIn1OugbrHam7RaE3%2BVPHNQM8aDNttXQUeoXw6%2Bh1EFBombaIzaSkbe8S%2FWO4KtMtas92g%2BsM9DBvq6Syb5XCVVOCy3F3xYXXN9A%2Fhl9vZL5ekMqWYZ2PyqHx2ABklYwcFep0C%2Br7PdO9ej6ktmx4sCHe1YRNM96tLVEbkmMt4rF%2BbZ%2Bwr3kS4SZidjECc8f%2F5D4IAdCk%2FnUG%2BwMXofrDurtYUiNKDYWmYBu2OYWWHTAezIpW1fUGOZ5fNYAg7JQN5Z2oZSREdDzDUCs%2BNvDb7SzsqlWZsA11sXrhz%2FFK9MBKeTY0XH7So6E1Vu%2BNxj2s%2BqiadUFabL8gSKj8iLCgl6scoYx2h8L4ClZ416e4YOGRikVH3EhyYO2skfqVD%2BI60Q3jZGa7FEpDk6jlvH6abFLw4YdDw9R%2Bthm1hpirjzq38490VECXvOfiSWLF19PbRn6N9VjRdEQ4Bi9qCCx2IvLVnmEOSduLJaENzkSQmOd5jhBmtlTGctlJM5OXr0fr1pV%2B9lKSYd%2FOSQxyFriizl5dH2xUshr1%2B7XEupvHo%2B0zaJsU6jLY4lyQXbPqRPEC2nnS6fphoXf7ovNHNOTMDuM7Uvlp5xBu7QHj541%2FZnBwhHHW8aMBqGg6kf%2FBjQ%2FdoCWjHh5M85dA2TTUntR%2BeU7YYww%2FGlzwY6sQGVBTThexnBSQFhdBlQoGAWKaVVhUE79sQKe3ikVZRXjZbewdIxTgHU8N4TMFjITHrAvIC2tmcIKO6nWFa2qw1mxOelb7rkregF9nxAaWD6ZE5L1PfCYUoz9JfjU6OqtNSVHN2HNjh80fyHmgBCnMfOk4wQrSgUL3ByiNegqTLxBxE%2BLgIi0Cd%2BIiVMWpbUOllluZKWn%2B%2FDO%2Fx1JYHGTZ%2FpSbJqqLh2eqXCXNvMYKhKGpg%3D&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47UWS26F442%2F20260423%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260423T023626Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=37417d0ce132271fc65c94e9358be836b386192040dfd0182498874331edec8d 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=IQoJb3JpZ2luX2VjEJL%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJHMEUCIQDV18Oo7MTeIGlI5dOtfYcPgJihgt6FDR1N7k2Re3pOoQIgd2au0VvJR22CPbJITF8dyTwlJfvChE0kGUTSbQ9FdjQquAUIWxAFGgwyNzM1NzAxOTU0MzMiDNQweSErN9xBSEbB6CqVBQD9AWHl7ZavPNgiVYtx9UVNeFZ0V1sniRReACfzN%2Bix%2BeLQPFgM9r5oBgxIByyK2%2FTEKrFL45pXQ%2BuFznivv814j87KiRGsi79Eimtr5YMJjHT3q53I4epkPxZk9NcnZhIlqRuBIkiGbwYZ5aE7f52v9Nema6Q9WOgUp5D0zPYKGR%2F7ImtadOlKuZr80EWNJsVijrX%2BIpc5K5p6HDTNL8fMOaIn1OugbrHam7RaE3%2BVPHNQM8aDNttXQUeoXw6%2Bh1EFBombaIzaSkbe8S%2FWO4KtMtas92g%2BsM9DBvq6Syb5XCVVOCy3F3xYXXN9A%2Fhl9vZL5ekMqWYZ2PyqHx2ABklYwcFep0C%2Br7PdO9ej6ktmx4sCHe1YRNM96tLVEbkmMt4rF%2BbZ%2Bwr3kS4SZidjECc8f%2F5D4IAdCk%2FnUG%2BwMXofrDurtYUiNKDYWmYBu2OYWWHTAezIpW1fUGOZ5fNYAg7JQN5Z2oZSREdDzDUCs%2BNvDb7SzsqlWZsA11sXrhz%2FFK9MBKeTY0XH7So6E1Vu%2BNxj2s%2BqiadUFabL8gSKj8iLCgl6scoYx2h8L4ClZ416e4YOGRikVH3EhyYO2skfqVD%2BI60Q3jZGa7FEpDk6jlvH6abFLw4YdDw9R%2Bthm1hpirjzq38490VECXvOfiSWLF19PbRn6N9VjRdEQ4Bi9qCCx2IvLVnmEOSduLJaENzkSQmOd5jhBmtlTGctlJM5OXr0fr1pV%2B9lKSYd%2FOSQxyFriizl5dH2xUshr1%2B7XEupvHo%2B0zaJsU6jLY4lyQXbPqRPEC2nnS6fphoXf7ovNHNOTMDuM7Uvlp5xBu7QHj541%2FZnBwhHHW8aMBqGg6kf%2FBjQ%2FdoCWjHh5M85dA2TTUntR%2BeU7YYww%2FGlzwY6sQGVBTThexnBSQFhdBlQoGAWKaVVhUE79sQKe3ikVZRXjZbewdIxTgHU8N4TMFjITHrAvIC2tmcIKO6nWFa2qw1mxOelb7rkregF9nxAaWD6ZE5L1PfCYUoz9JfjU6OqtNSVHN2HNjh80fyHmgBCnMfOk4wQrSgUL3ByiNegqTLxBxE%2BLgIi0Cd%2BIiVMWpbUOllluZKWn%2B%2FDO%2Fx1JYHGTZ%2FpSbJqqLh2eqXCXNvMYKhKGpg%3D&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47UWS26F442%2F20260423%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260423T023626Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=edde8e710dc3dd815ab1ab6de558ced4438bcda2f66a622ba2a8ecd456e1d1b5 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=IQoJb3JpZ2luX2VjEJL%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJHMEUCIQDV18Oo7MTeIGlI5dOtfYcPgJihgt6FDR1N7k2Re3pOoQIgd2au0VvJR22CPbJITF8dyTwlJfvChE0kGUTSbQ9FdjQquAUIWxAFGgwyNzM1NzAxOTU0MzMiDNQweSErN9xBSEbB6CqVBQD9AWHl7ZavPNgiVYtx9UVNeFZ0V1sniRReACfzN%2Bix%2BeLQPFgM9r5oBgxIByyK2%2FTEKrFL45pXQ%2BuFznivv814j87KiRGsi79Eimtr5YMJjHT3q53I4epkPxZk9NcnZhIlqRuBIkiGbwYZ5aE7f52v9Nema6Q9WOgUp5D0zPYKGR%2F7ImtadOlKuZr80EWNJsVijrX%2BIpc5K5p6HDTNL8fMOaIn1OugbrHam7RaE3%2BVPHNQM8aDNttXQUeoXw6%2Bh1EFBombaIzaSkbe8S%2FWO4KtMtas92g%2BsM9DBvq6Syb5XCVVOCy3F3xYXXN9A%2Fhl9vZL5ekMqWYZ2PyqHx2ABklYwcFep0C%2Br7PdO9ej6ktmx4sCHe1YRNM96tLVEbkmMt4rF%2BbZ%2Bwr3kS4SZidjECc8f%2F5D4IAdCk%2FnUG%2BwMXofrDurtYUiNKDYWmYBu2OYWWHTAezIpW1fUGOZ5fNYAg7JQN5Z2oZSREdDzDUCs%2BNvDb7SzsqlWZsA11sXrhz%2FFK9MBKeTY0XH7So6E1Vu%2BNxj2s%2BqiadUFabL8gSKj8iLCgl6scoYx2h8L4ClZ416e4YOGRikVH3EhyYO2skfqVD%2BI60Q3jZGa7FEpDk6jlvH6abFLw4YdDw9R%2Bthm1hpirjzq38490VECXvOfiSWLF19PbRn6N9VjRdEQ4Bi9qCCx2IvLVnmEOSduLJaENzkSQmOd5jhBmtlTGctlJM5OXr0fr1pV%2B9lKSYd%2FOSQxyFriizl5dH2xUshr1%2B7XEupvHo%2B0zaJsU6jLY4lyQXbPqRPEC2nnS6fphoXf7ovNHNOTMDuM7Uvlp5xBu7QHj541%2FZnBwhHHW8aMBqGg6kf%2FBjQ%2FdoCWjHh5M85dA2TTUntR%2BeU7YYww%2FGlzwY6sQGVBTThexnBSQFhdBlQoGAWKaVVhUE79sQKe3ikVZRXjZbewdIxTgHU8N4TMFjITHrAvIC2tmcIKO6nWFa2qw1mxOelb7rkregF9nxAaWD6ZE5L1PfCYUoz9JfjU6OqtNSVHN2HNjh80fyHmgBCnMfOk4wQrSgUL3ByiNegqTLxBxE%2BLgIi0Cd%2BIiVMWpbUOllluZKWn%2B%2FDO%2Fx1JYHGTZ%2FpSbJqqLh2eqXCXNvMYKhKGpg%3D&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47UWS26F442%2F20260423%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260423T023626Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=edde8e710dc3dd815ab1ab6de558ced4438bcda2f66a622ba2a8ecd456e1d1b5\" 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=IQoJb3JpZ2luX2VjEJL%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJHMEUCIQDV18Oo7MTeIGlI5dOtfYcPgJihgt6FDR1N7k2Re3pOoQIgd2au0VvJR22CPbJITF8dyTwlJfvChE0kGUTSbQ9FdjQquAUIWxAFGgwyNzM1NzAxOTU0MzMiDNQweSErN9xBSEbB6CqVBQD9AWHl7ZavPNgiVYtx9UVNeFZ0V1sniRReACfzN%2Bix%2BeLQPFgM9r5oBgxIByyK2%2FTEKrFL45pXQ%2BuFznivv814j87KiRGsi79Eimtr5YMJjHT3q53I4epkPxZk9NcnZhIlqRuBIkiGbwYZ5aE7f52v9Nema6Q9WOgUp5D0zPYKGR%2F7ImtadOlKuZr80EWNJsVijrX%2BIpc5K5p6HDTNL8fMOaIn1OugbrHam7RaE3%2BVPHNQM8aDNttXQUeoXw6%2Bh1EFBombaIzaSkbe8S%2FWO4KtMtas92g%2BsM9DBvq6Syb5XCVVOCy3F3xYXXN9A%2Fhl9vZL5ekMqWYZ2PyqHx2ABklYwcFep0C%2Br7PdO9ej6ktmx4sCHe1YRNM96tLVEbkmMt4rF%2BbZ%2Bwr3kS4SZidjECc8f%2F5D4IAdCk%2FnUG%2BwMXofrDurtYUiNKDYWmYBu2OYWWHTAezIpW1fUGOZ5fNYAg7JQN5Z2oZSREdDzDUCs%2BNvDb7SzsqlWZsA11sXrhz%2FFK9MBKeTY0XH7So6E1Vu%2BNxj2s%2BqiadUFabL8gSKj8iLCgl6scoYx2h8L4ClZ416e4YOGRikVH3EhyYO2skfqVD%2BI60Q3jZGa7FEpDk6jlvH6abFLw4YdDw9R%2Bthm1hpirjzq38490VECXvOfiSWLF19PbRn6N9VjRdEQ4Bi9qCCx2IvLVnmEOSduLJaENzkSQmOd5jhBmtlTGctlJM5OXr0fr1pV%2B9lKSYd%2FOSQxyFriizl5dH2xUshr1%2B7XEupvHo%2B0zaJsU6jLY4lyQXbPqRPEC2nnS6fphoXf7ovNHNOTMDuM7Uvlp5xBu7QHj541%2FZnBwhHHW8aMBqGg6kf%2FBjQ%2FdoCWjHh5M85dA2TTUntR%2BeU7YYww%2FGlzwY6sQGVBTThexnBSQFhdBlQoGAWKaVVhUE79sQKe3ikVZRXjZbewdIxTgHU8N4TMFjITHrAvIC2tmcIKO6nWFa2qw1mxOelb7rkregF9nxAaWD6ZE5L1PfCYUoz9JfjU6OqtNSVHN2HNjh80fyHmgBCnMfOk4wQrSgUL3ByiNegqTLxBxE%2BLgIi0Cd%2BIiVMWpbUOllluZKWn%2B%2FDO%2Fx1JYHGTZ%2FpSbJqqLh2eqXCXNvMYKhKGpg%3D&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47UWS26F442%2F20260423%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260423T023626Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=a0440ff26b1d71eedbb75555c98465da3f3ce1b1d0dff6fb9f84c743801cd5bc\" 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=IQoJb3JpZ2luX2VjEJL%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJHMEUCIQDV18Oo7MTeIGlI5dOtfYcPgJihgt6FDR1N7k2Re3pOoQIgd2au0VvJR22CPbJITF8dyTwlJfvChE0kGUTSbQ9FdjQquAUIWxAFGgwyNzM1NzAxOTU0MzMiDNQweSErN9xBSEbB6CqVBQD9AWHl7ZavPNgiVYtx9UVNeFZ0V1sniRReACfzN%2Bix%2BeLQPFgM9r5oBgxIByyK2%2FTEKrFL45pXQ%2BuFznivv814j87KiRGsi79Eimtr5YMJjHT3q53I4epkPxZk9NcnZhIlqRuBIkiGbwYZ5aE7f52v9Nema6Q9WOgUp5D0zPYKGR%2F7ImtadOlKuZr80EWNJsVijrX%2BIpc5K5p6HDTNL8fMOaIn1OugbrHam7RaE3%2BVPHNQM8aDNttXQUeoXw6%2Bh1EFBombaIzaSkbe8S%2FWO4KtMtas92g%2BsM9DBvq6Syb5XCVVOCy3F3xYXXN9A%2Fhl9vZL5ekMqWYZ2PyqHx2ABklYwcFep0C%2Br7PdO9ej6ktmx4sCHe1YRNM96tLVEbkmMt4rF%2BbZ%2Bwr3kS4SZidjECc8f%2F5D4IAdCk%2FnUG%2BwMXofrDurtYUiNKDYWmYBu2OYWWHTAezIpW1fUGOZ5fNYAg7JQN5Z2oZSREdDzDUCs%2BNvDb7SzsqlWZsA11sXrhz%2FFK9MBKeTY0XH7So6E1Vu%2BNxj2s%2BqiadUFabL8gSKj8iLCgl6scoYx2h8L4ClZ416e4YOGRikVH3EhyYO2skfqVD%2BI60Q3jZGa7FEpDk6jlvH6abFLw4YdDw9R%2Bthm1hpirjzq38490VECXvOfiSWLF19PbRn6N9VjRdEQ4Bi9qCCx2IvLVnmEOSduLJaENzkSQmOd5jhBmtlTGctlJM5OXr0fr1pV%2B9lKSYd%2FOSQxyFriizl5dH2xUshr1%2B7XEupvHo%2B0zaJsU6jLY4lyQXbPqRPEC2nnS6fphoXf7ovNHNOTMDuM7Uvlp5xBu7QHj541%2FZnBwhHHW8aMBqGg6kf%2FBjQ%2FdoCWjHh5M85dA2TTUntR%2BeU7YYww%2FGlzwY6sQGVBTThexnBSQFhdBlQoGAWKaVVhUE79sQKe3ikVZRXjZbewdIxTgHU8N4TMFjITHrAvIC2tmcIKO6nWFa2qw1mxOelb7rkregF9nxAaWD6ZE5L1PfCYUoz9JfjU6OqtNSVHN2HNjh80fyHmgBCnMfOk4wQrSgUL3ByiNegqTLxBxE%2BLgIi0Cd%2BIiVMWpbUOllluZKWn%2B%2FDO%2Fx1JYHGTZ%2FpSbJqqLh2eqXCXNvMYKhKGpg%3D&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47UWS26F442%2F20260423%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260423T023626Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=a0440ff26b1d71eedbb75555c98465da3f3ce1b1d0dff6fb9f84c743801cd5bc 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=IQoJb3JpZ2luX2VjEJL%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJHMEUCIQDV18Oo7MTeIGlI5dOtfYcPgJihgt6FDR1N7k2Re3pOoQIgd2au0VvJR22CPbJITF8dyTwlJfvChE0kGUTSbQ9FdjQquAUIWxAFGgwyNzM1NzAxOTU0MzMiDNQweSErN9xBSEbB6CqVBQD9AWHl7ZavPNgiVYtx9UVNeFZ0V1sniRReACfzN%2Bix%2BeLQPFgM9r5oBgxIByyK2%2FTEKrFL45pXQ%2BuFznivv814j87KiRGsi79Eimtr5YMJjHT3q53I4epkPxZk9NcnZhIlqRuBIkiGbwYZ5aE7f52v9Nema6Q9WOgUp5D0zPYKGR%2F7ImtadOlKuZr80EWNJsVijrX%2BIpc5K5p6HDTNL8fMOaIn1OugbrHam7RaE3%2BVPHNQM8aDNttXQUeoXw6%2Bh1EFBombaIzaSkbe8S%2FWO4KtMtas92g%2BsM9DBvq6Syb5XCVVOCy3F3xYXXN9A%2Fhl9vZL5ekMqWYZ2PyqHx2ABklYwcFep0C%2Br7PdO9ej6ktmx4sCHe1YRNM96tLVEbkmMt4rF%2BbZ%2Bwr3kS4SZidjECc8f%2F5D4IAdCk%2FnUG%2BwMXofrDurtYUiNKDYWmYBu2OYWWHTAezIpW1fUGOZ5fNYAg7JQN5Z2oZSREdDzDUCs%2BNvDb7SzsqlWZsA11sXrhz%2FFK9MBKeTY0XH7So6E1Vu%2BNxj2s%2BqiadUFabL8gSKj8iLCgl6scoYx2h8L4ClZ416e4YOGRikVH3EhyYO2skfqVD%2BI60Q3jZGa7FEpDk6jlvH6abFLw4YdDw9R%2Bthm1hpirjzq38490VECXvOfiSWLF19PbRn6N9VjRdEQ4Bi9qCCx2IvLVnmEOSduLJaENzkSQmOd5jhBmtlTGctlJM5OXr0fr1pV%2B9lKSYd%2FOSQxyFriizl5dH2xUshr1%2B7XEupvHo%2B0zaJsU6jLY4lyQXbPqRPEC2nnS6fphoXf7ovNHNOTMDuM7Uvlp5xBu7QHj541%2FZnBwhHHW8aMBqGg6kf%2FBjQ%2FdoCWjHh5M85dA2TTUntR%2BeU7YYww%2FGlzwY6sQGVBTThexnBSQFhdBlQoGAWKaVVhUE79sQKe3ikVZRXjZbewdIxTgHU8N4TMFjITHrAvIC2tmcIKO6nWFa2qw1mxOelb7rkregF9nxAaWD6ZE5L1PfCYUoz9JfjU6OqtNSVHN2HNjh80fyHmgBCnMfOk4wQrSgUL3ByiNegqTLxBxE%2BLgIi0Cd%2BIiVMWpbUOllluZKWn%2B%2FDO%2Fx1JYHGTZ%2FpSbJqqLh2eqXCXNvMYKhKGpg%3D&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47UWS26F442%2F20260423%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260423T023626Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=8cc203bb3af2da1f3166e4be2c85e895b8fdbb0a674ae2d1dbc9566318868e44 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=IQoJb3JpZ2luX2VjEJL%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJHMEUCIQDV18Oo7MTeIGlI5dOtfYcPgJihgt6FDR1N7k2Re3pOoQIgd2au0VvJR22CPbJITF8dyTwlJfvChE0kGUTSbQ9FdjQquAUIWxAFGgwyNzM1NzAxOTU0MzMiDNQweSErN9xBSEbB6CqVBQD9AWHl7ZavPNgiVYtx9UVNeFZ0V1sniRReACfzN%2Bix%2BeLQPFgM9r5oBgxIByyK2%2FTEKrFL45pXQ%2BuFznivv814j87KiRGsi79Eimtr5YMJjHT3q53I4epkPxZk9NcnZhIlqRuBIkiGbwYZ5aE7f52v9Nema6Q9WOgUp5D0zPYKGR%2F7ImtadOlKuZr80EWNJsVijrX%2BIpc5K5p6HDTNL8fMOaIn1OugbrHam7RaE3%2BVPHNQM8aDNttXQUeoXw6%2Bh1EFBombaIzaSkbe8S%2FWO4KtMtas92g%2BsM9DBvq6Syb5XCVVOCy3F3xYXXN9A%2Fhl9vZL5ekMqWYZ2PyqHx2ABklYwcFep0C%2Br7PdO9ej6ktmx4sCHe1YRNM96tLVEbkmMt4rF%2BbZ%2Bwr3kS4SZidjECc8f%2F5D4IAdCk%2FnUG%2BwMXofrDurtYUiNKDYWmYBu2OYWWHTAezIpW1fUGOZ5fNYAg7JQN5Z2oZSREdDzDUCs%2BNvDb7SzsqlWZsA11sXrhz%2FFK9MBKeTY0XH7So6E1Vu%2BNxj2s%2BqiadUFabL8gSKj8iLCgl6scoYx2h8L4ClZ416e4YOGRikVH3EhyYO2skfqVD%2BI60Q3jZGa7FEpDk6jlvH6abFLw4YdDw9R%2Bthm1hpirjzq38490VECXvOfiSWLF19PbRn6N9VjRdEQ4Bi9qCCx2IvLVnmEOSduLJaENzkSQmOd5jhBmtlTGctlJM5OXr0fr1pV%2B9lKSYd%2FOSQxyFriizl5dH2xUshr1%2B7XEupvHo%2B0zaJsU6jLY4lyQXbPqRPEC2nnS6fphoXf7ovNHNOTMDuM7Uvlp5xBu7QHj541%2FZnBwhHHW8aMBqGg6kf%2FBjQ%2FdoCWjHh5M85dA2TTUntR%2BeU7YYww%2FGlzwY6sQGVBTThexnBSQFhdBlQoGAWKaVVhUE79sQKe3ikVZRXjZbewdIxTgHU8N4TMFjITHrAvIC2tmcIKO6nWFa2qw1mxOelb7rkregF9nxAaWD6ZE5L1PfCYUoz9JfjU6OqtNSVHN2HNjh80fyHmgBCnMfOk4wQrSgUL3ByiNegqTLxBxE%2BLgIi0Cd%2BIiVMWpbUOllluZKWn%2B%2FDO%2Fx1JYHGTZ%2FpSbJqqLh2eqXCXNvMYKhKGpg%3D&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47UWS26F442%2F20260423%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260423T023626Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=8cc203bb3af2da1f3166e4be2c85e895b8fdbb0a674ae2d1dbc9566318868e44\" 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=IQoJb3JpZ2luX2VjEJL%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJHMEUCIQDV18Oo7MTeIGlI5dOtfYcPgJihgt6FDR1N7k2Re3pOoQIgd2au0VvJR22CPbJITF8dyTwlJfvChE0kGUTSbQ9FdjQquAUIWxAFGgwyNzM1NzAxOTU0MzMiDNQweSErN9xBSEbB6CqVBQD9AWHl7ZavPNgiVYtx9UVNeFZ0V1sniRReACfzN%2Bix%2BeLQPFgM9r5oBgxIByyK2%2FTEKrFL45pXQ%2BuFznivv814j87KiRGsi79Eimtr5YMJjHT3q53I4epkPxZk9NcnZhIlqRuBIkiGbwYZ5aE7f52v9Nema6Q9WOgUp5D0zPYKGR%2F7ImtadOlKuZr80EWNJsVijrX%2BIpc5K5p6HDTNL8fMOaIn1OugbrHam7RaE3%2BVPHNQM8aDNttXQUeoXw6%2Bh1EFBombaIzaSkbe8S%2FWO4KtMtas92g%2BsM9DBvq6Syb5XCVVOCy3F3xYXXN9A%2Fhl9vZL5ekMqWYZ2PyqHx2ABklYwcFep0C%2Br7PdO9ej6ktmx4sCHe1YRNM96tLVEbkmMt4rF%2BbZ%2Bwr3kS4SZidjECc8f%2F5D4IAdCk%2FnUG%2BwMXofrDurtYUiNKDYWmYBu2OYWWHTAezIpW1fUGOZ5fNYAg7JQN5Z2oZSREdDzDUCs%2BNvDb7SzsqlWZsA11sXrhz%2FFK9MBKeTY0XH7So6E1Vu%2BNxj2s%2BqiadUFabL8gSKj8iLCgl6scoYx2h8L4ClZ416e4YOGRikVH3EhyYO2skfqVD%2BI60Q3jZGa7FEpDk6jlvH6abFLw4YdDw9R%2Bthm1hpirjzq38490VECXvOfiSWLF19PbRn6N9VjRdEQ4Bi9qCCx2IvLVnmEOSduLJaENzkSQmOd5jhBmtlTGctlJM5OXr0fr1pV%2B9lKSYd%2FOSQxyFriizl5dH2xUshr1%2B7XEupvHo%2B0zaJsU6jLY4lyQXbPqRPEC2nnS6fphoXf7ovNHNOTMDuM7Uvlp5xBu7QHj541%2FZnBwhHHW8aMBqGg6kf%2FBjQ%2FdoCWjHh5M85dA2TTUntR%2BeU7YYww%2FGlzwY6sQGVBTThexnBSQFhdBlQoGAWKaVVhUE79sQKe3ikVZRXjZbewdIxTgHU8N4TMFjITHrAvIC2tmcIKO6nWFa2qw1mxOelb7rkregF9nxAaWD6ZE5L1PfCYUoz9JfjU6OqtNSVHN2HNjh80fyHmgBCnMfOk4wQrSgUL3ByiNegqTLxBxE%2BLgIi0Cd%2BIiVMWpbUOllluZKWn%2B%2FDO%2Fx1JYHGTZ%2FpSbJqqLh2eqXCXNvMYKhKGpg%3D&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47UWS26F442%2F20260423%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260423T023626Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=4cca77eded8930d21c93d45ff42dcfae82918369eed0189fbcb8964a0af443d8\" 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=IQoJb3JpZ2luX2VjEJL%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJHMEUCIQDV18Oo7MTeIGlI5dOtfYcPgJihgt6FDR1N7k2Re3pOoQIgd2au0VvJR22CPbJITF8dyTwlJfvChE0kGUTSbQ9FdjQquAUIWxAFGgwyNzM1NzAxOTU0MzMiDNQweSErN9xBSEbB6CqVBQD9AWHl7ZavPNgiVYtx9UVNeFZ0V1sniRReACfzN%2Bix%2BeLQPFgM9r5oBgxIByyK2%2FTEKrFL45pXQ%2BuFznivv814j87KiRGsi79Eimtr5YMJjHT3q53I4epkPxZk9NcnZhIlqRuBIkiGbwYZ5aE7f52v9Nema6Q9WOgUp5D0zPYKGR%2F7ImtadOlKuZr80EWNJsVijrX%2BIpc5K5p6HDTNL8fMOaIn1OugbrHam7RaE3%2BVPHNQM8aDNttXQUeoXw6%2Bh1EFBombaIzaSkbe8S%2FWO4KtMtas92g%2BsM9DBvq6Syb5XCVVOCy3F3xYXXN9A%2Fhl9vZL5ekMqWYZ2PyqHx2ABklYwcFep0C%2Br7PdO9ej6ktmx4sCHe1YRNM96tLVEbkmMt4rF%2BbZ%2Bwr3kS4SZidjECc8f%2F5D4IAdCk%2FnUG%2BwMXofrDurtYUiNKDYWmYBu2OYWWHTAezIpW1fUGOZ5fNYAg7JQN5Z2oZSREdDzDUCs%2BNvDb7SzsqlWZsA11sXrhz%2FFK9MBKeTY0XH7So6E1Vu%2BNxj2s%2BqiadUFabL8gSKj8iLCgl6scoYx2h8L4ClZ416e4YOGRikVH3EhyYO2skfqVD%2BI60Q3jZGa7FEpDk6jlvH6abFLw4YdDw9R%2Bthm1hpirjzq38490VECXvOfiSWLF19PbRn6N9VjRdEQ4Bi9qCCx2IvLVnmEOSduLJaENzkSQmOd5jhBmtlTGctlJM5OXr0fr1pV%2B9lKSYd%2FOSQxyFriizl5dH2xUshr1%2B7XEupvHo%2B0zaJsU6jLY4lyQXbPqRPEC2nnS6fphoXf7ovNHNOTMDuM7Uvlp5xBu7QHj541%2FZnBwhHHW8aMBqGg6kf%2FBjQ%2FdoCWjHh5M85dA2TTUntR%2BeU7YYww%2FGlzwY6sQGVBTThexnBSQFhdBlQoGAWKaVVhUE79sQKe3ikVZRXjZbewdIxTgHU8N4TMFjITHrAvIC2tmcIKO6nWFa2qw1mxOelb7rkregF9nxAaWD6ZE5L1PfCYUoz9JfjU6OqtNSVHN2HNjh80fyHmgBCnMfOk4wQrSgUL3ByiNegqTLxBxE%2BLgIi0Cd%2BIiVMWpbUOllluZKWn%2B%2FDO%2Fx1JYHGTZ%2FpSbJqqLh2eqXCXNvMYKhKGpg%3D&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47UWS26F442%2F20260423%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260423T023626Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=4cca77eded8930d21c93d45ff42dcfae82918369eed0189fbcb8964a0af443d8 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=IQoJb3JpZ2luX2VjEJL%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJHMEUCIQDV18Oo7MTeIGlI5dOtfYcPgJihgt6FDR1N7k2Re3pOoQIgd2au0VvJR22CPbJITF8dyTwlJfvChE0kGUTSbQ9FdjQquAUIWxAFGgwyNzM1NzAxOTU0MzMiDNQweSErN9xBSEbB6CqVBQD9AWHl7ZavPNgiVYtx9UVNeFZ0V1sniRReACfzN%2Bix%2BeLQPFgM9r5oBgxIByyK2%2FTEKrFL45pXQ%2BuFznivv814j87KiRGsi79Eimtr5YMJjHT3q53I4epkPxZk9NcnZhIlqRuBIkiGbwYZ5aE7f52v9Nema6Q9WOgUp5D0zPYKGR%2F7ImtadOlKuZr80EWNJsVijrX%2BIpc5K5p6HDTNL8fMOaIn1OugbrHam7RaE3%2BVPHNQM8aDNttXQUeoXw6%2Bh1EFBombaIzaSkbe8S%2FWO4KtMtas92g%2BsM9DBvq6Syb5XCVVOCy3F3xYXXN9A%2Fhl9vZL5ekMqWYZ2PyqHx2ABklYwcFep0C%2Br7PdO9ej6ktmx4sCHe1YRNM96tLVEbkmMt4rF%2BbZ%2Bwr3kS4SZidjECc8f%2F5D4IAdCk%2FnUG%2BwMXofrDurtYUiNKDYWmYBu2OYWWHTAezIpW1fUGOZ5fNYAg7JQN5Z2oZSREdDzDUCs%2BNvDb7SzsqlWZsA11sXrhz%2FFK9MBKeTY0XH7So6E1Vu%2BNxj2s%2BqiadUFabL8gSKj8iLCgl6scoYx2h8L4ClZ416e4YOGRikVH3EhyYO2skfqVD%2BI60Q3jZGa7FEpDk6jlvH6abFLw4YdDw9R%2Bthm1hpirjzq38490VECXvOfiSWLF19PbRn6N9VjRdEQ4Bi9qCCx2IvLVnmEOSduLJaENzkSQmOd5jhBmtlTGctlJM5OXr0fr1pV%2B9lKSYd%2FOSQxyFriizl5dH2xUshr1%2B7XEupvHo%2B0zaJsU6jLY4lyQXbPqRPEC2nnS6fphoXf7ovNHNOTMDuM7Uvlp5xBu7QHj541%2FZnBwhHHW8aMBqGg6kf%2FBjQ%2FdoCWjHh5M85dA2TTUntR%2BeU7YYww%2FGlzwY6sQGVBTThexnBSQFhdBlQoGAWKaVVhUE79sQKe3ikVZRXjZbewdIxTgHU8N4TMFjITHrAvIC2tmcIKO6nWFa2qw1mxOelb7rkregF9nxAaWD6ZE5L1PfCYUoz9JfjU6OqtNSVHN2HNjh80fyHmgBCnMfOk4wQrSgUL3ByiNegqTLxBxE%2BLgIi0Cd%2BIiVMWpbUOllluZKWn%2B%2FDO%2Fx1JYHGTZ%2FpSbJqqLh2eqXCXNvMYKhKGpg%3D&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47UWS26F442%2F20260423%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260423T023626Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=aa156da563b331d9d8fd80f7661d8d196678ca04c0ce5c42b8b29549423cb348 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=IQoJb3JpZ2luX2VjEJL%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJHMEUCIQDV18Oo7MTeIGlI5dOtfYcPgJihgt6FDR1N7k2Re3pOoQIgd2au0VvJR22CPbJITF8dyTwlJfvChE0kGUTSbQ9FdjQquAUIWxAFGgwyNzM1NzAxOTU0MzMiDNQweSErN9xBSEbB6CqVBQD9AWHl7ZavPNgiVYtx9UVNeFZ0V1sniRReACfzN%2Bix%2BeLQPFgM9r5oBgxIByyK2%2FTEKrFL45pXQ%2BuFznivv814j87KiRGsi79Eimtr5YMJjHT3q53I4epkPxZk9NcnZhIlqRuBIkiGbwYZ5aE7f52v9Nema6Q9WOgUp5D0zPYKGR%2F7ImtadOlKuZr80EWNJsVijrX%2BIpc5K5p6HDTNL8fMOaIn1OugbrHam7RaE3%2BVPHNQM8aDNttXQUeoXw6%2Bh1EFBombaIzaSkbe8S%2FWO4KtMtas92g%2BsM9DBvq6Syb5XCVVOCy3F3xYXXN9A%2Fhl9vZL5ekMqWYZ2PyqHx2ABklYwcFep0C%2Br7PdO9ej6ktmx4sCHe1YRNM96tLVEbkmMt4rF%2BbZ%2Bwr3kS4SZidjECc8f%2F5D4IAdCk%2FnUG%2BwMXofrDurtYUiNKDYWmYBu2OYWWHTAezIpW1fUGOZ5fNYAg7JQN5Z2oZSREdDzDUCs%2BNvDb7SzsqlWZsA11sXrhz%2FFK9MBKeTY0XH7So6E1Vu%2BNxj2s%2BqiadUFabL8gSKj8iLCgl6scoYx2h8L4ClZ416e4YOGRikVH3EhyYO2skfqVD%2BI60Q3jZGa7FEpDk6jlvH6abFLw4YdDw9R%2Bthm1hpirjzq38490VECXvOfiSWLF19PbRn6N9VjRdEQ4Bi9qCCx2IvLVnmEOSduLJaENzkSQmOd5jhBmtlTGctlJM5OXr0fr1pV%2B9lKSYd%2FOSQxyFriizl5dH2xUshr1%2B7XEupvHo%2B0zaJsU6jLY4lyQXbPqRPEC2nnS6fphoXf7ovNHNOTMDuM7Uvlp5xBu7QHj541%2FZnBwhHHW8aMBqGg6kf%2FBjQ%2FdoCWjHh5M85dA2TTUntR%2BeU7YYww%2FGlzwY6sQGVBTThexnBSQFhdBlQoGAWKaVVhUE79sQKe3ikVZRXjZbewdIxTgHU8N4TMFjITHrAvIC2tmcIKO6nWFa2qw1mxOelb7rkregF9nxAaWD6ZE5L1PfCYUoz9JfjU6OqtNSVHN2HNjh80fyHmgBCnMfOk4wQrSgUL3ByiNegqTLxBxE%2BLgIi0Cd%2BIiVMWpbUOllluZKWn%2B%2FDO%2Fx1JYHGTZ%2FpSbJqqLh2eqXCXNvMYKhKGpg%3D&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47UWS26F442%2F20260423%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260423T023626Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=aa156da563b331d9d8fd80f7661d8d196678ca04c0ce5c42b8b29549423cb348\" 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=IQoJb3JpZ2luX2VjEJL%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJHMEUCIQDV18Oo7MTeIGlI5dOtfYcPgJihgt6FDR1N7k2Re3pOoQIgd2au0VvJR22CPbJITF8dyTwlJfvChE0kGUTSbQ9FdjQquAUIWxAFGgwyNzM1NzAxOTU0MzMiDNQweSErN9xBSEbB6CqVBQD9AWHl7ZavPNgiVYtx9UVNeFZ0V1sniRReACfzN%2Bix%2BeLQPFgM9r5oBgxIByyK2%2FTEKrFL45pXQ%2BuFznivv814j87KiRGsi79Eimtr5YMJjHT3q53I4epkPxZk9NcnZhIlqRuBIkiGbwYZ5aE7f52v9Nema6Q9WOgUp5D0zPYKGR%2F7ImtadOlKuZr80EWNJsVijrX%2BIpc5K5p6HDTNL8fMOaIn1OugbrHam7RaE3%2BVPHNQM8aDNttXQUeoXw6%2Bh1EFBombaIzaSkbe8S%2FWO4KtMtas92g%2BsM9DBvq6Syb5XCVVOCy3F3xYXXN9A%2Fhl9vZL5ekMqWYZ2PyqHx2ABklYwcFep0C%2Br7PdO9ej6ktmx4sCHe1YRNM96tLVEbkmMt4rF%2BbZ%2Bwr3kS4SZidjECc8f%2F5D4IAdCk%2FnUG%2BwMXofrDurtYUiNKDYWmYBu2OYWWHTAezIpW1fUGOZ5fNYAg7JQN5Z2oZSREdDzDUCs%2BNvDb7SzsqlWZsA11sXrhz%2FFK9MBKeTY0XH7So6E1Vu%2BNxj2s%2BqiadUFabL8gSKj8iLCgl6scoYx2h8L4ClZ416e4YOGRikVH3EhyYO2skfqVD%2BI60Q3jZGa7FEpDk6jlvH6abFLw4YdDw9R%2Bthm1hpirjzq38490VECXvOfiSWLF19PbRn6N9VjRdEQ4Bi9qCCx2IvLVnmEOSduLJaENzkSQmOd5jhBmtlTGctlJM5OXr0fr1pV%2B9lKSYd%2FOSQxyFriizl5dH2xUshr1%2B7XEupvHo%2B0zaJsU6jLY4lyQXbPqRPEC2nnS6fphoXf7ovNHNOTMDuM7Uvlp5xBu7QHj541%2FZnBwhHHW8aMBqGg6kf%2FBjQ%2FdoCWjHh5M85dA2TTUntR%2BeU7YYww%2FGlzwY6sQGVBTThexnBSQFhdBlQoGAWKaVVhUE79sQKe3ikVZRXjZbewdIxTgHU8N4TMFjITHrAvIC2tmcIKO6nWFa2qw1mxOelb7rkregF9nxAaWD6ZE5L1PfCYUoz9JfjU6OqtNSVHN2HNjh80fyHmgBCnMfOk4wQrSgUL3ByiNegqTLxBxE%2BLgIi0Cd%2BIiVMWpbUOllluZKWn%2B%2FDO%2Fx1JYHGTZ%2FpSbJqqLh2eqXCXNvMYKhKGpg%3D&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47UWS26F442%2F20260423%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260423T023626Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=66b62caa6118299d134f25831e230cb5a66f4140c56a722ee7b3c27152e04779\" 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=IQoJb3JpZ2luX2VjEJL%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJHMEUCIQDV18Oo7MTeIGlI5dOtfYcPgJihgt6FDR1N7k2Re3pOoQIgd2au0VvJR22CPbJITF8dyTwlJfvChE0kGUTSbQ9FdjQquAUIWxAFGgwyNzM1NzAxOTU0MzMiDNQweSErN9xBSEbB6CqVBQD9AWHl7ZavPNgiVYtx9UVNeFZ0V1sniRReACfzN%2Bix%2BeLQPFgM9r5oBgxIByyK2%2FTEKrFL45pXQ%2BuFznivv814j87KiRGsi79Eimtr5YMJjHT3q53I4epkPxZk9NcnZhIlqRuBIkiGbwYZ5aE7f52v9Nema6Q9WOgUp5D0zPYKGR%2F7ImtadOlKuZr80EWNJsVijrX%2BIpc5K5p6HDTNL8fMOaIn1OugbrHam7RaE3%2BVPHNQM8aDNttXQUeoXw6%2Bh1EFBombaIzaSkbe8S%2FWO4KtMtas92g%2BsM9DBvq6Syb5XCVVOCy3F3xYXXN9A%2Fhl9vZL5ekMqWYZ2PyqHx2ABklYwcFep0C%2Br7PdO9ej6ktmx4sCHe1YRNM96tLVEbkmMt4rF%2BbZ%2Bwr3kS4SZidjECc8f%2F5D4IAdCk%2FnUG%2BwMXofrDurtYUiNKDYWmYBu2OYWWHTAezIpW1fUGOZ5fNYAg7JQN5Z2oZSREdDzDUCs%2BNvDb7SzsqlWZsA11sXrhz%2FFK9MBKeTY0XH7So6E1Vu%2BNxj2s%2BqiadUFabL8gSKj8iLCgl6scoYx2h8L4ClZ416e4YOGRikVH3EhyYO2skfqVD%2BI60Q3jZGa7FEpDk6jlvH6abFLw4YdDw9R%2Bthm1hpirjzq38490VECXvOfiSWLF19PbRn6N9VjRdEQ4Bi9qCCx2IvLVnmEOSduLJaENzkSQmOd5jhBmtlTGctlJM5OXr0fr1pV%2B9lKSYd%2FOSQxyFriizl5dH2xUshr1%2B7XEupvHo%2B0zaJsU6jLY4lyQXbPqRPEC2nnS6fphoXf7ovNHNOTMDuM7Uvlp5xBu7QHj541%2FZnBwhHHW8aMBqGg6kf%2FBjQ%2FdoCWjHh5M85dA2TTUntR%2BeU7YYww%2FGlzwY6sQGVBTThexnBSQFhdBlQoGAWKaVVhUE79sQKe3ikVZRXjZbewdIxTgHU8N4TMFjITHrAvIC2tmcIKO6nWFa2qw1mxOelb7rkregF9nxAaWD6ZE5L1PfCYUoz9JfjU6OqtNSVHN2HNjh80fyHmgBCnMfOk4wQrSgUL3ByiNegqTLxBxE%2BLgIi0Cd%2BIiVMWpbUOllluZKWn%2B%2FDO%2Fx1JYHGTZ%2FpSbJqqLh2eqXCXNvMYKhKGpg%3D&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47UWS26F442%2F20260423%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260423T023626Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=66b62caa6118299d134f25831e230cb5a66f4140c56a722ee7b3c27152e04779 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=IQoJb3JpZ2luX2VjEJL%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJHMEUCIQDV18Oo7MTeIGlI5dOtfYcPgJihgt6FDR1N7k2Re3pOoQIgd2au0VvJR22CPbJITF8dyTwlJfvChE0kGUTSbQ9FdjQquAUIWxAFGgwyNzM1NzAxOTU0MzMiDNQweSErN9xBSEbB6CqVBQD9AWHl7ZavPNgiVYtx9UVNeFZ0V1sniRReACfzN%2Bix%2BeLQPFgM9r5oBgxIByyK2%2FTEKrFL45pXQ%2BuFznivv814j87KiRGsi79Eimtr5YMJjHT3q53I4epkPxZk9NcnZhIlqRuBIkiGbwYZ5aE7f52v9Nema6Q9WOgUp5D0zPYKGR%2F7ImtadOlKuZr80EWNJsVijrX%2BIpc5K5p6HDTNL8fMOaIn1OugbrHam7RaE3%2BVPHNQM8aDNttXQUeoXw6%2Bh1EFBombaIzaSkbe8S%2FWO4KtMtas92g%2BsM9DBvq6Syb5XCVVOCy3F3xYXXN9A%2Fhl9vZL5ekMqWYZ2PyqHx2ABklYwcFep0C%2Br7PdO9ej6ktmx4sCHe1YRNM96tLVEbkmMt4rF%2BbZ%2Bwr3kS4SZidjECc8f%2F5D4IAdCk%2FnUG%2BwMXofrDurtYUiNKDYWmYBu2OYWWHTAezIpW1fUGOZ5fNYAg7JQN5Z2oZSREdDzDUCs%2BNvDb7SzsqlWZsA11sXrhz%2FFK9MBKeTY0XH7So6E1Vu%2BNxj2s%2BqiadUFabL8gSKj8iLCgl6scoYx2h8L4ClZ416e4YOGRikVH3EhyYO2skfqVD%2BI60Q3jZGa7FEpDk6jlvH6abFLw4YdDw9R%2Bthm1hpirjzq38490VECXvOfiSWLF19PbRn6N9VjRdEQ4Bi9qCCx2IvLVnmEOSduLJaENzkSQmOd5jhBmtlTGctlJM5OXr0fr1pV%2B9lKSYd%2FOSQxyFriizl5dH2xUshr1%2B7XEupvHo%2B0zaJsU6jLY4lyQXbPqRPEC2nnS6fphoXf7ovNHNOTMDuM7Uvlp5xBu7QHj541%2FZnBwhHHW8aMBqGg6kf%2FBjQ%2FdoCWjHh5M85dA2TTUntR%2BeU7YYww%2FGlzwY6sQGVBTThexnBSQFhdBlQoGAWKaVVhUE79sQKe3ikVZRXjZbewdIxTgHU8N4TMFjITHrAvIC2tmcIKO6nWFa2qw1mxOelb7rkregF9nxAaWD6ZE5L1PfCYUoz9JfjU6OqtNSVHN2HNjh80fyHmgBCnMfOk4wQrSgUL3ByiNegqTLxBxE%2BLgIi0Cd%2BIiVMWpbUOllluZKWn%2B%2FDO%2Fx1JYHGTZ%2FpSbJqqLh2eqXCXNvMYKhKGpg%3D&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47UWS26F442%2F20260423%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260423T023626Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=343557620dfa218091267cb40cbce99065cf1ea76f2c40a9c30c0a4dbe800d90 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=IQoJb3JpZ2luX2VjEJL%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJHMEUCIQDV18Oo7MTeIGlI5dOtfYcPgJihgt6FDR1N7k2Re3pOoQIgd2au0VvJR22CPbJITF8dyTwlJfvChE0kGUTSbQ9FdjQquAUIWxAFGgwyNzM1NzAxOTU0MzMiDNQweSErN9xBSEbB6CqVBQD9AWHl7ZavPNgiVYtx9UVNeFZ0V1sniRReACfzN%2Bix%2BeLQPFgM9r5oBgxIByyK2%2FTEKrFL45pXQ%2BuFznivv814j87KiRGsi79Eimtr5YMJjHT3q53I4epkPxZk9NcnZhIlqRuBIkiGbwYZ5aE7f52v9Nema6Q9WOgUp5D0zPYKGR%2F7ImtadOlKuZr80EWNJsVijrX%2BIpc5K5p6HDTNL8fMOaIn1OugbrHam7RaE3%2BVPHNQM8aDNttXQUeoXw6%2Bh1EFBombaIzaSkbe8S%2FWO4KtMtas92g%2BsM9DBvq6Syb5XCVVOCy3F3xYXXN9A%2Fhl9vZL5ekMqWYZ2PyqHx2ABklYwcFep0C%2Br7PdO9ej6ktmx4sCHe1YRNM96tLVEbkmMt4rF%2BbZ%2Bwr3kS4SZidjECc8f%2F5D4IAdCk%2FnUG%2BwMXofrDurtYUiNKDYWmYBu2OYWWHTAezIpW1fUGOZ5fNYAg7JQN5Z2oZSREdDzDUCs%2BNvDb7SzsqlWZsA11sXrhz%2FFK9MBKeTY0XH7So6E1Vu%2BNxj2s%2BqiadUFabL8gSKj8iLCgl6scoYx2h8L4ClZ416e4YOGRikVH3EhyYO2skfqVD%2BI60Q3jZGa7FEpDk6jlvH6abFLw4YdDw9R%2Bthm1hpirjzq38490VECXvOfiSWLF19PbRn6N9VjRdEQ4Bi9qCCx2IvLVnmEOSduLJaENzkSQmOd5jhBmtlTGctlJM5OXr0fr1pV%2B9lKSYd%2FOSQxyFriizl5dH2xUshr1%2B7XEupvHo%2B0zaJsU6jLY4lyQXbPqRPEC2nnS6fphoXf7ovNHNOTMDuM7Uvlp5xBu7QHj541%2FZnBwhHHW8aMBqGg6kf%2FBjQ%2FdoCWjHh5M85dA2TTUntR%2BeU7YYww%2FGlzwY6sQGVBTThexnBSQFhdBlQoGAWKaVVhUE79sQKe3ikVZRXjZbewdIxTgHU8N4TMFjITHrAvIC2tmcIKO6nWFa2qw1mxOelb7rkregF9nxAaWD6ZE5L1PfCYUoz9JfjU6OqtNSVHN2HNjh80fyHmgBCnMfOk4wQrSgUL3ByiNegqTLxBxE%2BLgIi0Cd%2BIiVMWpbUOllluZKWn%2B%2FDO%2Fx1JYHGTZ%2FpSbJqqLh2eqXCXNvMYKhKGpg%3D&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47UWS26F442%2F20260423%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260423T023626Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=343557620dfa218091267cb40cbce99065cf1ea76f2c40a9c30c0a4dbe800d90\" 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=IQoJb3JpZ2luX2VjEJL%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJHMEUCIQDV18Oo7MTeIGlI5dOtfYcPgJihgt6FDR1N7k2Re3pOoQIgd2au0VvJR22CPbJITF8dyTwlJfvChE0kGUTSbQ9FdjQquAUIWxAFGgwyNzM1NzAxOTU0MzMiDNQweSErN9xBSEbB6CqVBQD9AWHl7ZavPNgiVYtx9UVNeFZ0V1sniRReACfzN%2Bix%2BeLQPFgM9r5oBgxIByyK2%2FTEKrFL45pXQ%2BuFznivv814j87KiRGsi79Eimtr5YMJjHT3q53I4epkPxZk9NcnZhIlqRuBIkiGbwYZ5aE7f52v9Nema6Q9WOgUp5D0zPYKGR%2F7ImtadOlKuZr80EWNJsVijrX%2BIpc5K5p6HDTNL8fMOaIn1OugbrHam7RaE3%2BVPHNQM8aDNttXQUeoXw6%2Bh1EFBombaIzaSkbe8S%2FWO4KtMtas92g%2BsM9DBvq6Syb5XCVVOCy3F3xYXXN9A%2Fhl9vZL5ekMqWYZ2PyqHx2ABklYwcFep0C%2Br7PdO9ej6ktmx4sCHe1YRNM96tLVEbkmMt4rF%2BbZ%2Bwr3kS4SZidjECc8f%2F5D4IAdCk%2FnUG%2BwMXofrDurtYUiNKDYWmYBu2OYWWHTAezIpW1fUGOZ5fNYAg7JQN5Z2oZSREdDzDUCs%2BNvDb7SzsqlWZsA11sXrhz%2FFK9MBKeTY0XH7So6E1Vu%2BNxj2s%2BqiadUFabL8gSKj8iLCgl6scoYx2h8L4ClZ416e4YOGRikVH3EhyYO2skfqVD%2BI60Q3jZGa7FEpDk6jlvH6abFLw4YdDw9R%2Bthm1hpirjzq38490VECXvOfiSWLF19PbRn6N9VjRdEQ4Bi9qCCx2IvLVnmEOSduLJaENzkSQmOd5jhBmtlTGctlJM5OXr0fr1pV%2B9lKSYd%2FOSQxyFriizl5dH2xUshr1%2B7XEupvHo%2B0zaJsU6jLY4lyQXbPqRPEC2nnS6fphoXf7ovNHNOTMDuM7Uvlp5xBu7QHj541%2FZnBwhHHW8aMBqGg6kf%2FBjQ%2FdoCWjHh5M85dA2TTUntR%2BeU7YYww%2FGlzwY6sQGVBTThexnBSQFhdBlQoGAWKaVVhUE79sQKe3ikVZRXjZbewdIxTgHU8N4TMFjITHrAvIC2tmcIKO6nWFa2qw1mxOelb7rkregF9nxAaWD6ZE5L1PfCYUoz9JfjU6OqtNSVHN2HNjh80fyHmgBCnMfOk4wQrSgUL3ByiNegqTLxBxE%2BLgIi0Cd%2BIiVMWpbUOllluZKWn%2B%2FDO%2Fx1JYHGTZ%2FpSbJqqLh2eqXCXNvMYKhKGpg%3D&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47UWS26F442%2F20260423%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260423T023626Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=05721023416d8911eb3af196b5a349d90dc66ab6a62aa340d24f4d396201a463\" 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=IQoJb3JpZ2luX2VjEJL%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJHMEUCIQDV18Oo7MTeIGlI5dOtfYcPgJihgt6FDR1N7k2Re3pOoQIgd2au0VvJR22CPbJITF8dyTwlJfvChE0kGUTSbQ9FdjQquAUIWxAFGgwyNzM1NzAxOTU0MzMiDNQweSErN9xBSEbB6CqVBQD9AWHl7ZavPNgiVYtx9UVNeFZ0V1sniRReACfzN%2Bix%2BeLQPFgM9r5oBgxIByyK2%2FTEKrFL45pXQ%2BuFznivv814j87KiRGsi79Eimtr5YMJjHT3q53I4epkPxZk9NcnZhIlqRuBIkiGbwYZ5aE7f52v9Nema6Q9WOgUp5D0zPYKGR%2F7ImtadOlKuZr80EWNJsVijrX%2BIpc5K5p6HDTNL8fMOaIn1OugbrHam7RaE3%2BVPHNQM8aDNttXQUeoXw6%2Bh1EFBombaIzaSkbe8S%2FWO4KtMtas92g%2BsM9DBvq6Syb5XCVVOCy3F3xYXXN9A%2Fhl9vZL5ekMqWYZ2PyqHx2ABklYwcFep0C%2Br7PdO9ej6ktmx4sCHe1YRNM96tLVEbkmMt4rF%2BbZ%2Bwr3kS4SZidjECc8f%2F5D4IAdCk%2FnUG%2BwMXofrDurtYUiNKDYWmYBu2OYWWHTAezIpW1fUGOZ5fNYAg7JQN5Z2oZSREdDzDUCs%2BNvDb7SzsqlWZsA11sXrhz%2FFK9MBKeTY0XH7So6E1Vu%2BNxj2s%2BqiadUFabL8gSKj8iLCgl6scoYx2h8L4ClZ416e4YOGRikVH3EhyYO2skfqVD%2BI60Q3jZGa7FEpDk6jlvH6abFLw4YdDw9R%2Bthm1hpirjzq38490VECXvOfiSWLF19PbRn6N9VjRdEQ4Bi9qCCx2IvLVnmEOSduLJaENzkSQmOd5jhBmtlTGctlJM5OXr0fr1pV%2B9lKSYd%2FOSQxyFriizl5dH2xUshr1%2B7XEupvHo%2B0zaJsU6jLY4lyQXbPqRPEC2nnS6fphoXf7ovNHNOTMDuM7Uvlp5xBu7QHj541%2FZnBwhHHW8aMBqGg6kf%2FBjQ%2FdoCWjHh5M85dA2TTUntR%2BeU7YYww%2FGlzwY6sQGVBTThexnBSQFhdBlQoGAWKaVVhUE79sQKe3ikVZRXjZbewdIxTgHU8N4TMFjITHrAvIC2tmcIKO6nWFa2qw1mxOelb7rkregF9nxAaWD6ZE5L1PfCYUoz9JfjU6OqtNSVHN2HNjh80fyHmgBCnMfOk4wQrSgUL3ByiNegqTLxBxE%2BLgIi0Cd%2BIiVMWpbUOllluZKWn%2B%2FDO%2Fx1JYHGTZ%2FpSbJqqLh2eqXCXNvMYKhKGpg%3D&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47UWS26F442%2F20260423%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260423T023626Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=05721023416d8911eb3af196b5a349d90dc66ab6a62aa340d24f4d396201a463 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=IQoJb3JpZ2luX2VjEJL%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJHMEUCIQDV18Oo7MTeIGlI5dOtfYcPgJihgt6FDR1N7k2Re3pOoQIgd2au0VvJR22CPbJITF8dyTwlJfvChE0kGUTSbQ9FdjQquAUIWxAFGgwyNzM1NzAxOTU0MzMiDNQweSErN9xBSEbB6CqVBQD9AWHl7ZavPNgiVYtx9UVNeFZ0V1sniRReACfzN%2Bix%2BeLQPFgM9r5oBgxIByyK2%2FTEKrFL45pXQ%2BuFznivv814j87KiRGsi79Eimtr5YMJjHT3q53I4epkPxZk9NcnZhIlqRuBIkiGbwYZ5aE7f52v9Nema6Q9WOgUp5D0zPYKGR%2F7ImtadOlKuZr80EWNJsVijrX%2BIpc5K5p6HDTNL8fMOaIn1OugbrHam7RaE3%2BVPHNQM8aDNttXQUeoXw6%2Bh1EFBombaIzaSkbe8S%2FWO4KtMtas92g%2BsM9DBvq6Syb5XCVVOCy3F3xYXXN9A%2Fhl9vZL5ekMqWYZ2PyqHx2ABklYwcFep0C%2Br7PdO9ej6ktmx4sCHe1YRNM96tLVEbkmMt4rF%2BbZ%2Bwr3kS4SZidjECc8f%2F5D4IAdCk%2FnUG%2BwMXofrDurtYUiNKDYWmYBu2OYWWHTAezIpW1fUGOZ5fNYAg7JQN5Z2oZSREdDzDUCs%2BNvDb7SzsqlWZsA11sXrhz%2FFK9MBKeTY0XH7So6E1Vu%2BNxj2s%2BqiadUFabL8gSKj8iLCgl6scoYx2h8L4ClZ416e4YOGRikVH3EhyYO2skfqVD%2BI60Q3jZGa7FEpDk6jlvH6abFLw4YdDw9R%2Bthm1hpirjzq38490VECXvOfiSWLF19PbRn6N9VjRdEQ4Bi9qCCx2IvLVnmEOSduLJaENzkSQmOd5jhBmtlTGctlJM5OXr0fr1pV%2B9lKSYd%2FOSQxyFriizl5dH2xUshr1%2B7XEupvHo%2B0zaJsU6jLY4lyQXbPqRPEC2nnS6fphoXf7ovNHNOTMDuM7Uvlp5xBu7QHj541%2FZnBwhHHW8aMBqGg6kf%2FBjQ%2FdoCWjHh5M85dA2TTUntR%2BeU7YYww%2FGlzwY6sQGVBTThexnBSQFhdBlQoGAWKaVVhUE79sQKe3ikVZRXjZbewdIxTgHU8N4TMFjITHrAvIC2tmcIKO6nWFa2qw1mxOelb7rkregF9nxAaWD6ZE5L1PfCYUoz9JfjU6OqtNSVHN2HNjh80fyHmgBCnMfOk4wQrSgUL3ByiNegqTLxBxE%2BLgIi0Cd%2BIiVMWpbUOllluZKWn%2B%2FDO%2Fx1JYHGTZ%2FpSbJqqLh2eqXCXNvMYKhKGpg%3D&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47UWS26F442%2F20260423%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260423T023626Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=0c72124b1975d927f62c6c99189c055434ce10752dda3f72581c34011b57edd2 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=IQoJb3JpZ2luX2VjEJL%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJHMEUCIQDV18Oo7MTeIGlI5dOtfYcPgJihgt6FDR1N7k2Re3pOoQIgd2au0VvJR22CPbJITF8dyTwlJfvChE0kGUTSbQ9FdjQquAUIWxAFGgwyNzM1NzAxOTU0MzMiDNQweSErN9xBSEbB6CqVBQD9AWHl7ZavPNgiVYtx9UVNeFZ0V1sniRReACfzN%2Bix%2BeLQPFgM9r5oBgxIByyK2%2FTEKrFL45pXQ%2BuFznivv814j87KiRGsi79Eimtr5YMJjHT3q53I4epkPxZk9NcnZhIlqRuBIkiGbwYZ5aE7f52v9Nema6Q9WOgUp5D0zPYKGR%2F7ImtadOlKuZr80EWNJsVijrX%2BIpc5K5p6HDTNL8fMOaIn1OugbrHam7RaE3%2BVPHNQM8aDNttXQUeoXw6%2Bh1EFBombaIzaSkbe8S%2FWO4KtMtas92g%2BsM9DBvq6Syb5XCVVOCy3F3xYXXN9A%2Fhl9vZL5ekMqWYZ2PyqHx2ABklYwcFep0C%2Br7PdO9ej6ktmx4sCHe1YRNM96tLVEbkmMt4rF%2BbZ%2Bwr3kS4SZidjECc8f%2F5D4IAdCk%2FnUG%2BwMXofrDurtYUiNKDYWmYBu2OYWWHTAezIpW1fUGOZ5fNYAg7JQN5Z2oZSREdDzDUCs%2BNvDb7SzsqlWZsA11sXrhz%2FFK9MBKeTY0XH7So6E1Vu%2BNxj2s%2BqiadUFabL8gSKj8iLCgl6scoYx2h8L4ClZ416e4YOGRikVH3EhyYO2skfqVD%2BI60Q3jZGa7FEpDk6jlvH6abFLw4YdDw9R%2Bthm1hpirjzq38490VECXvOfiSWLF19PbRn6N9VjRdEQ4Bi9qCCx2IvLVnmEOSduLJaENzkSQmOd5jhBmtlTGctlJM5OXr0fr1pV%2B9lKSYd%2FOSQxyFriizl5dH2xUshr1%2B7XEupvHo%2B0zaJsU6jLY4lyQXbPqRPEC2nnS6fphoXf7ovNHNOTMDuM7Uvlp5xBu7QHj541%2FZnBwhHHW8aMBqGg6kf%2FBjQ%2FdoCWjHh5M85dA2TTUntR%2BeU7YYww%2FGlzwY6sQGVBTThexnBSQFhdBlQoGAWKaVVhUE79sQKe3ikVZRXjZbewdIxTgHU8N4TMFjITHrAvIC2tmcIKO6nWFa2qw1mxOelb7rkregF9nxAaWD6ZE5L1PfCYUoz9JfjU6OqtNSVHN2HNjh80fyHmgBCnMfOk4wQrSgUL3ByiNegqTLxBxE%2BLgIi0Cd%2BIiVMWpbUOllluZKWn%2B%2FDO%2Fx1JYHGTZ%2FpSbJqqLh2eqXCXNvMYKhKGpg%3D&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47UWS26F442%2F20260423%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260423T023626Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=0c72124b1975d927f62c6c99189c055434ce10752dda3f72581c34011b57edd2\" 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=IQoJb3JpZ2luX2VjEJL%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJHMEUCIQDV18Oo7MTeIGlI5dOtfYcPgJihgt6FDR1N7k2Re3pOoQIgd2au0VvJR22CPbJITF8dyTwlJfvChE0kGUTSbQ9FdjQquAUIWxAFGgwyNzM1NzAxOTU0MzMiDNQweSErN9xBSEbB6CqVBQD9AWHl7ZavPNgiVYtx9UVNeFZ0V1sniRReACfzN%2Bix%2BeLQPFgM9r5oBgxIByyK2%2FTEKrFL45pXQ%2BuFznivv814j87KiRGsi79Eimtr5YMJjHT3q53I4epkPxZk9NcnZhIlqRuBIkiGbwYZ5aE7f52v9Nema6Q9WOgUp5D0zPYKGR%2F7ImtadOlKuZr80EWNJsVijrX%2BIpc5K5p6HDTNL8fMOaIn1OugbrHam7RaE3%2BVPHNQM8aDNttXQUeoXw6%2Bh1EFBombaIzaSkbe8S%2FWO4KtMtas92g%2BsM9DBvq6Syb5XCVVOCy3F3xYXXN9A%2Fhl9vZL5ekMqWYZ2PyqHx2ABklYwcFep0C%2Br7PdO9ej6ktmx4sCHe1YRNM96tLVEbkmMt4rF%2BbZ%2Bwr3kS4SZidjECc8f%2F5D4IAdCk%2FnUG%2BwMXofrDurtYUiNKDYWmYBu2OYWWHTAezIpW1fUGOZ5fNYAg7JQN5Z2oZSREdDzDUCs%2BNvDb7SzsqlWZsA11sXrhz%2FFK9MBKeTY0XH7So6E1Vu%2BNxj2s%2BqiadUFabL8gSKj8iLCgl6scoYx2h8L4ClZ416e4YOGRikVH3EhyYO2skfqVD%2BI60Q3jZGa7FEpDk6jlvH6abFLw4YdDw9R%2Bthm1hpirjzq38490VECXvOfiSWLF19PbRn6N9VjRdEQ4Bi9qCCx2IvLVnmEOSduLJaENzkSQmOd5jhBmtlTGctlJM5OXr0fr1pV%2B9lKSYd%2FOSQxyFriizl5dH2xUshr1%2B7XEupvHo%2B0zaJsU6jLY4lyQXbPqRPEC2nnS6fphoXf7ovNHNOTMDuM7Uvlp5xBu7QHj541%2FZnBwhHHW8aMBqGg6kf%2FBjQ%2FdoCWjHh5M85dA2TTUntR%2BeU7YYww%2FGlzwY6sQGVBTThexnBSQFhdBlQoGAWKaVVhUE79sQKe3ikVZRXjZbewdIxTgHU8N4TMFjITHrAvIC2tmcIKO6nWFa2qw1mxOelb7rkregF9nxAaWD6ZE5L1PfCYUoz9JfjU6OqtNSVHN2HNjh80fyHmgBCnMfOk4wQrSgUL3ByiNegqTLxBxE%2BLgIi0Cd%2BIiVMWpbUOllluZKWn%2B%2FDO%2Fx1JYHGTZ%2FpSbJqqLh2eqXCXNvMYKhKGpg%3D&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47UWS26F442%2F20260423%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260423T023626Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=41cc53a53eaaf957cd3b677ca5cc4fe5ae1a80fa6992110a847ed552bc9f96df\" 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=IQoJb3JpZ2luX2VjEJL%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJHMEUCIQDV18Oo7MTeIGlI5dOtfYcPgJihgt6FDR1N7k2Re3pOoQIgd2au0VvJR22CPbJITF8dyTwlJfvChE0kGUTSbQ9FdjQquAUIWxAFGgwyNzM1NzAxOTU0MzMiDNQweSErN9xBSEbB6CqVBQD9AWHl7ZavPNgiVYtx9UVNeFZ0V1sniRReACfzN%2Bix%2BeLQPFgM9r5oBgxIByyK2%2FTEKrFL45pXQ%2BuFznivv814j87KiRGsi79Eimtr5YMJjHT3q53I4epkPxZk9NcnZhIlqRuBIkiGbwYZ5aE7f52v9Nema6Q9WOgUp5D0zPYKGR%2F7ImtadOlKuZr80EWNJsVijrX%2BIpc5K5p6HDTNL8fMOaIn1OugbrHam7RaE3%2BVPHNQM8aDNttXQUeoXw6%2Bh1EFBombaIzaSkbe8S%2FWO4KtMtas92g%2BsM9DBvq6Syb5XCVVOCy3F3xYXXN9A%2Fhl9vZL5ekMqWYZ2PyqHx2ABklYwcFep0C%2Br7PdO9ej6ktmx4sCHe1YRNM96tLVEbkmMt4rF%2BbZ%2Bwr3kS4SZidjECc8f%2F5D4IAdCk%2FnUG%2BwMXofrDurtYUiNKDYWmYBu2OYWWHTAezIpW1fUGOZ5fNYAg7JQN5Z2oZSREdDzDUCs%2BNvDb7SzsqlWZsA11sXrhz%2FFK9MBKeTY0XH7So6E1Vu%2BNxj2s%2BqiadUFabL8gSKj8iLCgl6scoYx2h8L4ClZ416e4YOGRikVH3EhyYO2skfqVD%2BI60Q3jZGa7FEpDk6jlvH6abFLw4YdDw9R%2Bthm1hpirjzq38490VECXvOfiSWLF19PbRn6N9VjRdEQ4Bi9qCCx2IvLVnmEOSduLJaENzkSQmOd5jhBmtlTGctlJM5OXr0fr1pV%2B9lKSYd%2FOSQxyFriizl5dH2xUshr1%2B7XEupvHo%2B0zaJsU6jLY4lyQXbPqRPEC2nnS6fphoXf7ovNHNOTMDuM7Uvlp5xBu7QHj541%2FZnBwhHHW8aMBqGg6kf%2FBjQ%2FdoCWjHh5M85dA2TTUntR%2BeU7YYww%2FGlzwY6sQGVBTThexnBSQFhdBlQoGAWKaVVhUE79sQKe3ikVZRXjZbewdIxTgHU8N4TMFjITHrAvIC2tmcIKO6nWFa2qw1mxOelb7rkregF9nxAaWD6ZE5L1PfCYUoz9JfjU6OqtNSVHN2HNjh80fyHmgBCnMfOk4wQrSgUL3ByiNegqTLxBxE%2BLgIi0Cd%2BIiVMWpbUOllluZKWn%2B%2FDO%2Fx1JYHGTZ%2FpSbJqqLh2eqXCXNvMYKhKGpg%3D&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47UWS26F442%2F20260423%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260423T023626Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=41cc53a53eaaf957cd3b677ca5cc4fe5ae1a80fa6992110a847ed552bc9f96df 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=IQoJb3JpZ2luX2VjEJL%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJHMEUCIQDV18Oo7MTeIGlI5dOtfYcPgJihgt6FDR1N7k2Re3pOoQIgd2au0VvJR22CPbJITF8dyTwlJfvChE0kGUTSbQ9FdjQquAUIWxAFGgwyNzM1NzAxOTU0MzMiDNQweSErN9xBSEbB6CqVBQD9AWHl7ZavPNgiVYtx9UVNeFZ0V1sniRReACfzN%2Bix%2BeLQPFgM9r5oBgxIByyK2%2FTEKrFL45pXQ%2BuFznivv814j87KiRGsi79Eimtr5YMJjHT3q53I4epkPxZk9NcnZhIlqRuBIkiGbwYZ5aE7f52v9Nema6Q9WOgUp5D0zPYKGR%2F7ImtadOlKuZr80EWNJsVijrX%2BIpc5K5p6HDTNL8fMOaIn1OugbrHam7RaE3%2BVPHNQM8aDNttXQUeoXw6%2Bh1EFBombaIzaSkbe8S%2FWO4KtMtas92g%2BsM9DBvq6Syb5XCVVOCy3F3xYXXN9A%2Fhl9vZL5ekMqWYZ2PyqHx2ABklYwcFep0C%2Br7PdO9ej6ktmx4sCHe1YRNM96tLVEbkmMt4rF%2BbZ%2Bwr3kS4SZidjECc8f%2F5D4IAdCk%2FnUG%2BwMXofrDurtYUiNKDYWmYBu2OYWWHTAezIpW1fUGOZ5fNYAg7JQN5Z2oZSREdDzDUCs%2BNvDb7SzsqlWZsA11sXrhz%2FFK9MBKeTY0XH7So6E1Vu%2BNxj2s%2BqiadUFabL8gSKj8iLCgl6scoYx2h8L4ClZ416e4YOGRikVH3EhyYO2skfqVD%2BI60Q3jZGa7FEpDk6jlvH6abFLw4YdDw9R%2Bthm1hpirjzq38490VECXvOfiSWLF19PbRn6N9VjRdEQ4Bi9qCCx2IvLVnmEOSduLJaENzkSQmOd5jhBmtlTGctlJM5OXr0fr1pV%2B9lKSYd%2FOSQxyFriizl5dH2xUshr1%2B7XEupvHo%2B0zaJsU6jLY4lyQXbPqRPEC2nnS6fphoXf7ovNHNOTMDuM7Uvlp5xBu7QHj541%2FZnBwhHHW8aMBqGg6kf%2FBjQ%2FdoCWjHh5M85dA2TTUntR%2BeU7YYww%2FGlzwY6sQGVBTThexnBSQFhdBlQoGAWKaVVhUE79sQKe3ikVZRXjZbewdIxTgHU8N4TMFjITHrAvIC2tmcIKO6nWFa2qw1mxOelb7rkregF9nxAaWD6ZE5L1PfCYUoz9JfjU6OqtNSVHN2HNjh80fyHmgBCnMfOk4wQrSgUL3ByiNegqTLxBxE%2BLgIi0Cd%2BIiVMWpbUOllluZKWn%2B%2FDO%2Fx1JYHGTZ%2FpSbJqqLh2eqXCXNvMYKhKGpg%3D&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47UWS26F442%2F20260423%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260423T023626Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=99f7663b45036ad5a5109517c07c8cb98ca5017f9754f3bb56d4f23f1a390693 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=IQoJb3JpZ2luX2VjEJL%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJHMEUCIQDV18Oo7MTeIGlI5dOtfYcPgJihgt6FDR1N7k2Re3pOoQIgd2au0VvJR22CPbJITF8dyTwlJfvChE0kGUTSbQ9FdjQquAUIWxAFGgwyNzM1NzAxOTU0MzMiDNQweSErN9xBSEbB6CqVBQD9AWHl7ZavPNgiVYtx9UVNeFZ0V1sniRReACfzN%2Bix%2BeLQPFgM9r5oBgxIByyK2%2FTEKrFL45pXQ%2BuFznivv814j87KiRGsi79Eimtr5YMJjHT3q53I4epkPxZk9NcnZhIlqRuBIkiGbwYZ5aE7f52v9Nema6Q9WOgUp5D0zPYKGR%2F7ImtadOlKuZr80EWNJsVijrX%2BIpc5K5p6HDTNL8fMOaIn1OugbrHam7RaE3%2BVPHNQM8aDNttXQUeoXw6%2Bh1EFBombaIzaSkbe8S%2FWO4KtMtas92g%2BsM9DBvq6Syb5XCVVOCy3F3xYXXN9A%2Fhl9vZL5ekMqWYZ2PyqHx2ABklYwcFep0C%2Br7PdO9ej6ktmx4sCHe1YRNM96tLVEbkmMt4rF%2BbZ%2Bwr3kS4SZidjECc8f%2F5D4IAdCk%2FnUG%2BwMXofrDurtYUiNKDYWmYBu2OYWWHTAezIpW1fUGOZ5fNYAg7JQN5Z2oZSREdDzDUCs%2BNvDb7SzsqlWZsA11sXrhz%2FFK9MBKeTY0XH7So6E1Vu%2BNxj2s%2BqiadUFabL8gSKj8iLCgl6scoYx2h8L4ClZ416e4YOGRikVH3EhyYO2skfqVD%2BI60Q3jZGa7FEpDk6jlvH6abFLw4YdDw9R%2Bthm1hpirjzq38490VECXvOfiSWLF19PbRn6N9VjRdEQ4Bi9qCCx2IvLVnmEOSduLJaENzkSQmOd5jhBmtlTGctlJM5OXr0fr1pV%2B9lKSYd%2FOSQxyFriizl5dH2xUshr1%2B7XEupvHo%2B0zaJsU6jLY4lyQXbPqRPEC2nnS6fphoXf7ovNHNOTMDuM7Uvlp5xBu7QHj541%2FZnBwhHHW8aMBqGg6kf%2FBjQ%2FdoCWjHh5M85dA2TTUntR%2BeU7YYww%2FGlzwY6sQGVBTThexnBSQFhdBlQoGAWKaVVhUE79sQKe3ikVZRXjZbewdIxTgHU8N4TMFjITHrAvIC2tmcIKO6nWFa2qw1mxOelb7rkregF9nxAaWD6ZE5L1PfCYUoz9JfjU6OqtNSVHN2HNjh80fyHmgBCnMfOk4wQrSgUL3ByiNegqTLxBxE%2BLgIi0Cd%2BIiVMWpbUOllluZKWn%2B%2FDO%2Fx1JYHGTZ%2FpSbJqqLh2eqXCXNvMYKhKGpg%3D&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47UWS26F442%2F20260423%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260423T023626Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=99f7663b45036ad5a5109517c07c8cb98ca5017f9754f3bb56d4f23f1a390693\" 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}]}}