{"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=IQoJb3JpZ2luX2VjEGUaCWV1LXdlc3QtMSJIMEYCIQCCbvlJ4%2FNAkmCAKgGb1Z8VDr8gHJRXNSbNEmPqNAaOHgIhALJZmGFUPAYmYq6%2B7OnnVqDbFjbPgjO1psChn3lsM%2B6kKrkFCC4QBRoMMjczNTcwMTk1NDMzIgws29j7N4%2FJOWuFpBAqlgXOOffrSF9dyPy%2BA3PDW%2BoS4d8EHVtpAIm08HG%2BoA6VqI0wI3DDMXQ0M0U4zVPc3Fu5x5Sqm%2FomHcidwLQwD%2FddwuumS4iFGHIUDxKPIW7PYNRP%2BfsQj1KA6X1HQumZWmCgxOQTVd7PWUU3Dz3%2B17JmlAw0a4AzFvB1jDhHYjjqV4IPWj87DyV0ddHabn4lodrJbtrW0TD6mcQxjhCs8sUCWmLr632UX6kxS6i6Hd43mdZFnN5e6JdzGxnTSRTUPVCXani5fwClGlDOlRl6GA9MF1RTQiFbETCvNohaPbwv0R3VDNu24bNORBZ5IhcL%2BGCmKWATjB58Gt0iF9LCqyYtS3YGhwHY12Ds%2FgQLBR7Cs0Uc6CqIz918goh5YPkZ%2FOleJVCppUtmyUCTDq5pp6JvwtzzWEy7etRfNFsR6e%2BHkcJb7tGFWOdQ%2FqmiBSa7zWqmlw%2FJp4pXHMke4iPb6fDvWJVnl5ZNKZ8wdrp2s6uUR5ah%2Bb7vLXg0frMLLtn%2FSHZA6as1tP0Fgx2oR18yijBA8RlhcajWtnAFCOMqswn31wJ4xvvCDPmcoLf%2B74xg6HuPtucEEEAxEjAkul62nqp4pBLdK6u%2F%2FflCdZ%2FxHwuvBr%2FJh6kyKbU2QqdsOQESCyQT9oHjfh9A97zybLRZc6%2Fb3kPtn%2BT05O7Bnf0NRNQQkCXxUxkUni660giUV%2FPO0fHYss1yqYzpozFsRvYbxR6shH%2FCp43vzjF1F2uSkgmfUvv7D5et%2F2IPRzhDwmP3mnGdx0zTh9TyCX2MLD9HMkJkNUeAMRrFQAD38PxzrWU3NoLNg57fFNBwcIItcUTNlBHNUJrH0l9vPF%2BDsY%2BXLBMCn90iTr3iHFLY2A%2FPQKhGAYFwPcZbUjCthP3QBjqwAUsu4Z4AuOHcuZtg9M7jXbRINJAuEUcW7e7fEEuoIfzZgMmNmI7X7GNlb7dX1u%2Bay49F3rgbxWTI654%2B2myuUreK9YvnzfFZZ7DzvyMXsEhxbS%2FzkY2S%2FVQb9aiAaMh%2FOwwyWZGXnAqyGOXH3qNJNBPoQGH6XMLf%2BH8wWvBPlx5dnd8OSjx6gAHI4ESuU340G%2FDp8Tpv%2Ft90Sm2x60pBI9hii6kYSMk%2B1R%2BACJpEixAV&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47U7RYHY7BA%2F20260602%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260602T211449Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=99afa29d4baaf5a410beaf13fbc5152613bb3111c48f3263212b8c6b9d493f34\" 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=IQoJb3JpZ2luX2VjEGUaCWV1LXdlc3QtMSJIMEYCIQCCbvlJ4%2FNAkmCAKgGb1Z8VDr8gHJRXNSbNEmPqNAaOHgIhALJZmGFUPAYmYq6%2B7OnnVqDbFjbPgjO1psChn3lsM%2B6kKrkFCC4QBRoMMjczNTcwMTk1NDMzIgws29j7N4%2FJOWuFpBAqlgXOOffrSF9dyPy%2BA3PDW%2BoS4d8EHVtpAIm08HG%2BoA6VqI0wI3DDMXQ0M0U4zVPc3Fu5x5Sqm%2FomHcidwLQwD%2FddwuumS4iFGHIUDxKPIW7PYNRP%2BfsQj1KA6X1HQumZWmCgxOQTVd7PWUU3Dz3%2B17JmlAw0a4AzFvB1jDhHYjjqV4IPWj87DyV0ddHabn4lodrJbtrW0TD6mcQxjhCs8sUCWmLr632UX6kxS6i6Hd43mdZFnN5e6JdzGxnTSRTUPVCXani5fwClGlDOlRl6GA9MF1RTQiFbETCvNohaPbwv0R3VDNu24bNORBZ5IhcL%2BGCmKWATjB58Gt0iF9LCqyYtS3YGhwHY12Ds%2FgQLBR7Cs0Uc6CqIz918goh5YPkZ%2FOleJVCppUtmyUCTDq5pp6JvwtzzWEy7etRfNFsR6e%2BHkcJb7tGFWOdQ%2FqmiBSa7zWqmlw%2FJp4pXHMke4iPb6fDvWJVnl5ZNKZ8wdrp2s6uUR5ah%2Bb7vLXg0frMLLtn%2FSHZA6as1tP0Fgx2oR18yijBA8RlhcajWtnAFCOMqswn31wJ4xvvCDPmcoLf%2B74xg6HuPtucEEEAxEjAkul62nqp4pBLdK6u%2F%2FflCdZ%2FxHwuvBr%2FJh6kyKbU2QqdsOQESCyQT9oHjfh9A97zybLRZc6%2Fb3kPtn%2BT05O7Bnf0NRNQQkCXxUxkUni660giUV%2FPO0fHYss1yqYzpozFsRvYbxR6shH%2FCp43vzjF1F2uSkgmfUvv7D5et%2F2IPRzhDwmP3mnGdx0zTh9TyCX2MLD9HMkJkNUeAMRrFQAD38PxzrWU3NoLNg57fFNBwcIItcUTNlBHNUJrH0l9vPF%2BDsY%2BXLBMCn90iTr3iHFLY2A%2FPQKhGAYFwPcZbUjCthP3QBjqwAUsu4Z4AuOHcuZtg9M7jXbRINJAuEUcW7e7fEEuoIfzZgMmNmI7X7GNlb7dX1u%2Bay49F3rgbxWTI654%2B2myuUreK9YvnzfFZZ7DzvyMXsEhxbS%2FzkY2S%2FVQb9aiAaMh%2FOwwyWZGXnAqyGOXH3qNJNBPoQGH6XMLf%2BH8wWvBPlx5dnd8OSjx6gAHI4ESuU340G%2FDp8Tpv%2Ft90Sm2x60pBI9hii6kYSMk%2B1R%2BACJpEixAV&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47U7RYHY7BA%2F20260602%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260602T211449Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=99afa29d4baaf5a410beaf13fbc5152613bb3111c48f3263212b8c6b9d493f34 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=IQoJb3JpZ2luX2VjEGUaCWV1LXdlc3QtMSJIMEYCIQCCbvlJ4%2FNAkmCAKgGb1Z8VDr8gHJRXNSbNEmPqNAaOHgIhALJZmGFUPAYmYq6%2B7OnnVqDbFjbPgjO1psChn3lsM%2B6kKrkFCC4QBRoMMjczNTcwMTk1NDMzIgws29j7N4%2FJOWuFpBAqlgXOOffrSF9dyPy%2BA3PDW%2BoS4d8EHVtpAIm08HG%2BoA6VqI0wI3DDMXQ0M0U4zVPc3Fu5x5Sqm%2FomHcidwLQwD%2FddwuumS4iFGHIUDxKPIW7PYNRP%2BfsQj1KA6X1HQumZWmCgxOQTVd7PWUU3Dz3%2B17JmlAw0a4AzFvB1jDhHYjjqV4IPWj87DyV0ddHabn4lodrJbtrW0TD6mcQxjhCs8sUCWmLr632UX6kxS6i6Hd43mdZFnN5e6JdzGxnTSRTUPVCXani5fwClGlDOlRl6GA9MF1RTQiFbETCvNohaPbwv0R3VDNu24bNORBZ5IhcL%2BGCmKWATjB58Gt0iF9LCqyYtS3YGhwHY12Ds%2FgQLBR7Cs0Uc6CqIz918goh5YPkZ%2FOleJVCppUtmyUCTDq5pp6JvwtzzWEy7etRfNFsR6e%2BHkcJb7tGFWOdQ%2FqmiBSa7zWqmlw%2FJp4pXHMke4iPb6fDvWJVnl5ZNKZ8wdrp2s6uUR5ah%2Bb7vLXg0frMLLtn%2FSHZA6as1tP0Fgx2oR18yijBA8RlhcajWtnAFCOMqswn31wJ4xvvCDPmcoLf%2B74xg6HuPtucEEEAxEjAkul62nqp4pBLdK6u%2F%2FflCdZ%2FxHwuvBr%2FJh6kyKbU2QqdsOQESCyQT9oHjfh9A97zybLRZc6%2Fb3kPtn%2BT05O7Bnf0NRNQQkCXxUxkUni660giUV%2FPO0fHYss1yqYzpozFsRvYbxR6shH%2FCp43vzjF1F2uSkgmfUvv7D5et%2F2IPRzhDwmP3mnGdx0zTh9TyCX2MLD9HMkJkNUeAMRrFQAD38PxzrWU3NoLNg57fFNBwcIItcUTNlBHNUJrH0l9vPF%2BDsY%2BXLBMCn90iTr3iHFLY2A%2FPQKhGAYFwPcZbUjCthP3QBjqwAUsu4Z4AuOHcuZtg9M7jXbRINJAuEUcW7e7fEEuoIfzZgMmNmI7X7GNlb7dX1u%2Bay49F3rgbxWTI654%2B2myuUreK9YvnzfFZZ7DzvyMXsEhxbS%2FzkY2S%2FVQb9aiAaMh%2FOwwyWZGXnAqyGOXH3qNJNBPoQGH6XMLf%2BH8wWvBPlx5dnd8OSjx6gAHI4ESuU340G%2FDp8Tpv%2Ft90Sm2x60pBI9hii6kYSMk%2B1R%2BACJpEixAV&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47U7RYHY7BA%2F20260602%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260602T211449Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=78bd9e0428662f963020cfc60ce17d4d717a4aeef3eb4cf3ce71dffdd7a4df98 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=IQoJb3JpZ2luX2VjEGUaCWV1LXdlc3QtMSJIMEYCIQCCbvlJ4%2FNAkmCAKgGb1Z8VDr8gHJRXNSbNEmPqNAaOHgIhALJZmGFUPAYmYq6%2B7OnnVqDbFjbPgjO1psChn3lsM%2B6kKrkFCC4QBRoMMjczNTcwMTk1NDMzIgws29j7N4%2FJOWuFpBAqlgXOOffrSF9dyPy%2BA3PDW%2BoS4d8EHVtpAIm08HG%2BoA6VqI0wI3DDMXQ0M0U4zVPc3Fu5x5Sqm%2FomHcidwLQwD%2FddwuumS4iFGHIUDxKPIW7PYNRP%2BfsQj1KA6X1HQumZWmCgxOQTVd7PWUU3Dz3%2B17JmlAw0a4AzFvB1jDhHYjjqV4IPWj87DyV0ddHabn4lodrJbtrW0TD6mcQxjhCs8sUCWmLr632UX6kxS6i6Hd43mdZFnN5e6JdzGxnTSRTUPVCXani5fwClGlDOlRl6GA9MF1RTQiFbETCvNohaPbwv0R3VDNu24bNORBZ5IhcL%2BGCmKWATjB58Gt0iF9LCqyYtS3YGhwHY12Ds%2FgQLBR7Cs0Uc6CqIz918goh5YPkZ%2FOleJVCppUtmyUCTDq5pp6JvwtzzWEy7etRfNFsR6e%2BHkcJb7tGFWOdQ%2FqmiBSa7zWqmlw%2FJp4pXHMke4iPb6fDvWJVnl5ZNKZ8wdrp2s6uUR5ah%2Bb7vLXg0frMLLtn%2FSHZA6as1tP0Fgx2oR18yijBA8RlhcajWtnAFCOMqswn31wJ4xvvCDPmcoLf%2B74xg6HuPtucEEEAxEjAkul62nqp4pBLdK6u%2F%2FflCdZ%2FxHwuvBr%2FJh6kyKbU2QqdsOQESCyQT9oHjfh9A97zybLRZc6%2Fb3kPtn%2BT05O7Bnf0NRNQQkCXxUxkUni660giUV%2FPO0fHYss1yqYzpozFsRvYbxR6shH%2FCp43vzjF1F2uSkgmfUvv7D5et%2F2IPRzhDwmP3mnGdx0zTh9TyCX2MLD9HMkJkNUeAMRrFQAD38PxzrWU3NoLNg57fFNBwcIItcUTNlBHNUJrH0l9vPF%2BDsY%2BXLBMCn90iTr3iHFLY2A%2FPQKhGAYFwPcZbUjCthP3QBjqwAUsu4Z4AuOHcuZtg9M7jXbRINJAuEUcW7e7fEEuoIfzZgMmNmI7X7GNlb7dX1u%2Bay49F3rgbxWTI654%2B2myuUreK9YvnzfFZZ7DzvyMXsEhxbS%2FzkY2S%2FVQb9aiAaMh%2FOwwyWZGXnAqyGOXH3qNJNBPoQGH6XMLf%2BH8wWvBPlx5dnd8OSjx6gAHI4ESuU340G%2FDp8Tpv%2Ft90Sm2x60pBI9hii6kYSMk%2B1R%2BACJpEixAV&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47U7RYHY7BA%2F20260602%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260602T211449Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=78bd9e0428662f963020cfc60ce17d4d717a4aeef3eb4cf3ce71dffdd7a4df98\" 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=IQoJb3JpZ2luX2VjEGUaCWV1LXdlc3QtMSJIMEYCIQCCbvlJ4%2FNAkmCAKgGb1Z8VDr8gHJRXNSbNEmPqNAaOHgIhALJZmGFUPAYmYq6%2B7OnnVqDbFjbPgjO1psChn3lsM%2B6kKrkFCC4QBRoMMjczNTcwMTk1NDMzIgws29j7N4%2FJOWuFpBAqlgXOOffrSF9dyPy%2BA3PDW%2BoS4d8EHVtpAIm08HG%2BoA6VqI0wI3DDMXQ0M0U4zVPc3Fu5x5Sqm%2FomHcidwLQwD%2FddwuumS4iFGHIUDxKPIW7PYNRP%2BfsQj1KA6X1HQumZWmCgxOQTVd7PWUU3Dz3%2B17JmlAw0a4AzFvB1jDhHYjjqV4IPWj87DyV0ddHabn4lodrJbtrW0TD6mcQxjhCs8sUCWmLr632UX6kxS6i6Hd43mdZFnN5e6JdzGxnTSRTUPVCXani5fwClGlDOlRl6GA9MF1RTQiFbETCvNohaPbwv0R3VDNu24bNORBZ5IhcL%2BGCmKWATjB58Gt0iF9LCqyYtS3YGhwHY12Ds%2FgQLBR7Cs0Uc6CqIz918goh5YPkZ%2FOleJVCppUtmyUCTDq5pp6JvwtzzWEy7etRfNFsR6e%2BHkcJb7tGFWOdQ%2FqmiBSa7zWqmlw%2FJp4pXHMke4iPb6fDvWJVnl5ZNKZ8wdrp2s6uUR5ah%2Bb7vLXg0frMLLtn%2FSHZA6as1tP0Fgx2oR18yijBA8RlhcajWtnAFCOMqswn31wJ4xvvCDPmcoLf%2B74xg6HuPtucEEEAxEjAkul62nqp4pBLdK6u%2F%2FflCdZ%2FxHwuvBr%2FJh6kyKbU2QqdsOQESCyQT9oHjfh9A97zybLRZc6%2Fb3kPtn%2BT05O7Bnf0NRNQQkCXxUxkUni660giUV%2FPO0fHYss1yqYzpozFsRvYbxR6shH%2FCp43vzjF1F2uSkgmfUvv7D5et%2F2IPRzhDwmP3mnGdx0zTh9TyCX2MLD9HMkJkNUeAMRrFQAD38PxzrWU3NoLNg57fFNBwcIItcUTNlBHNUJrH0l9vPF%2BDsY%2BXLBMCn90iTr3iHFLY2A%2FPQKhGAYFwPcZbUjCthP3QBjqwAUsu4Z4AuOHcuZtg9M7jXbRINJAuEUcW7e7fEEuoIfzZgMmNmI7X7GNlb7dX1u%2Bay49F3rgbxWTI654%2B2myuUreK9YvnzfFZZ7DzvyMXsEhxbS%2FzkY2S%2FVQb9aiAaMh%2FOwwyWZGXnAqyGOXH3qNJNBPoQGH6XMLf%2BH8wWvBPlx5dnd8OSjx6gAHI4ESuU340G%2FDp8Tpv%2Ft90Sm2x60pBI9hii6kYSMk%2B1R%2BACJpEixAV&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47U7RYHY7BA%2F20260602%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260602T211449Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=7e15a0918e4c8a4a71da9fe900e358453d22700d6ab0560238980add77c1471a\" 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=IQoJb3JpZ2luX2VjEGUaCWV1LXdlc3QtMSJIMEYCIQCCbvlJ4%2FNAkmCAKgGb1Z8VDr8gHJRXNSbNEmPqNAaOHgIhALJZmGFUPAYmYq6%2B7OnnVqDbFjbPgjO1psChn3lsM%2B6kKrkFCC4QBRoMMjczNTcwMTk1NDMzIgws29j7N4%2FJOWuFpBAqlgXOOffrSF9dyPy%2BA3PDW%2BoS4d8EHVtpAIm08HG%2BoA6VqI0wI3DDMXQ0M0U4zVPc3Fu5x5Sqm%2FomHcidwLQwD%2FddwuumS4iFGHIUDxKPIW7PYNRP%2BfsQj1KA6X1HQumZWmCgxOQTVd7PWUU3Dz3%2B17JmlAw0a4AzFvB1jDhHYjjqV4IPWj87DyV0ddHabn4lodrJbtrW0TD6mcQxjhCs8sUCWmLr632UX6kxS6i6Hd43mdZFnN5e6JdzGxnTSRTUPVCXani5fwClGlDOlRl6GA9MF1RTQiFbETCvNohaPbwv0R3VDNu24bNORBZ5IhcL%2BGCmKWATjB58Gt0iF9LCqyYtS3YGhwHY12Ds%2FgQLBR7Cs0Uc6CqIz918goh5YPkZ%2FOleJVCppUtmyUCTDq5pp6JvwtzzWEy7etRfNFsR6e%2BHkcJb7tGFWOdQ%2FqmiBSa7zWqmlw%2FJp4pXHMke4iPb6fDvWJVnl5ZNKZ8wdrp2s6uUR5ah%2Bb7vLXg0frMLLtn%2FSHZA6as1tP0Fgx2oR18yijBA8RlhcajWtnAFCOMqswn31wJ4xvvCDPmcoLf%2B74xg6HuPtucEEEAxEjAkul62nqp4pBLdK6u%2F%2FflCdZ%2FxHwuvBr%2FJh6kyKbU2QqdsOQESCyQT9oHjfh9A97zybLRZc6%2Fb3kPtn%2BT05O7Bnf0NRNQQkCXxUxkUni660giUV%2FPO0fHYss1yqYzpozFsRvYbxR6shH%2FCp43vzjF1F2uSkgmfUvv7D5et%2F2IPRzhDwmP3mnGdx0zTh9TyCX2MLD9HMkJkNUeAMRrFQAD38PxzrWU3NoLNg57fFNBwcIItcUTNlBHNUJrH0l9vPF%2BDsY%2BXLBMCn90iTr3iHFLY2A%2FPQKhGAYFwPcZbUjCthP3QBjqwAUsu4Z4AuOHcuZtg9M7jXbRINJAuEUcW7e7fEEuoIfzZgMmNmI7X7GNlb7dX1u%2Bay49F3rgbxWTI654%2B2myuUreK9YvnzfFZZ7DzvyMXsEhxbS%2FzkY2S%2FVQb9aiAaMh%2FOwwyWZGXnAqyGOXH3qNJNBPoQGH6XMLf%2BH8wWvBPlx5dnd8OSjx6gAHI4ESuU340G%2FDp8Tpv%2Ft90Sm2x60pBI9hii6kYSMk%2B1R%2BACJpEixAV&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47U7RYHY7BA%2F20260602%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260602T211449Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=7e15a0918e4c8a4a71da9fe900e358453d22700d6ab0560238980add77c1471a 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=IQoJb3JpZ2luX2VjEGUaCWV1LXdlc3QtMSJIMEYCIQCCbvlJ4%2FNAkmCAKgGb1Z8VDr8gHJRXNSbNEmPqNAaOHgIhALJZmGFUPAYmYq6%2B7OnnVqDbFjbPgjO1psChn3lsM%2B6kKrkFCC4QBRoMMjczNTcwMTk1NDMzIgws29j7N4%2FJOWuFpBAqlgXOOffrSF9dyPy%2BA3PDW%2BoS4d8EHVtpAIm08HG%2BoA6VqI0wI3DDMXQ0M0U4zVPc3Fu5x5Sqm%2FomHcidwLQwD%2FddwuumS4iFGHIUDxKPIW7PYNRP%2BfsQj1KA6X1HQumZWmCgxOQTVd7PWUU3Dz3%2B17JmlAw0a4AzFvB1jDhHYjjqV4IPWj87DyV0ddHabn4lodrJbtrW0TD6mcQxjhCs8sUCWmLr632UX6kxS6i6Hd43mdZFnN5e6JdzGxnTSRTUPVCXani5fwClGlDOlRl6GA9MF1RTQiFbETCvNohaPbwv0R3VDNu24bNORBZ5IhcL%2BGCmKWATjB58Gt0iF9LCqyYtS3YGhwHY12Ds%2FgQLBR7Cs0Uc6CqIz918goh5YPkZ%2FOleJVCppUtmyUCTDq5pp6JvwtzzWEy7etRfNFsR6e%2BHkcJb7tGFWOdQ%2FqmiBSa7zWqmlw%2FJp4pXHMke4iPb6fDvWJVnl5ZNKZ8wdrp2s6uUR5ah%2Bb7vLXg0frMLLtn%2FSHZA6as1tP0Fgx2oR18yijBA8RlhcajWtnAFCOMqswn31wJ4xvvCDPmcoLf%2B74xg6HuPtucEEEAxEjAkul62nqp4pBLdK6u%2F%2FflCdZ%2FxHwuvBr%2FJh6kyKbU2QqdsOQESCyQT9oHjfh9A97zybLRZc6%2Fb3kPtn%2BT05O7Bnf0NRNQQkCXxUxkUni660giUV%2FPO0fHYss1yqYzpozFsRvYbxR6shH%2FCp43vzjF1F2uSkgmfUvv7D5et%2F2IPRzhDwmP3mnGdx0zTh9TyCX2MLD9HMkJkNUeAMRrFQAD38PxzrWU3NoLNg57fFNBwcIItcUTNlBHNUJrH0l9vPF%2BDsY%2BXLBMCn90iTr3iHFLY2A%2FPQKhGAYFwPcZbUjCthP3QBjqwAUsu4Z4AuOHcuZtg9M7jXbRINJAuEUcW7e7fEEuoIfzZgMmNmI7X7GNlb7dX1u%2Bay49F3rgbxWTI654%2B2myuUreK9YvnzfFZZ7DzvyMXsEhxbS%2FzkY2S%2FVQb9aiAaMh%2FOwwyWZGXnAqyGOXH3qNJNBPoQGH6XMLf%2BH8wWvBPlx5dnd8OSjx6gAHI4ESuU340G%2FDp8Tpv%2Ft90Sm2x60pBI9hii6kYSMk%2B1R%2BACJpEixAV&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47U7RYHY7BA%2F20260602%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260602T211449Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=6c60a41c64cb8700d3f239cf769f5765d3dbbd6113eafbcbb7de6eda811aa6cf 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=IQoJb3JpZ2luX2VjEGUaCWV1LXdlc3QtMSJIMEYCIQCCbvlJ4%2FNAkmCAKgGb1Z8VDr8gHJRXNSbNEmPqNAaOHgIhALJZmGFUPAYmYq6%2B7OnnVqDbFjbPgjO1psChn3lsM%2B6kKrkFCC4QBRoMMjczNTcwMTk1NDMzIgws29j7N4%2FJOWuFpBAqlgXOOffrSF9dyPy%2BA3PDW%2BoS4d8EHVtpAIm08HG%2BoA6VqI0wI3DDMXQ0M0U4zVPc3Fu5x5Sqm%2FomHcidwLQwD%2FddwuumS4iFGHIUDxKPIW7PYNRP%2BfsQj1KA6X1HQumZWmCgxOQTVd7PWUU3Dz3%2B17JmlAw0a4AzFvB1jDhHYjjqV4IPWj87DyV0ddHabn4lodrJbtrW0TD6mcQxjhCs8sUCWmLr632UX6kxS6i6Hd43mdZFnN5e6JdzGxnTSRTUPVCXani5fwClGlDOlRl6GA9MF1RTQiFbETCvNohaPbwv0R3VDNu24bNORBZ5IhcL%2BGCmKWATjB58Gt0iF9LCqyYtS3YGhwHY12Ds%2FgQLBR7Cs0Uc6CqIz918goh5YPkZ%2FOleJVCppUtmyUCTDq5pp6JvwtzzWEy7etRfNFsR6e%2BHkcJb7tGFWOdQ%2FqmiBSa7zWqmlw%2FJp4pXHMke4iPb6fDvWJVnl5ZNKZ8wdrp2s6uUR5ah%2Bb7vLXg0frMLLtn%2FSHZA6as1tP0Fgx2oR18yijBA8RlhcajWtnAFCOMqswn31wJ4xvvCDPmcoLf%2B74xg6HuPtucEEEAxEjAkul62nqp4pBLdK6u%2F%2FflCdZ%2FxHwuvBr%2FJh6kyKbU2QqdsOQESCyQT9oHjfh9A97zybLRZc6%2Fb3kPtn%2BT05O7Bnf0NRNQQkCXxUxkUni660giUV%2FPO0fHYss1yqYzpozFsRvYbxR6shH%2FCp43vzjF1F2uSkgmfUvv7D5et%2F2IPRzhDwmP3mnGdx0zTh9TyCX2MLD9HMkJkNUeAMRrFQAD38PxzrWU3NoLNg57fFNBwcIItcUTNlBHNUJrH0l9vPF%2BDsY%2BXLBMCn90iTr3iHFLY2A%2FPQKhGAYFwPcZbUjCthP3QBjqwAUsu4Z4AuOHcuZtg9M7jXbRINJAuEUcW7e7fEEuoIfzZgMmNmI7X7GNlb7dX1u%2Bay49F3rgbxWTI654%2B2myuUreK9YvnzfFZZ7DzvyMXsEhxbS%2FzkY2S%2FVQb9aiAaMh%2FOwwyWZGXnAqyGOXH3qNJNBPoQGH6XMLf%2BH8wWvBPlx5dnd8OSjx6gAHI4ESuU340G%2FDp8Tpv%2Ft90Sm2x60pBI9hii6kYSMk%2B1R%2BACJpEixAV&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47U7RYHY7BA%2F20260602%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260602T211449Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=6c60a41c64cb8700d3f239cf769f5765d3dbbd6113eafbcbb7de6eda811aa6cf\" 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=IQoJb3JpZ2luX2VjEGUaCWV1LXdlc3QtMSJIMEYCIQCCbvlJ4%2FNAkmCAKgGb1Z8VDr8gHJRXNSbNEmPqNAaOHgIhALJZmGFUPAYmYq6%2B7OnnVqDbFjbPgjO1psChn3lsM%2B6kKrkFCC4QBRoMMjczNTcwMTk1NDMzIgws29j7N4%2FJOWuFpBAqlgXOOffrSF9dyPy%2BA3PDW%2BoS4d8EHVtpAIm08HG%2BoA6VqI0wI3DDMXQ0M0U4zVPc3Fu5x5Sqm%2FomHcidwLQwD%2FddwuumS4iFGHIUDxKPIW7PYNRP%2BfsQj1KA6X1HQumZWmCgxOQTVd7PWUU3Dz3%2B17JmlAw0a4AzFvB1jDhHYjjqV4IPWj87DyV0ddHabn4lodrJbtrW0TD6mcQxjhCs8sUCWmLr632UX6kxS6i6Hd43mdZFnN5e6JdzGxnTSRTUPVCXani5fwClGlDOlRl6GA9MF1RTQiFbETCvNohaPbwv0R3VDNu24bNORBZ5IhcL%2BGCmKWATjB58Gt0iF9LCqyYtS3YGhwHY12Ds%2FgQLBR7Cs0Uc6CqIz918goh5YPkZ%2FOleJVCppUtmyUCTDq5pp6JvwtzzWEy7etRfNFsR6e%2BHkcJb7tGFWOdQ%2FqmiBSa7zWqmlw%2FJp4pXHMke4iPb6fDvWJVnl5ZNKZ8wdrp2s6uUR5ah%2Bb7vLXg0frMLLtn%2FSHZA6as1tP0Fgx2oR18yijBA8RlhcajWtnAFCOMqswn31wJ4xvvCDPmcoLf%2B74xg6HuPtucEEEAxEjAkul62nqp4pBLdK6u%2F%2FflCdZ%2FxHwuvBr%2FJh6kyKbU2QqdsOQESCyQT9oHjfh9A97zybLRZc6%2Fb3kPtn%2BT05O7Bnf0NRNQQkCXxUxkUni660giUV%2FPO0fHYss1yqYzpozFsRvYbxR6shH%2FCp43vzjF1F2uSkgmfUvv7D5et%2F2IPRzhDwmP3mnGdx0zTh9TyCX2MLD9HMkJkNUeAMRrFQAD38PxzrWU3NoLNg57fFNBwcIItcUTNlBHNUJrH0l9vPF%2BDsY%2BXLBMCn90iTr3iHFLY2A%2FPQKhGAYFwPcZbUjCthP3QBjqwAUsu4Z4AuOHcuZtg9M7jXbRINJAuEUcW7e7fEEuoIfzZgMmNmI7X7GNlb7dX1u%2Bay49F3rgbxWTI654%2B2myuUreK9YvnzfFZZ7DzvyMXsEhxbS%2FzkY2S%2FVQb9aiAaMh%2FOwwyWZGXnAqyGOXH3qNJNBPoQGH6XMLf%2BH8wWvBPlx5dnd8OSjx6gAHI4ESuU340G%2FDp8Tpv%2Ft90Sm2x60pBI9hii6kYSMk%2B1R%2BACJpEixAV&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47U7RYHY7BA%2F20260602%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260602T211449Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=99374ca3cdb7cc12188e8a866238367de4c9555cf58bf46a66df6a142476c30b\" 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=IQoJb3JpZ2luX2VjEGUaCWV1LXdlc3QtMSJIMEYCIQCCbvlJ4%2FNAkmCAKgGb1Z8VDr8gHJRXNSbNEmPqNAaOHgIhALJZmGFUPAYmYq6%2B7OnnVqDbFjbPgjO1psChn3lsM%2B6kKrkFCC4QBRoMMjczNTcwMTk1NDMzIgws29j7N4%2FJOWuFpBAqlgXOOffrSF9dyPy%2BA3PDW%2BoS4d8EHVtpAIm08HG%2BoA6VqI0wI3DDMXQ0M0U4zVPc3Fu5x5Sqm%2FomHcidwLQwD%2FddwuumS4iFGHIUDxKPIW7PYNRP%2BfsQj1KA6X1HQumZWmCgxOQTVd7PWUU3Dz3%2B17JmlAw0a4AzFvB1jDhHYjjqV4IPWj87DyV0ddHabn4lodrJbtrW0TD6mcQxjhCs8sUCWmLr632UX6kxS6i6Hd43mdZFnN5e6JdzGxnTSRTUPVCXani5fwClGlDOlRl6GA9MF1RTQiFbETCvNohaPbwv0R3VDNu24bNORBZ5IhcL%2BGCmKWATjB58Gt0iF9LCqyYtS3YGhwHY12Ds%2FgQLBR7Cs0Uc6CqIz918goh5YPkZ%2FOleJVCppUtmyUCTDq5pp6JvwtzzWEy7etRfNFsR6e%2BHkcJb7tGFWOdQ%2FqmiBSa7zWqmlw%2FJp4pXHMke4iPb6fDvWJVnl5ZNKZ8wdrp2s6uUR5ah%2Bb7vLXg0frMLLtn%2FSHZA6as1tP0Fgx2oR18yijBA8RlhcajWtnAFCOMqswn31wJ4xvvCDPmcoLf%2B74xg6HuPtucEEEAxEjAkul62nqp4pBLdK6u%2F%2FflCdZ%2FxHwuvBr%2FJh6kyKbU2QqdsOQESCyQT9oHjfh9A97zybLRZc6%2Fb3kPtn%2BT05O7Bnf0NRNQQkCXxUxkUni660giUV%2FPO0fHYss1yqYzpozFsRvYbxR6shH%2FCp43vzjF1F2uSkgmfUvv7D5et%2F2IPRzhDwmP3mnGdx0zTh9TyCX2MLD9HMkJkNUeAMRrFQAD38PxzrWU3NoLNg57fFNBwcIItcUTNlBHNUJrH0l9vPF%2BDsY%2BXLBMCn90iTr3iHFLY2A%2FPQKhGAYFwPcZbUjCthP3QBjqwAUsu4Z4AuOHcuZtg9M7jXbRINJAuEUcW7e7fEEuoIfzZgMmNmI7X7GNlb7dX1u%2Bay49F3rgbxWTI654%2B2myuUreK9YvnzfFZZ7DzvyMXsEhxbS%2FzkY2S%2FVQb9aiAaMh%2FOwwyWZGXnAqyGOXH3qNJNBPoQGH6XMLf%2BH8wWvBPlx5dnd8OSjx6gAHI4ESuU340G%2FDp8Tpv%2Ft90Sm2x60pBI9hii6kYSMk%2B1R%2BACJpEixAV&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47U7RYHY7BA%2F20260602%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260602T211449Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=99374ca3cdb7cc12188e8a866238367de4c9555cf58bf46a66df6a142476c30b 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=IQoJb3JpZ2luX2VjEGUaCWV1LXdlc3QtMSJIMEYCIQCCbvlJ4%2FNAkmCAKgGb1Z8VDr8gHJRXNSbNEmPqNAaOHgIhALJZmGFUPAYmYq6%2B7OnnVqDbFjbPgjO1psChn3lsM%2B6kKrkFCC4QBRoMMjczNTcwMTk1NDMzIgws29j7N4%2FJOWuFpBAqlgXOOffrSF9dyPy%2BA3PDW%2BoS4d8EHVtpAIm08HG%2BoA6VqI0wI3DDMXQ0M0U4zVPc3Fu5x5Sqm%2FomHcidwLQwD%2FddwuumS4iFGHIUDxKPIW7PYNRP%2BfsQj1KA6X1HQumZWmCgxOQTVd7PWUU3Dz3%2B17JmlAw0a4AzFvB1jDhHYjjqV4IPWj87DyV0ddHabn4lodrJbtrW0TD6mcQxjhCs8sUCWmLr632UX6kxS6i6Hd43mdZFnN5e6JdzGxnTSRTUPVCXani5fwClGlDOlRl6GA9MF1RTQiFbETCvNohaPbwv0R3VDNu24bNORBZ5IhcL%2BGCmKWATjB58Gt0iF9LCqyYtS3YGhwHY12Ds%2FgQLBR7Cs0Uc6CqIz918goh5YPkZ%2FOleJVCppUtmyUCTDq5pp6JvwtzzWEy7etRfNFsR6e%2BHkcJb7tGFWOdQ%2FqmiBSa7zWqmlw%2FJp4pXHMke4iPb6fDvWJVnl5ZNKZ8wdrp2s6uUR5ah%2Bb7vLXg0frMLLtn%2FSHZA6as1tP0Fgx2oR18yijBA8RlhcajWtnAFCOMqswn31wJ4xvvCDPmcoLf%2B74xg6HuPtucEEEAxEjAkul62nqp4pBLdK6u%2F%2FflCdZ%2FxHwuvBr%2FJh6kyKbU2QqdsOQESCyQT9oHjfh9A97zybLRZc6%2Fb3kPtn%2BT05O7Bnf0NRNQQkCXxUxkUni660giUV%2FPO0fHYss1yqYzpozFsRvYbxR6shH%2FCp43vzjF1F2uSkgmfUvv7D5et%2F2IPRzhDwmP3mnGdx0zTh9TyCX2MLD9HMkJkNUeAMRrFQAD38PxzrWU3NoLNg57fFNBwcIItcUTNlBHNUJrH0l9vPF%2BDsY%2BXLBMCn90iTr3iHFLY2A%2FPQKhGAYFwPcZbUjCthP3QBjqwAUsu4Z4AuOHcuZtg9M7jXbRINJAuEUcW7e7fEEuoIfzZgMmNmI7X7GNlb7dX1u%2Bay49F3rgbxWTI654%2B2myuUreK9YvnzfFZZ7DzvyMXsEhxbS%2FzkY2S%2FVQb9aiAaMh%2FOwwyWZGXnAqyGOXH3qNJNBPoQGH6XMLf%2BH8wWvBPlx5dnd8OSjx6gAHI4ESuU340G%2FDp8Tpv%2Ft90Sm2x60pBI9hii6kYSMk%2B1R%2BACJpEixAV&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47U7RYHY7BA%2F20260602%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260602T211449Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=71bf640a9a444195336cf1679c2ca1067626b8bf210fa36aba49ab999f1b68e2 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=IQoJb3JpZ2luX2VjEGUaCWV1LXdlc3QtMSJIMEYCIQCCbvlJ4%2FNAkmCAKgGb1Z8VDr8gHJRXNSbNEmPqNAaOHgIhALJZmGFUPAYmYq6%2B7OnnVqDbFjbPgjO1psChn3lsM%2B6kKrkFCC4QBRoMMjczNTcwMTk1NDMzIgws29j7N4%2FJOWuFpBAqlgXOOffrSF9dyPy%2BA3PDW%2BoS4d8EHVtpAIm08HG%2BoA6VqI0wI3DDMXQ0M0U4zVPc3Fu5x5Sqm%2FomHcidwLQwD%2FddwuumS4iFGHIUDxKPIW7PYNRP%2BfsQj1KA6X1HQumZWmCgxOQTVd7PWUU3Dz3%2B17JmlAw0a4AzFvB1jDhHYjjqV4IPWj87DyV0ddHabn4lodrJbtrW0TD6mcQxjhCs8sUCWmLr632UX6kxS6i6Hd43mdZFnN5e6JdzGxnTSRTUPVCXani5fwClGlDOlRl6GA9MF1RTQiFbETCvNohaPbwv0R3VDNu24bNORBZ5IhcL%2BGCmKWATjB58Gt0iF9LCqyYtS3YGhwHY12Ds%2FgQLBR7Cs0Uc6CqIz918goh5YPkZ%2FOleJVCppUtmyUCTDq5pp6JvwtzzWEy7etRfNFsR6e%2BHkcJb7tGFWOdQ%2FqmiBSa7zWqmlw%2FJp4pXHMke4iPb6fDvWJVnl5ZNKZ8wdrp2s6uUR5ah%2Bb7vLXg0frMLLtn%2FSHZA6as1tP0Fgx2oR18yijBA8RlhcajWtnAFCOMqswn31wJ4xvvCDPmcoLf%2B74xg6HuPtucEEEAxEjAkul62nqp4pBLdK6u%2F%2FflCdZ%2FxHwuvBr%2FJh6kyKbU2QqdsOQESCyQT9oHjfh9A97zybLRZc6%2Fb3kPtn%2BT05O7Bnf0NRNQQkCXxUxkUni660giUV%2FPO0fHYss1yqYzpozFsRvYbxR6shH%2FCp43vzjF1F2uSkgmfUvv7D5et%2F2IPRzhDwmP3mnGdx0zTh9TyCX2MLD9HMkJkNUeAMRrFQAD38PxzrWU3NoLNg57fFNBwcIItcUTNlBHNUJrH0l9vPF%2BDsY%2BXLBMCn90iTr3iHFLY2A%2FPQKhGAYFwPcZbUjCthP3QBjqwAUsu4Z4AuOHcuZtg9M7jXbRINJAuEUcW7e7fEEuoIfzZgMmNmI7X7GNlb7dX1u%2Bay49F3rgbxWTI654%2B2myuUreK9YvnzfFZZ7DzvyMXsEhxbS%2FzkY2S%2FVQb9aiAaMh%2FOwwyWZGXnAqyGOXH3qNJNBPoQGH6XMLf%2BH8wWvBPlx5dnd8OSjx6gAHI4ESuU340G%2FDp8Tpv%2Ft90Sm2x60pBI9hii6kYSMk%2B1R%2BACJpEixAV&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47U7RYHY7BA%2F20260602%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260602T211449Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=71bf640a9a444195336cf1679c2ca1067626b8bf210fa36aba49ab999f1b68e2\" 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=IQoJb3JpZ2luX2VjEGUaCWV1LXdlc3QtMSJIMEYCIQCCbvlJ4%2FNAkmCAKgGb1Z8VDr8gHJRXNSbNEmPqNAaOHgIhALJZmGFUPAYmYq6%2B7OnnVqDbFjbPgjO1psChn3lsM%2B6kKrkFCC4QBRoMMjczNTcwMTk1NDMzIgws29j7N4%2FJOWuFpBAqlgXOOffrSF9dyPy%2BA3PDW%2BoS4d8EHVtpAIm08HG%2BoA6VqI0wI3DDMXQ0M0U4zVPc3Fu5x5Sqm%2FomHcidwLQwD%2FddwuumS4iFGHIUDxKPIW7PYNRP%2BfsQj1KA6X1HQumZWmCgxOQTVd7PWUU3Dz3%2B17JmlAw0a4AzFvB1jDhHYjjqV4IPWj87DyV0ddHabn4lodrJbtrW0TD6mcQxjhCs8sUCWmLr632UX6kxS6i6Hd43mdZFnN5e6JdzGxnTSRTUPVCXani5fwClGlDOlRl6GA9MF1RTQiFbETCvNohaPbwv0R3VDNu24bNORBZ5IhcL%2BGCmKWATjB58Gt0iF9LCqyYtS3YGhwHY12Ds%2FgQLBR7Cs0Uc6CqIz918goh5YPkZ%2FOleJVCppUtmyUCTDq5pp6JvwtzzWEy7etRfNFsR6e%2BHkcJb7tGFWOdQ%2FqmiBSa7zWqmlw%2FJp4pXHMke4iPb6fDvWJVnl5ZNKZ8wdrp2s6uUR5ah%2Bb7vLXg0frMLLtn%2FSHZA6as1tP0Fgx2oR18yijBA8RlhcajWtnAFCOMqswn31wJ4xvvCDPmcoLf%2B74xg6HuPtucEEEAxEjAkul62nqp4pBLdK6u%2F%2FflCdZ%2FxHwuvBr%2FJh6kyKbU2QqdsOQESCyQT9oHjfh9A97zybLRZc6%2Fb3kPtn%2BT05O7Bnf0NRNQQkCXxUxkUni660giUV%2FPO0fHYss1yqYzpozFsRvYbxR6shH%2FCp43vzjF1F2uSkgmfUvv7D5et%2F2IPRzhDwmP3mnGdx0zTh9TyCX2MLD9HMkJkNUeAMRrFQAD38PxzrWU3NoLNg57fFNBwcIItcUTNlBHNUJrH0l9vPF%2BDsY%2BXLBMCn90iTr3iHFLY2A%2FPQKhGAYFwPcZbUjCthP3QBjqwAUsu4Z4AuOHcuZtg9M7jXbRINJAuEUcW7e7fEEuoIfzZgMmNmI7X7GNlb7dX1u%2Bay49F3rgbxWTI654%2B2myuUreK9YvnzfFZZ7DzvyMXsEhxbS%2FzkY2S%2FVQb9aiAaMh%2FOwwyWZGXnAqyGOXH3qNJNBPoQGH6XMLf%2BH8wWvBPlx5dnd8OSjx6gAHI4ESuU340G%2FDp8Tpv%2Ft90Sm2x60pBI9hii6kYSMk%2B1R%2BACJpEixAV&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47U7RYHY7BA%2F20260602%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260602T211449Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=8a8d30a8290fbcce7ba07d2dce9748d7590bcf3a08bcd23769a67236389e5ac1\" 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=IQoJb3JpZ2luX2VjEGUaCWV1LXdlc3QtMSJIMEYCIQCCbvlJ4%2FNAkmCAKgGb1Z8VDr8gHJRXNSbNEmPqNAaOHgIhALJZmGFUPAYmYq6%2B7OnnVqDbFjbPgjO1psChn3lsM%2B6kKrkFCC4QBRoMMjczNTcwMTk1NDMzIgws29j7N4%2FJOWuFpBAqlgXOOffrSF9dyPy%2BA3PDW%2BoS4d8EHVtpAIm08HG%2BoA6VqI0wI3DDMXQ0M0U4zVPc3Fu5x5Sqm%2FomHcidwLQwD%2FddwuumS4iFGHIUDxKPIW7PYNRP%2BfsQj1KA6X1HQumZWmCgxOQTVd7PWUU3Dz3%2B17JmlAw0a4AzFvB1jDhHYjjqV4IPWj87DyV0ddHabn4lodrJbtrW0TD6mcQxjhCs8sUCWmLr632UX6kxS6i6Hd43mdZFnN5e6JdzGxnTSRTUPVCXani5fwClGlDOlRl6GA9MF1RTQiFbETCvNohaPbwv0R3VDNu24bNORBZ5IhcL%2BGCmKWATjB58Gt0iF9LCqyYtS3YGhwHY12Ds%2FgQLBR7Cs0Uc6CqIz918goh5YPkZ%2FOleJVCppUtmyUCTDq5pp6JvwtzzWEy7etRfNFsR6e%2BHkcJb7tGFWOdQ%2FqmiBSa7zWqmlw%2FJp4pXHMke4iPb6fDvWJVnl5ZNKZ8wdrp2s6uUR5ah%2Bb7vLXg0frMLLtn%2FSHZA6as1tP0Fgx2oR18yijBA8RlhcajWtnAFCOMqswn31wJ4xvvCDPmcoLf%2B74xg6HuPtucEEEAxEjAkul62nqp4pBLdK6u%2F%2FflCdZ%2FxHwuvBr%2FJh6kyKbU2QqdsOQESCyQT9oHjfh9A97zybLRZc6%2Fb3kPtn%2BT05O7Bnf0NRNQQkCXxUxkUni660giUV%2FPO0fHYss1yqYzpozFsRvYbxR6shH%2FCp43vzjF1F2uSkgmfUvv7D5et%2F2IPRzhDwmP3mnGdx0zTh9TyCX2MLD9HMkJkNUeAMRrFQAD38PxzrWU3NoLNg57fFNBwcIItcUTNlBHNUJrH0l9vPF%2BDsY%2BXLBMCn90iTr3iHFLY2A%2FPQKhGAYFwPcZbUjCthP3QBjqwAUsu4Z4AuOHcuZtg9M7jXbRINJAuEUcW7e7fEEuoIfzZgMmNmI7X7GNlb7dX1u%2Bay49F3rgbxWTI654%2B2myuUreK9YvnzfFZZ7DzvyMXsEhxbS%2FzkY2S%2FVQb9aiAaMh%2FOwwyWZGXnAqyGOXH3qNJNBPoQGH6XMLf%2BH8wWvBPlx5dnd8OSjx6gAHI4ESuU340G%2FDp8Tpv%2Ft90Sm2x60pBI9hii6kYSMk%2B1R%2BACJpEixAV&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47U7RYHY7BA%2F20260602%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260602T211449Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=8a8d30a8290fbcce7ba07d2dce9748d7590bcf3a08bcd23769a67236389e5ac1 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=IQoJb3JpZ2luX2VjEGUaCWV1LXdlc3QtMSJIMEYCIQCCbvlJ4%2FNAkmCAKgGb1Z8VDr8gHJRXNSbNEmPqNAaOHgIhALJZmGFUPAYmYq6%2B7OnnVqDbFjbPgjO1psChn3lsM%2B6kKrkFCC4QBRoMMjczNTcwMTk1NDMzIgws29j7N4%2FJOWuFpBAqlgXOOffrSF9dyPy%2BA3PDW%2BoS4d8EHVtpAIm08HG%2BoA6VqI0wI3DDMXQ0M0U4zVPc3Fu5x5Sqm%2FomHcidwLQwD%2FddwuumS4iFGHIUDxKPIW7PYNRP%2BfsQj1KA6X1HQumZWmCgxOQTVd7PWUU3Dz3%2B17JmlAw0a4AzFvB1jDhHYjjqV4IPWj87DyV0ddHabn4lodrJbtrW0TD6mcQxjhCs8sUCWmLr632UX6kxS6i6Hd43mdZFnN5e6JdzGxnTSRTUPVCXani5fwClGlDOlRl6GA9MF1RTQiFbETCvNohaPbwv0R3VDNu24bNORBZ5IhcL%2BGCmKWATjB58Gt0iF9LCqyYtS3YGhwHY12Ds%2FgQLBR7Cs0Uc6CqIz918goh5YPkZ%2FOleJVCppUtmyUCTDq5pp6JvwtzzWEy7etRfNFsR6e%2BHkcJb7tGFWOdQ%2FqmiBSa7zWqmlw%2FJp4pXHMke4iPb6fDvWJVnl5ZNKZ8wdrp2s6uUR5ah%2Bb7vLXg0frMLLtn%2FSHZA6as1tP0Fgx2oR18yijBA8RlhcajWtnAFCOMqswn31wJ4xvvCDPmcoLf%2B74xg6HuPtucEEEAxEjAkul62nqp4pBLdK6u%2F%2FflCdZ%2FxHwuvBr%2FJh6kyKbU2QqdsOQESCyQT9oHjfh9A97zybLRZc6%2Fb3kPtn%2BT05O7Bnf0NRNQQkCXxUxkUni660giUV%2FPO0fHYss1yqYzpozFsRvYbxR6shH%2FCp43vzjF1F2uSkgmfUvv7D5et%2F2IPRzhDwmP3mnGdx0zTh9TyCX2MLD9HMkJkNUeAMRrFQAD38PxzrWU3NoLNg57fFNBwcIItcUTNlBHNUJrH0l9vPF%2BDsY%2BXLBMCn90iTr3iHFLY2A%2FPQKhGAYFwPcZbUjCthP3QBjqwAUsu4Z4AuOHcuZtg9M7jXbRINJAuEUcW7e7fEEuoIfzZgMmNmI7X7GNlb7dX1u%2Bay49F3rgbxWTI654%2B2myuUreK9YvnzfFZZ7DzvyMXsEhxbS%2FzkY2S%2FVQb9aiAaMh%2FOwwyWZGXnAqyGOXH3qNJNBPoQGH6XMLf%2BH8wWvBPlx5dnd8OSjx6gAHI4ESuU340G%2FDp8Tpv%2Ft90Sm2x60pBI9hii6kYSMk%2B1R%2BACJpEixAV&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47U7RYHY7BA%2F20260602%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260602T211449Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=b16d694a3f69b5d5c77570c9be10f519b6697db9c7ae9d4785d8ac5412384e44 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=IQoJb3JpZ2luX2VjEGUaCWV1LXdlc3QtMSJIMEYCIQCCbvlJ4%2FNAkmCAKgGb1Z8VDr8gHJRXNSbNEmPqNAaOHgIhALJZmGFUPAYmYq6%2B7OnnVqDbFjbPgjO1psChn3lsM%2B6kKrkFCC4QBRoMMjczNTcwMTk1NDMzIgws29j7N4%2FJOWuFpBAqlgXOOffrSF9dyPy%2BA3PDW%2BoS4d8EHVtpAIm08HG%2BoA6VqI0wI3DDMXQ0M0U4zVPc3Fu5x5Sqm%2FomHcidwLQwD%2FddwuumS4iFGHIUDxKPIW7PYNRP%2BfsQj1KA6X1HQumZWmCgxOQTVd7PWUU3Dz3%2B17JmlAw0a4AzFvB1jDhHYjjqV4IPWj87DyV0ddHabn4lodrJbtrW0TD6mcQxjhCs8sUCWmLr632UX6kxS6i6Hd43mdZFnN5e6JdzGxnTSRTUPVCXani5fwClGlDOlRl6GA9MF1RTQiFbETCvNohaPbwv0R3VDNu24bNORBZ5IhcL%2BGCmKWATjB58Gt0iF9LCqyYtS3YGhwHY12Ds%2FgQLBR7Cs0Uc6CqIz918goh5YPkZ%2FOleJVCppUtmyUCTDq5pp6JvwtzzWEy7etRfNFsR6e%2BHkcJb7tGFWOdQ%2FqmiBSa7zWqmlw%2FJp4pXHMke4iPb6fDvWJVnl5ZNKZ8wdrp2s6uUR5ah%2Bb7vLXg0frMLLtn%2FSHZA6as1tP0Fgx2oR18yijBA8RlhcajWtnAFCOMqswn31wJ4xvvCDPmcoLf%2B74xg6HuPtucEEEAxEjAkul62nqp4pBLdK6u%2F%2FflCdZ%2FxHwuvBr%2FJh6kyKbU2QqdsOQESCyQT9oHjfh9A97zybLRZc6%2Fb3kPtn%2BT05O7Bnf0NRNQQkCXxUxkUni660giUV%2FPO0fHYss1yqYzpozFsRvYbxR6shH%2FCp43vzjF1F2uSkgmfUvv7D5et%2F2IPRzhDwmP3mnGdx0zTh9TyCX2MLD9HMkJkNUeAMRrFQAD38PxzrWU3NoLNg57fFNBwcIItcUTNlBHNUJrH0l9vPF%2BDsY%2BXLBMCn90iTr3iHFLY2A%2FPQKhGAYFwPcZbUjCthP3QBjqwAUsu4Z4AuOHcuZtg9M7jXbRINJAuEUcW7e7fEEuoIfzZgMmNmI7X7GNlb7dX1u%2Bay49F3rgbxWTI654%2B2myuUreK9YvnzfFZZ7DzvyMXsEhxbS%2FzkY2S%2FVQb9aiAaMh%2FOwwyWZGXnAqyGOXH3qNJNBPoQGH6XMLf%2BH8wWvBPlx5dnd8OSjx6gAHI4ESuU340G%2FDp8Tpv%2Ft90Sm2x60pBI9hii6kYSMk%2B1R%2BACJpEixAV&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47U7RYHY7BA%2F20260602%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260602T211449Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=b16d694a3f69b5d5c77570c9be10f519b6697db9c7ae9d4785d8ac5412384e44\" 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=IQoJb3JpZ2luX2VjEGUaCWV1LXdlc3QtMSJIMEYCIQCCbvlJ4%2FNAkmCAKgGb1Z8VDr8gHJRXNSbNEmPqNAaOHgIhALJZmGFUPAYmYq6%2B7OnnVqDbFjbPgjO1psChn3lsM%2B6kKrkFCC4QBRoMMjczNTcwMTk1NDMzIgws29j7N4%2FJOWuFpBAqlgXOOffrSF9dyPy%2BA3PDW%2BoS4d8EHVtpAIm08HG%2BoA6VqI0wI3DDMXQ0M0U4zVPc3Fu5x5Sqm%2FomHcidwLQwD%2FddwuumS4iFGHIUDxKPIW7PYNRP%2BfsQj1KA6X1HQumZWmCgxOQTVd7PWUU3Dz3%2B17JmlAw0a4AzFvB1jDhHYjjqV4IPWj87DyV0ddHabn4lodrJbtrW0TD6mcQxjhCs8sUCWmLr632UX6kxS6i6Hd43mdZFnN5e6JdzGxnTSRTUPVCXani5fwClGlDOlRl6GA9MF1RTQiFbETCvNohaPbwv0R3VDNu24bNORBZ5IhcL%2BGCmKWATjB58Gt0iF9LCqyYtS3YGhwHY12Ds%2FgQLBR7Cs0Uc6CqIz918goh5YPkZ%2FOleJVCppUtmyUCTDq5pp6JvwtzzWEy7etRfNFsR6e%2BHkcJb7tGFWOdQ%2FqmiBSa7zWqmlw%2FJp4pXHMke4iPb6fDvWJVnl5ZNKZ8wdrp2s6uUR5ah%2Bb7vLXg0frMLLtn%2FSHZA6as1tP0Fgx2oR18yijBA8RlhcajWtnAFCOMqswn31wJ4xvvCDPmcoLf%2B74xg6HuPtucEEEAxEjAkul62nqp4pBLdK6u%2F%2FflCdZ%2FxHwuvBr%2FJh6kyKbU2QqdsOQESCyQT9oHjfh9A97zybLRZc6%2Fb3kPtn%2BT05O7Bnf0NRNQQkCXxUxkUni660giUV%2FPO0fHYss1yqYzpozFsRvYbxR6shH%2FCp43vzjF1F2uSkgmfUvv7D5et%2F2IPRzhDwmP3mnGdx0zTh9TyCX2MLD9HMkJkNUeAMRrFQAD38PxzrWU3NoLNg57fFNBwcIItcUTNlBHNUJrH0l9vPF%2BDsY%2BXLBMCn90iTr3iHFLY2A%2FPQKhGAYFwPcZbUjCthP3QBjqwAUsu4Z4AuOHcuZtg9M7jXbRINJAuEUcW7e7fEEuoIfzZgMmNmI7X7GNlb7dX1u%2Bay49F3rgbxWTI654%2B2myuUreK9YvnzfFZZ7DzvyMXsEhxbS%2FzkY2S%2FVQb9aiAaMh%2FOwwyWZGXnAqyGOXH3qNJNBPoQGH6XMLf%2BH8wWvBPlx5dnd8OSjx6gAHI4ESuU340G%2FDp8Tpv%2Ft90Sm2x60pBI9hii6kYSMk%2B1R%2BACJpEixAV&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47U7RYHY7BA%2F20260602%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260602T211449Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=0f70229767fb0e876ef6220b3612d83edb139cd1a5822d4013c4c96400b3f29e\" 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=IQoJb3JpZ2luX2VjEGUaCWV1LXdlc3QtMSJIMEYCIQCCbvlJ4%2FNAkmCAKgGb1Z8VDr8gHJRXNSbNEmPqNAaOHgIhALJZmGFUPAYmYq6%2B7OnnVqDbFjbPgjO1psChn3lsM%2B6kKrkFCC4QBRoMMjczNTcwMTk1NDMzIgws29j7N4%2FJOWuFpBAqlgXOOffrSF9dyPy%2BA3PDW%2BoS4d8EHVtpAIm08HG%2BoA6VqI0wI3DDMXQ0M0U4zVPc3Fu5x5Sqm%2FomHcidwLQwD%2FddwuumS4iFGHIUDxKPIW7PYNRP%2BfsQj1KA6X1HQumZWmCgxOQTVd7PWUU3Dz3%2B17JmlAw0a4AzFvB1jDhHYjjqV4IPWj87DyV0ddHabn4lodrJbtrW0TD6mcQxjhCs8sUCWmLr632UX6kxS6i6Hd43mdZFnN5e6JdzGxnTSRTUPVCXani5fwClGlDOlRl6GA9MF1RTQiFbETCvNohaPbwv0R3VDNu24bNORBZ5IhcL%2BGCmKWATjB58Gt0iF9LCqyYtS3YGhwHY12Ds%2FgQLBR7Cs0Uc6CqIz918goh5YPkZ%2FOleJVCppUtmyUCTDq5pp6JvwtzzWEy7etRfNFsR6e%2BHkcJb7tGFWOdQ%2FqmiBSa7zWqmlw%2FJp4pXHMke4iPb6fDvWJVnl5ZNKZ8wdrp2s6uUR5ah%2Bb7vLXg0frMLLtn%2FSHZA6as1tP0Fgx2oR18yijBA8RlhcajWtnAFCOMqswn31wJ4xvvCDPmcoLf%2B74xg6HuPtucEEEAxEjAkul62nqp4pBLdK6u%2F%2FflCdZ%2FxHwuvBr%2FJh6kyKbU2QqdsOQESCyQT9oHjfh9A97zybLRZc6%2Fb3kPtn%2BT05O7Bnf0NRNQQkCXxUxkUni660giUV%2FPO0fHYss1yqYzpozFsRvYbxR6shH%2FCp43vzjF1F2uSkgmfUvv7D5et%2F2IPRzhDwmP3mnGdx0zTh9TyCX2MLD9HMkJkNUeAMRrFQAD38PxzrWU3NoLNg57fFNBwcIItcUTNlBHNUJrH0l9vPF%2BDsY%2BXLBMCn90iTr3iHFLY2A%2FPQKhGAYFwPcZbUjCthP3QBjqwAUsu4Z4AuOHcuZtg9M7jXbRINJAuEUcW7e7fEEuoIfzZgMmNmI7X7GNlb7dX1u%2Bay49F3rgbxWTI654%2B2myuUreK9YvnzfFZZ7DzvyMXsEhxbS%2FzkY2S%2FVQb9aiAaMh%2FOwwyWZGXnAqyGOXH3qNJNBPoQGH6XMLf%2BH8wWvBPlx5dnd8OSjx6gAHI4ESuU340G%2FDp8Tpv%2Ft90Sm2x60pBI9hii6kYSMk%2B1R%2BACJpEixAV&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47U7RYHY7BA%2F20260602%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260602T211449Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=0f70229767fb0e876ef6220b3612d83edb139cd1a5822d4013c4c96400b3f29e 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=IQoJb3JpZ2luX2VjEGUaCWV1LXdlc3QtMSJIMEYCIQCCbvlJ4%2FNAkmCAKgGb1Z8VDr8gHJRXNSbNEmPqNAaOHgIhALJZmGFUPAYmYq6%2B7OnnVqDbFjbPgjO1psChn3lsM%2B6kKrkFCC4QBRoMMjczNTcwMTk1NDMzIgws29j7N4%2FJOWuFpBAqlgXOOffrSF9dyPy%2BA3PDW%2BoS4d8EHVtpAIm08HG%2BoA6VqI0wI3DDMXQ0M0U4zVPc3Fu5x5Sqm%2FomHcidwLQwD%2FddwuumS4iFGHIUDxKPIW7PYNRP%2BfsQj1KA6X1HQumZWmCgxOQTVd7PWUU3Dz3%2B17JmlAw0a4AzFvB1jDhHYjjqV4IPWj87DyV0ddHabn4lodrJbtrW0TD6mcQxjhCs8sUCWmLr632UX6kxS6i6Hd43mdZFnN5e6JdzGxnTSRTUPVCXani5fwClGlDOlRl6GA9MF1RTQiFbETCvNohaPbwv0R3VDNu24bNORBZ5IhcL%2BGCmKWATjB58Gt0iF9LCqyYtS3YGhwHY12Ds%2FgQLBR7Cs0Uc6CqIz918goh5YPkZ%2FOleJVCppUtmyUCTDq5pp6JvwtzzWEy7etRfNFsR6e%2BHkcJb7tGFWOdQ%2FqmiBSa7zWqmlw%2FJp4pXHMke4iPb6fDvWJVnl5ZNKZ8wdrp2s6uUR5ah%2Bb7vLXg0frMLLtn%2FSHZA6as1tP0Fgx2oR18yijBA8RlhcajWtnAFCOMqswn31wJ4xvvCDPmcoLf%2B74xg6HuPtucEEEAxEjAkul62nqp4pBLdK6u%2F%2FflCdZ%2FxHwuvBr%2FJh6kyKbU2QqdsOQESCyQT9oHjfh9A97zybLRZc6%2Fb3kPtn%2BT05O7Bnf0NRNQQkCXxUxkUni660giUV%2FPO0fHYss1yqYzpozFsRvYbxR6shH%2FCp43vzjF1F2uSkgmfUvv7D5et%2F2IPRzhDwmP3mnGdx0zTh9TyCX2MLD9HMkJkNUeAMRrFQAD38PxzrWU3NoLNg57fFNBwcIItcUTNlBHNUJrH0l9vPF%2BDsY%2BXLBMCn90iTr3iHFLY2A%2FPQKhGAYFwPcZbUjCthP3QBjqwAUsu4Z4AuOHcuZtg9M7jXbRINJAuEUcW7e7fEEuoIfzZgMmNmI7X7GNlb7dX1u%2Bay49F3rgbxWTI654%2B2myuUreK9YvnzfFZZ7DzvyMXsEhxbS%2FzkY2S%2FVQb9aiAaMh%2FOwwyWZGXnAqyGOXH3qNJNBPoQGH6XMLf%2BH8wWvBPlx5dnd8OSjx6gAHI4ESuU340G%2FDp8Tpv%2Ft90Sm2x60pBI9hii6kYSMk%2B1R%2BACJpEixAV&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47U7RYHY7BA%2F20260602%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260602T211449Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=e1a666f173ddad69b79eb38ac831cf54d1f75e0be37595beef4db7e05bad0efb 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=IQoJb3JpZ2luX2VjEGUaCWV1LXdlc3QtMSJIMEYCIQCCbvlJ4%2FNAkmCAKgGb1Z8VDr8gHJRXNSbNEmPqNAaOHgIhALJZmGFUPAYmYq6%2B7OnnVqDbFjbPgjO1psChn3lsM%2B6kKrkFCC4QBRoMMjczNTcwMTk1NDMzIgws29j7N4%2FJOWuFpBAqlgXOOffrSF9dyPy%2BA3PDW%2BoS4d8EHVtpAIm08HG%2BoA6VqI0wI3DDMXQ0M0U4zVPc3Fu5x5Sqm%2FomHcidwLQwD%2FddwuumS4iFGHIUDxKPIW7PYNRP%2BfsQj1KA6X1HQumZWmCgxOQTVd7PWUU3Dz3%2B17JmlAw0a4AzFvB1jDhHYjjqV4IPWj87DyV0ddHabn4lodrJbtrW0TD6mcQxjhCs8sUCWmLr632UX6kxS6i6Hd43mdZFnN5e6JdzGxnTSRTUPVCXani5fwClGlDOlRl6GA9MF1RTQiFbETCvNohaPbwv0R3VDNu24bNORBZ5IhcL%2BGCmKWATjB58Gt0iF9LCqyYtS3YGhwHY12Ds%2FgQLBR7Cs0Uc6CqIz918goh5YPkZ%2FOleJVCppUtmyUCTDq5pp6JvwtzzWEy7etRfNFsR6e%2BHkcJb7tGFWOdQ%2FqmiBSa7zWqmlw%2FJp4pXHMke4iPb6fDvWJVnl5ZNKZ8wdrp2s6uUR5ah%2Bb7vLXg0frMLLtn%2FSHZA6as1tP0Fgx2oR18yijBA8RlhcajWtnAFCOMqswn31wJ4xvvCDPmcoLf%2B74xg6HuPtucEEEAxEjAkul62nqp4pBLdK6u%2F%2FflCdZ%2FxHwuvBr%2FJh6kyKbU2QqdsOQESCyQT9oHjfh9A97zybLRZc6%2Fb3kPtn%2BT05O7Bnf0NRNQQkCXxUxkUni660giUV%2FPO0fHYss1yqYzpozFsRvYbxR6shH%2FCp43vzjF1F2uSkgmfUvv7D5et%2F2IPRzhDwmP3mnGdx0zTh9TyCX2MLD9HMkJkNUeAMRrFQAD38PxzrWU3NoLNg57fFNBwcIItcUTNlBHNUJrH0l9vPF%2BDsY%2BXLBMCn90iTr3iHFLY2A%2FPQKhGAYFwPcZbUjCthP3QBjqwAUsu4Z4AuOHcuZtg9M7jXbRINJAuEUcW7e7fEEuoIfzZgMmNmI7X7GNlb7dX1u%2Bay49F3rgbxWTI654%2B2myuUreK9YvnzfFZZ7DzvyMXsEhxbS%2FzkY2S%2FVQb9aiAaMh%2FOwwyWZGXnAqyGOXH3qNJNBPoQGH6XMLf%2BH8wWvBPlx5dnd8OSjx6gAHI4ESuU340G%2FDp8Tpv%2Ft90Sm2x60pBI9hii6kYSMk%2B1R%2BACJpEixAV&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47U7RYHY7BA%2F20260602%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260602T211449Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=e1a666f173ddad69b79eb38ac831cf54d1f75e0be37595beef4db7e05bad0efb\" 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=IQoJb3JpZ2luX2VjEGUaCWV1LXdlc3QtMSJIMEYCIQCCbvlJ4%2FNAkmCAKgGb1Z8VDr8gHJRXNSbNEmPqNAaOHgIhALJZmGFUPAYmYq6%2B7OnnVqDbFjbPgjO1psChn3lsM%2B6kKrkFCC4QBRoMMjczNTcwMTk1NDMzIgws29j7N4%2FJOWuFpBAqlgXOOffrSF9dyPy%2BA3PDW%2BoS4d8EHVtpAIm08HG%2BoA6VqI0wI3DDMXQ0M0U4zVPc3Fu5x5Sqm%2FomHcidwLQwD%2FddwuumS4iFGHIUDxKPIW7PYNRP%2BfsQj1KA6X1HQumZWmCgxOQTVd7PWUU3Dz3%2B17JmlAw0a4AzFvB1jDhHYjjqV4IPWj87DyV0ddHabn4lodrJbtrW0TD6mcQxjhCs8sUCWmLr632UX6kxS6i6Hd43mdZFnN5e6JdzGxnTSRTUPVCXani5fwClGlDOlRl6GA9MF1RTQiFbETCvNohaPbwv0R3VDNu24bNORBZ5IhcL%2BGCmKWATjB58Gt0iF9LCqyYtS3YGhwHY12Ds%2FgQLBR7Cs0Uc6CqIz918goh5YPkZ%2FOleJVCppUtmyUCTDq5pp6JvwtzzWEy7etRfNFsR6e%2BHkcJb7tGFWOdQ%2FqmiBSa7zWqmlw%2FJp4pXHMke4iPb6fDvWJVnl5ZNKZ8wdrp2s6uUR5ah%2Bb7vLXg0frMLLtn%2FSHZA6as1tP0Fgx2oR18yijBA8RlhcajWtnAFCOMqswn31wJ4xvvCDPmcoLf%2B74xg6HuPtucEEEAxEjAkul62nqp4pBLdK6u%2F%2FflCdZ%2FxHwuvBr%2FJh6kyKbU2QqdsOQESCyQT9oHjfh9A97zybLRZc6%2Fb3kPtn%2BT05O7Bnf0NRNQQkCXxUxkUni660giUV%2FPO0fHYss1yqYzpozFsRvYbxR6shH%2FCp43vzjF1F2uSkgmfUvv7D5et%2F2IPRzhDwmP3mnGdx0zTh9TyCX2MLD9HMkJkNUeAMRrFQAD38PxzrWU3NoLNg57fFNBwcIItcUTNlBHNUJrH0l9vPF%2BDsY%2BXLBMCn90iTr3iHFLY2A%2FPQKhGAYFwPcZbUjCthP3QBjqwAUsu4Z4AuOHcuZtg9M7jXbRINJAuEUcW7e7fEEuoIfzZgMmNmI7X7GNlb7dX1u%2Bay49F3rgbxWTI654%2B2myuUreK9YvnzfFZZ7DzvyMXsEhxbS%2FzkY2S%2FVQb9aiAaMh%2FOwwyWZGXnAqyGOXH3qNJNBPoQGH6XMLf%2BH8wWvBPlx5dnd8OSjx6gAHI4ESuU340G%2FDp8Tpv%2Ft90Sm2x60pBI9hii6kYSMk%2B1R%2BACJpEixAV&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47U7RYHY7BA%2F20260602%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260602T211449Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=bf5c962f039b6a853c4d27bb6c99facbaa2660531b4eefb17eb3e9ea392e485d\" 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=IQoJb3JpZ2luX2VjEGUaCWV1LXdlc3QtMSJIMEYCIQCCbvlJ4%2FNAkmCAKgGb1Z8VDr8gHJRXNSbNEmPqNAaOHgIhALJZmGFUPAYmYq6%2B7OnnVqDbFjbPgjO1psChn3lsM%2B6kKrkFCC4QBRoMMjczNTcwMTk1NDMzIgws29j7N4%2FJOWuFpBAqlgXOOffrSF9dyPy%2BA3PDW%2BoS4d8EHVtpAIm08HG%2BoA6VqI0wI3DDMXQ0M0U4zVPc3Fu5x5Sqm%2FomHcidwLQwD%2FddwuumS4iFGHIUDxKPIW7PYNRP%2BfsQj1KA6X1HQumZWmCgxOQTVd7PWUU3Dz3%2B17JmlAw0a4AzFvB1jDhHYjjqV4IPWj87DyV0ddHabn4lodrJbtrW0TD6mcQxjhCs8sUCWmLr632UX6kxS6i6Hd43mdZFnN5e6JdzGxnTSRTUPVCXani5fwClGlDOlRl6GA9MF1RTQiFbETCvNohaPbwv0R3VDNu24bNORBZ5IhcL%2BGCmKWATjB58Gt0iF9LCqyYtS3YGhwHY12Ds%2FgQLBR7Cs0Uc6CqIz918goh5YPkZ%2FOleJVCppUtmyUCTDq5pp6JvwtzzWEy7etRfNFsR6e%2BHkcJb7tGFWOdQ%2FqmiBSa7zWqmlw%2FJp4pXHMke4iPb6fDvWJVnl5ZNKZ8wdrp2s6uUR5ah%2Bb7vLXg0frMLLtn%2FSHZA6as1tP0Fgx2oR18yijBA8RlhcajWtnAFCOMqswn31wJ4xvvCDPmcoLf%2B74xg6HuPtucEEEAxEjAkul62nqp4pBLdK6u%2F%2FflCdZ%2FxHwuvBr%2FJh6kyKbU2QqdsOQESCyQT9oHjfh9A97zybLRZc6%2Fb3kPtn%2BT05O7Bnf0NRNQQkCXxUxkUni660giUV%2FPO0fHYss1yqYzpozFsRvYbxR6shH%2FCp43vzjF1F2uSkgmfUvv7D5et%2F2IPRzhDwmP3mnGdx0zTh9TyCX2MLD9HMkJkNUeAMRrFQAD38PxzrWU3NoLNg57fFNBwcIItcUTNlBHNUJrH0l9vPF%2BDsY%2BXLBMCn90iTr3iHFLY2A%2FPQKhGAYFwPcZbUjCthP3QBjqwAUsu4Z4AuOHcuZtg9M7jXbRINJAuEUcW7e7fEEuoIfzZgMmNmI7X7GNlb7dX1u%2Bay49F3rgbxWTI654%2B2myuUreK9YvnzfFZZ7DzvyMXsEhxbS%2FzkY2S%2FVQb9aiAaMh%2FOwwyWZGXnAqyGOXH3qNJNBPoQGH6XMLf%2BH8wWvBPlx5dnd8OSjx6gAHI4ESuU340G%2FDp8Tpv%2Ft90Sm2x60pBI9hii6kYSMk%2B1R%2BACJpEixAV&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47U7RYHY7BA%2F20260602%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260602T211449Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=bf5c962f039b6a853c4d27bb6c99facbaa2660531b4eefb17eb3e9ea392e485d 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=IQoJb3JpZ2luX2VjEGUaCWV1LXdlc3QtMSJIMEYCIQCCbvlJ4%2FNAkmCAKgGb1Z8VDr8gHJRXNSbNEmPqNAaOHgIhALJZmGFUPAYmYq6%2B7OnnVqDbFjbPgjO1psChn3lsM%2B6kKrkFCC4QBRoMMjczNTcwMTk1NDMzIgws29j7N4%2FJOWuFpBAqlgXOOffrSF9dyPy%2BA3PDW%2BoS4d8EHVtpAIm08HG%2BoA6VqI0wI3DDMXQ0M0U4zVPc3Fu5x5Sqm%2FomHcidwLQwD%2FddwuumS4iFGHIUDxKPIW7PYNRP%2BfsQj1KA6X1HQumZWmCgxOQTVd7PWUU3Dz3%2B17JmlAw0a4AzFvB1jDhHYjjqV4IPWj87DyV0ddHabn4lodrJbtrW0TD6mcQxjhCs8sUCWmLr632UX6kxS6i6Hd43mdZFnN5e6JdzGxnTSRTUPVCXani5fwClGlDOlRl6GA9MF1RTQiFbETCvNohaPbwv0R3VDNu24bNORBZ5IhcL%2BGCmKWATjB58Gt0iF9LCqyYtS3YGhwHY12Ds%2FgQLBR7Cs0Uc6CqIz918goh5YPkZ%2FOleJVCppUtmyUCTDq5pp6JvwtzzWEy7etRfNFsR6e%2BHkcJb7tGFWOdQ%2FqmiBSa7zWqmlw%2FJp4pXHMke4iPb6fDvWJVnl5ZNKZ8wdrp2s6uUR5ah%2Bb7vLXg0frMLLtn%2FSHZA6as1tP0Fgx2oR18yijBA8RlhcajWtnAFCOMqswn31wJ4xvvCDPmcoLf%2B74xg6HuPtucEEEAxEjAkul62nqp4pBLdK6u%2F%2FflCdZ%2FxHwuvBr%2FJh6kyKbU2QqdsOQESCyQT9oHjfh9A97zybLRZc6%2Fb3kPtn%2BT05O7Bnf0NRNQQkCXxUxkUni660giUV%2FPO0fHYss1yqYzpozFsRvYbxR6shH%2FCp43vzjF1F2uSkgmfUvv7D5et%2F2IPRzhDwmP3mnGdx0zTh9TyCX2MLD9HMkJkNUeAMRrFQAD38PxzrWU3NoLNg57fFNBwcIItcUTNlBHNUJrH0l9vPF%2BDsY%2BXLBMCn90iTr3iHFLY2A%2FPQKhGAYFwPcZbUjCthP3QBjqwAUsu4Z4AuOHcuZtg9M7jXbRINJAuEUcW7e7fEEuoIfzZgMmNmI7X7GNlb7dX1u%2Bay49F3rgbxWTI654%2B2myuUreK9YvnzfFZZ7DzvyMXsEhxbS%2FzkY2S%2FVQb9aiAaMh%2FOwwyWZGXnAqyGOXH3qNJNBPoQGH6XMLf%2BH8wWvBPlx5dnd8OSjx6gAHI4ESuU340G%2FDp8Tpv%2Ft90Sm2x60pBI9hii6kYSMk%2B1R%2BACJpEixAV&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47U7RYHY7BA%2F20260602%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260602T211449Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=690b7cfcfc2fa4b051b1379c8cf00d4a01d0e94a01eb0ecc484592f037cd3010 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=IQoJb3JpZ2luX2VjEGUaCWV1LXdlc3QtMSJIMEYCIQCCbvlJ4%2FNAkmCAKgGb1Z8VDr8gHJRXNSbNEmPqNAaOHgIhALJZmGFUPAYmYq6%2B7OnnVqDbFjbPgjO1psChn3lsM%2B6kKrkFCC4QBRoMMjczNTcwMTk1NDMzIgws29j7N4%2FJOWuFpBAqlgXOOffrSF9dyPy%2BA3PDW%2BoS4d8EHVtpAIm08HG%2BoA6VqI0wI3DDMXQ0M0U4zVPc3Fu5x5Sqm%2FomHcidwLQwD%2FddwuumS4iFGHIUDxKPIW7PYNRP%2BfsQj1KA6X1HQumZWmCgxOQTVd7PWUU3Dz3%2B17JmlAw0a4AzFvB1jDhHYjjqV4IPWj87DyV0ddHabn4lodrJbtrW0TD6mcQxjhCs8sUCWmLr632UX6kxS6i6Hd43mdZFnN5e6JdzGxnTSRTUPVCXani5fwClGlDOlRl6GA9MF1RTQiFbETCvNohaPbwv0R3VDNu24bNORBZ5IhcL%2BGCmKWATjB58Gt0iF9LCqyYtS3YGhwHY12Ds%2FgQLBR7Cs0Uc6CqIz918goh5YPkZ%2FOleJVCppUtmyUCTDq5pp6JvwtzzWEy7etRfNFsR6e%2BHkcJb7tGFWOdQ%2FqmiBSa7zWqmlw%2FJp4pXHMke4iPb6fDvWJVnl5ZNKZ8wdrp2s6uUR5ah%2Bb7vLXg0frMLLtn%2FSHZA6as1tP0Fgx2oR18yijBA8RlhcajWtnAFCOMqswn31wJ4xvvCDPmcoLf%2B74xg6HuPtucEEEAxEjAkul62nqp4pBLdK6u%2F%2FflCdZ%2FxHwuvBr%2FJh6kyKbU2QqdsOQESCyQT9oHjfh9A97zybLRZc6%2Fb3kPtn%2BT05O7Bnf0NRNQQkCXxUxkUni660giUV%2FPO0fHYss1yqYzpozFsRvYbxR6shH%2FCp43vzjF1F2uSkgmfUvv7D5et%2F2IPRzhDwmP3mnGdx0zTh9TyCX2MLD9HMkJkNUeAMRrFQAD38PxzrWU3NoLNg57fFNBwcIItcUTNlBHNUJrH0l9vPF%2BDsY%2BXLBMCn90iTr3iHFLY2A%2FPQKhGAYFwPcZbUjCthP3QBjqwAUsu4Z4AuOHcuZtg9M7jXbRINJAuEUcW7e7fEEuoIfzZgMmNmI7X7GNlb7dX1u%2Bay49F3rgbxWTI654%2B2myuUreK9YvnzfFZZ7DzvyMXsEhxbS%2FzkY2S%2FVQb9aiAaMh%2FOwwyWZGXnAqyGOXH3qNJNBPoQGH6XMLf%2BH8wWvBPlx5dnd8OSjx6gAHI4ESuU340G%2FDp8Tpv%2Ft90Sm2x60pBI9hii6kYSMk%2B1R%2BACJpEixAV&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47U7RYHY7BA%2F20260602%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260602T211449Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=690b7cfcfc2fa4b051b1379c8cf00d4a01d0e94a01eb0ecc484592f037cd3010\" 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=IQoJb3JpZ2luX2VjEGUaCWV1LXdlc3QtMSJIMEYCIQCCbvlJ4%2FNAkmCAKgGb1Z8VDr8gHJRXNSbNEmPqNAaOHgIhALJZmGFUPAYmYq6%2B7OnnVqDbFjbPgjO1psChn3lsM%2B6kKrkFCC4QBRoMMjczNTcwMTk1NDMzIgws29j7N4%2FJOWuFpBAqlgXOOffrSF9dyPy%2BA3PDW%2BoS4d8EHVtpAIm08HG%2BoA6VqI0wI3DDMXQ0M0U4zVPc3Fu5x5Sqm%2FomHcidwLQwD%2FddwuumS4iFGHIUDxKPIW7PYNRP%2BfsQj1KA6X1HQumZWmCgxOQTVd7PWUU3Dz3%2B17JmlAw0a4AzFvB1jDhHYjjqV4IPWj87DyV0ddHabn4lodrJbtrW0TD6mcQxjhCs8sUCWmLr632UX6kxS6i6Hd43mdZFnN5e6JdzGxnTSRTUPVCXani5fwClGlDOlRl6GA9MF1RTQiFbETCvNohaPbwv0R3VDNu24bNORBZ5IhcL%2BGCmKWATjB58Gt0iF9LCqyYtS3YGhwHY12Ds%2FgQLBR7Cs0Uc6CqIz918goh5YPkZ%2FOleJVCppUtmyUCTDq5pp6JvwtzzWEy7etRfNFsR6e%2BHkcJb7tGFWOdQ%2FqmiBSa7zWqmlw%2FJp4pXHMke4iPb6fDvWJVnl5ZNKZ8wdrp2s6uUR5ah%2Bb7vLXg0frMLLtn%2FSHZA6as1tP0Fgx2oR18yijBA8RlhcajWtnAFCOMqswn31wJ4xvvCDPmcoLf%2B74xg6HuPtucEEEAxEjAkul62nqp4pBLdK6u%2F%2FflCdZ%2FxHwuvBr%2FJh6kyKbU2QqdsOQESCyQT9oHjfh9A97zybLRZc6%2Fb3kPtn%2BT05O7Bnf0NRNQQkCXxUxkUni660giUV%2FPO0fHYss1yqYzpozFsRvYbxR6shH%2FCp43vzjF1F2uSkgmfUvv7D5et%2F2IPRzhDwmP3mnGdx0zTh9TyCX2MLD9HMkJkNUeAMRrFQAD38PxzrWU3NoLNg57fFNBwcIItcUTNlBHNUJrH0l9vPF%2BDsY%2BXLBMCn90iTr3iHFLY2A%2FPQKhGAYFwPcZbUjCthP3QBjqwAUsu4Z4AuOHcuZtg9M7jXbRINJAuEUcW7e7fEEuoIfzZgMmNmI7X7GNlb7dX1u%2Bay49F3rgbxWTI654%2B2myuUreK9YvnzfFZZ7DzvyMXsEhxbS%2FzkY2S%2FVQb9aiAaMh%2FOwwyWZGXnAqyGOXH3qNJNBPoQGH6XMLf%2BH8wWvBPlx5dnd8OSjx6gAHI4ESuU340G%2FDp8Tpv%2Ft90Sm2x60pBI9hii6kYSMk%2B1R%2BACJpEixAV&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47U7RYHY7BA%2F20260602%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260602T211449Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=b48fdf8deca722ce19497862cf7e6a1f7fa4252d4d3d18eaf1132da6094f3c9b\" 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=IQoJb3JpZ2luX2VjEGUaCWV1LXdlc3QtMSJIMEYCIQCCbvlJ4%2FNAkmCAKgGb1Z8VDr8gHJRXNSbNEmPqNAaOHgIhALJZmGFUPAYmYq6%2B7OnnVqDbFjbPgjO1psChn3lsM%2B6kKrkFCC4QBRoMMjczNTcwMTk1NDMzIgws29j7N4%2FJOWuFpBAqlgXOOffrSF9dyPy%2BA3PDW%2BoS4d8EHVtpAIm08HG%2BoA6VqI0wI3DDMXQ0M0U4zVPc3Fu5x5Sqm%2FomHcidwLQwD%2FddwuumS4iFGHIUDxKPIW7PYNRP%2BfsQj1KA6X1HQumZWmCgxOQTVd7PWUU3Dz3%2B17JmlAw0a4AzFvB1jDhHYjjqV4IPWj87DyV0ddHabn4lodrJbtrW0TD6mcQxjhCs8sUCWmLr632UX6kxS6i6Hd43mdZFnN5e6JdzGxnTSRTUPVCXani5fwClGlDOlRl6GA9MF1RTQiFbETCvNohaPbwv0R3VDNu24bNORBZ5IhcL%2BGCmKWATjB58Gt0iF9LCqyYtS3YGhwHY12Ds%2FgQLBR7Cs0Uc6CqIz918goh5YPkZ%2FOleJVCppUtmyUCTDq5pp6JvwtzzWEy7etRfNFsR6e%2BHkcJb7tGFWOdQ%2FqmiBSa7zWqmlw%2FJp4pXHMke4iPb6fDvWJVnl5ZNKZ8wdrp2s6uUR5ah%2Bb7vLXg0frMLLtn%2FSHZA6as1tP0Fgx2oR18yijBA8RlhcajWtnAFCOMqswn31wJ4xvvCDPmcoLf%2B74xg6HuPtucEEEAxEjAkul62nqp4pBLdK6u%2F%2FflCdZ%2FxHwuvBr%2FJh6kyKbU2QqdsOQESCyQT9oHjfh9A97zybLRZc6%2Fb3kPtn%2BT05O7Bnf0NRNQQkCXxUxkUni660giUV%2FPO0fHYss1yqYzpozFsRvYbxR6shH%2FCp43vzjF1F2uSkgmfUvv7D5et%2F2IPRzhDwmP3mnGdx0zTh9TyCX2MLD9HMkJkNUeAMRrFQAD38PxzrWU3NoLNg57fFNBwcIItcUTNlBHNUJrH0l9vPF%2BDsY%2BXLBMCn90iTr3iHFLY2A%2FPQKhGAYFwPcZbUjCthP3QBjqwAUsu4Z4AuOHcuZtg9M7jXbRINJAuEUcW7e7fEEuoIfzZgMmNmI7X7GNlb7dX1u%2Bay49F3rgbxWTI654%2B2myuUreK9YvnzfFZZ7DzvyMXsEhxbS%2FzkY2S%2FVQb9aiAaMh%2FOwwyWZGXnAqyGOXH3qNJNBPoQGH6XMLf%2BH8wWvBPlx5dnd8OSjx6gAHI4ESuU340G%2FDp8Tpv%2Ft90Sm2x60pBI9hii6kYSMk%2B1R%2BACJpEixAV&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47U7RYHY7BA%2F20260602%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260602T211449Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=b48fdf8deca722ce19497862cf7e6a1f7fa4252d4d3d18eaf1132da6094f3c9b 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=IQoJb3JpZ2luX2VjEGUaCWV1LXdlc3QtMSJIMEYCIQCCbvlJ4%2FNAkmCAKgGb1Z8VDr8gHJRXNSbNEmPqNAaOHgIhALJZmGFUPAYmYq6%2B7OnnVqDbFjbPgjO1psChn3lsM%2B6kKrkFCC4QBRoMMjczNTcwMTk1NDMzIgws29j7N4%2FJOWuFpBAqlgXOOffrSF9dyPy%2BA3PDW%2BoS4d8EHVtpAIm08HG%2BoA6VqI0wI3DDMXQ0M0U4zVPc3Fu5x5Sqm%2FomHcidwLQwD%2FddwuumS4iFGHIUDxKPIW7PYNRP%2BfsQj1KA6X1HQumZWmCgxOQTVd7PWUU3Dz3%2B17JmlAw0a4AzFvB1jDhHYjjqV4IPWj87DyV0ddHabn4lodrJbtrW0TD6mcQxjhCs8sUCWmLr632UX6kxS6i6Hd43mdZFnN5e6JdzGxnTSRTUPVCXani5fwClGlDOlRl6GA9MF1RTQiFbETCvNohaPbwv0R3VDNu24bNORBZ5IhcL%2BGCmKWATjB58Gt0iF9LCqyYtS3YGhwHY12Ds%2FgQLBR7Cs0Uc6CqIz918goh5YPkZ%2FOleJVCppUtmyUCTDq5pp6JvwtzzWEy7etRfNFsR6e%2BHkcJb7tGFWOdQ%2FqmiBSa7zWqmlw%2FJp4pXHMke4iPb6fDvWJVnl5ZNKZ8wdrp2s6uUR5ah%2Bb7vLXg0frMLLtn%2FSHZA6as1tP0Fgx2oR18yijBA8RlhcajWtnAFCOMqswn31wJ4xvvCDPmcoLf%2B74xg6HuPtucEEEAxEjAkul62nqp4pBLdK6u%2F%2FflCdZ%2FxHwuvBr%2FJh6kyKbU2QqdsOQESCyQT9oHjfh9A97zybLRZc6%2Fb3kPtn%2BT05O7Bnf0NRNQQkCXxUxkUni660giUV%2FPO0fHYss1yqYzpozFsRvYbxR6shH%2FCp43vzjF1F2uSkgmfUvv7D5et%2F2IPRzhDwmP3mnGdx0zTh9TyCX2MLD9HMkJkNUeAMRrFQAD38PxzrWU3NoLNg57fFNBwcIItcUTNlBHNUJrH0l9vPF%2BDsY%2BXLBMCn90iTr3iHFLY2A%2FPQKhGAYFwPcZbUjCthP3QBjqwAUsu4Z4AuOHcuZtg9M7jXbRINJAuEUcW7e7fEEuoIfzZgMmNmI7X7GNlb7dX1u%2Bay49F3rgbxWTI654%2B2myuUreK9YvnzfFZZ7DzvyMXsEhxbS%2FzkY2S%2FVQb9aiAaMh%2FOwwyWZGXnAqyGOXH3qNJNBPoQGH6XMLf%2BH8wWvBPlx5dnd8OSjx6gAHI4ESuU340G%2FDp8Tpv%2Ft90Sm2x60pBI9hii6kYSMk%2B1R%2BACJpEixAV&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47U7RYHY7BA%2F20260602%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260602T211449Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=d65116391c6a6dcf9f5e7d7703e5375aebca0a909d5cf1c3567de149b93de1c0 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=IQoJb3JpZ2luX2VjEGUaCWV1LXdlc3QtMSJIMEYCIQCCbvlJ4%2FNAkmCAKgGb1Z8VDr8gHJRXNSbNEmPqNAaOHgIhALJZmGFUPAYmYq6%2B7OnnVqDbFjbPgjO1psChn3lsM%2B6kKrkFCC4QBRoMMjczNTcwMTk1NDMzIgws29j7N4%2FJOWuFpBAqlgXOOffrSF9dyPy%2BA3PDW%2BoS4d8EHVtpAIm08HG%2BoA6VqI0wI3DDMXQ0M0U4zVPc3Fu5x5Sqm%2FomHcidwLQwD%2FddwuumS4iFGHIUDxKPIW7PYNRP%2BfsQj1KA6X1HQumZWmCgxOQTVd7PWUU3Dz3%2B17JmlAw0a4AzFvB1jDhHYjjqV4IPWj87DyV0ddHabn4lodrJbtrW0TD6mcQxjhCs8sUCWmLr632UX6kxS6i6Hd43mdZFnN5e6JdzGxnTSRTUPVCXani5fwClGlDOlRl6GA9MF1RTQiFbETCvNohaPbwv0R3VDNu24bNORBZ5IhcL%2BGCmKWATjB58Gt0iF9LCqyYtS3YGhwHY12Ds%2FgQLBR7Cs0Uc6CqIz918goh5YPkZ%2FOleJVCppUtmyUCTDq5pp6JvwtzzWEy7etRfNFsR6e%2BHkcJb7tGFWOdQ%2FqmiBSa7zWqmlw%2FJp4pXHMke4iPb6fDvWJVnl5ZNKZ8wdrp2s6uUR5ah%2Bb7vLXg0frMLLtn%2FSHZA6as1tP0Fgx2oR18yijBA8RlhcajWtnAFCOMqswn31wJ4xvvCDPmcoLf%2B74xg6HuPtucEEEAxEjAkul62nqp4pBLdK6u%2F%2FflCdZ%2FxHwuvBr%2FJh6kyKbU2QqdsOQESCyQT9oHjfh9A97zybLRZc6%2Fb3kPtn%2BT05O7Bnf0NRNQQkCXxUxkUni660giUV%2FPO0fHYss1yqYzpozFsRvYbxR6shH%2FCp43vzjF1F2uSkgmfUvv7D5et%2F2IPRzhDwmP3mnGdx0zTh9TyCX2MLD9HMkJkNUeAMRrFQAD38PxzrWU3NoLNg57fFNBwcIItcUTNlBHNUJrH0l9vPF%2BDsY%2BXLBMCn90iTr3iHFLY2A%2FPQKhGAYFwPcZbUjCthP3QBjqwAUsu4Z4AuOHcuZtg9M7jXbRINJAuEUcW7e7fEEuoIfzZgMmNmI7X7GNlb7dX1u%2Bay49F3rgbxWTI654%2B2myuUreK9YvnzfFZZ7DzvyMXsEhxbS%2FzkY2S%2FVQb9aiAaMh%2FOwwyWZGXnAqyGOXH3qNJNBPoQGH6XMLf%2BH8wWvBPlx5dnd8OSjx6gAHI4ESuU340G%2FDp8Tpv%2Ft90Sm2x60pBI9hii6kYSMk%2B1R%2BACJpEixAV&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47U7RYHY7BA%2F20260602%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260602T211449Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=d65116391c6a6dcf9f5e7d7703e5375aebca0a909d5cf1c3567de149b93de1c0\" 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=IQoJb3JpZ2luX2VjEGUaCWV1LXdlc3QtMSJIMEYCIQCCbvlJ4%2FNAkmCAKgGb1Z8VDr8gHJRXNSbNEmPqNAaOHgIhALJZmGFUPAYmYq6%2B7OnnVqDbFjbPgjO1psChn3lsM%2B6kKrkFCC4QBRoMMjczNTcwMTk1NDMzIgws29j7N4%2FJOWuFpBAqlgXOOffrSF9dyPy%2BA3PDW%2BoS4d8EHVtpAIm08HG%2BoA6VqI0wI3DDMXQ0M0U4zVPc3Fu5x5Sqm%2FomHcidwLQwD%2FddwuumS4iFGHIUDxKPIW7PYNRP%2BfsQj1KA6X1HQumZWmCgxOQTVd7PWUU3Dz3%2B17JmlAw0a4AzFvB1jDhHYjjqV4IPWj87DyV0ddHabn4lodrJbtrW0TD6mcQxjhCs8sUCWmLr632UX6kxS6i6Hd43mdZFnN5e6JdzGxnTSRTUPVCXani5fwClGlDOlRl6GA9MF1RTQiFbETCvNohaPbwv0R3VDNu24bNORBZ5IhcL%2BGCmKWATjB58Gt0iF9LCqyYtS3YGhwHY12Ds%2FgQLBR7Cs0Uc6CqIz918goh5YPkZ%2FOleJVCppUtmyUCTDq5pp6JvwtzzWEy7etRfNFsR6e%2BHkcJb7tGFWOdQ%2FqmiBSa7zWqmlw%2FJp4pXHMke4iPb6fDvWJVnl5ZNKZ8wdrp2s6uUR5ah%2Bb7vLXg0frMLLtn%2FSHZA6as1tP0Fgx2oR18yijBA8RlhcajWtnAFCOMqswn31wJ4xvvCDPmcoLf%2B74xg6HuPtucEEEAxEjAkul62nqp4pBLdK6u%2F%2FflCdZ%2FxHwuvBr%2FJh6kyKbU2QqdsOQESCyQT9oHjfh9A97zybLRZc6%2Fb3kPtn%2BT05O7Bnf0NRNQQkCXxUxkUni660giUV%2FPO0fHYss1yqYzpozFsRvYbxR6shH%2FCp43vzjF1F2uSkgmfUvv7D5et%2F2IPRzhDwmP3mnGdx0zTh9TyCX2MLD9HMkJkNUeAMRrFQAD38PxzrWU3NoLNg57fFNBwcIItcUTNlBHNUJrH0l9vPF%2BDsY%2BXLBMCn90iTr3iHFLY2A%2FPQKhGAYFwPcZbUjCthP3QBjqwAUsu4Z4AuOHcuZtg9M7jXbRINJAuEUcW7e7fEEuoIfzZgMmNmI7X7GNlb7dX1u%2Bay49F3rgbxWTI654%2B2myuUreK9YvnzfFZZ7DzvyMXsEhxbS%2FzkY2S%2FVQb9aiAaMh%2FOwwyWZGXnAqyGOXH3qNJNBPoQGH6XMLf%2BH8wWvBPlx5dnd8OSjx6gAHI4ESuU340G%2FDp8Tpv%2Ft90Sm2x60pBI9hii6kYSMk%2B1R%2BACJpEixAV&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47U7RYHY7BA%2F20260602%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260602T211449Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=bb0760172703d0e7c845e765a13d9d899605569d402ee23c1c1ceac578bc939d\" 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=IQoJb3JpZ2luX2VjEGUaCWV1LXdlc3QtMSJIMEYCIQCCbvlJ4%2FNAkmCAKgGb1Z8VDr8gHJRXNSbNEmPqNAaOHgIhALJZmGFUPAYmYq6%2B7OnnVqDbFjbPgjO1psChn3lsM%2B6kKrkFCC4QBRoMMjczNTcwMTk1NDMzIgws29j7N4%2FJOWuFpBAqlgXOOffrSF9dyPy%2BA3PDW%2BoS4d8EHVtpAIm08HG%2BoA6VqI0wI3DDMXQ0M0U4zVPc3Fu5x5Sqm%2FomHcidwLQwD%2FddwuumS4iFGHIUDxKPIW7PYNRP%2BfsQj1KA6X1HQumZWmCgxOQTVd7PWUU3Dz3%2B17JmlAw0a4AzFvB1jDhHYjjqV4IPWj87DyV0ddHabn4lodrJbtrW0TD6mcQxjhCs8sUCWmLr632UX6kxS6i6Hd43mdZFnN5e6JdzGxnTSRTUPVCXani5fwClGlDOlRl6GA9MF1RTQiFbETCvNohaPbwv0R3VDNu24bNORBZ5IhcL%2BGCmKWATjB58Gt0iF9LCqyYtS3YGhwHY12Ds%2FgQLBR7Cs0Uc6CqIz918goh5YPkZ%2FOleJVCppUtmyUCTDq5pp6JvwtzzWEy7etRfNFsR6e%2BHkcJb7tGFWOdQ%2FqmiBSa7zWqmlw%2FJp4pXHMke4iPb6fDvWJVnl5ZNKZ8wdrp2s6uUR5ah%2Bb7vLXg0frMLLtn%2FSHZA6as1tP0Fgx2oR18yijBA8RlhcajWtnAFCOMqswn31wJ4xvvCDPmcoLf%2B74xg6HuPtucEEEAxEjAkul62nqp4pBLdK6u%2F%2FflCdZ%2FxHwuvBr%2FJh6kyKbU2QqdsOQESCyQT9oHjfh9A97zybLRZc6%2Fb3kPtn%2BT05O7Bnf0NRNQQkCXxUxkUni660giUV%2FPO0fHYss1yqYzpozFsRvYbxR6shH%2FCp43vzjF1F2uSkgmfUvv7D5et%2F2IPRzhDwmP3mnGdx0zTh9TyCX2MLD9HMkJkNUeAMRrFQAD38PxzrWU3NoLNg57fFNBwcIItcUTNlBHNUJrH0l9vPF%2BDsY%2BXLBMCn90iTr3iHFLY2A%2FPQKhGAYFwPcZbUjCthP3QBjqwAUsu4Z4AuOHcuZtg9M7jXbRINJAuEUcW7e7fEEuoIfzZgMmNmI7X7GNlb7dX1u%2Bay49F3rgbxWTI654%2B2myuUreK9YvnzfFZZ7DzvyMXsEhxbS%2FzkY2S%2FVQb9aiAaMh%2FOwwyWZGXnAqyGOXH3qNJNBPoQGH6XMLf%2BH8wWvBPlx5dnd8OSjx6gAHI4ESuU340G%2FDp8Tpv%2Ft90Sm2x60pBI9hii6kYSMk%2B1R%2BACJpEixAV&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47U7RYHY7BA%2F20260602%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260602T211449Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=bb0760172703d0e7c845e765a13d9d899605569d402ee23c1c1ceac578bc939d 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=IQoJb3JpZ2luX2VjEGUaCWV1LXdlc3QtMSJIMEYCIQCCbvlJ4%2FNAkmCAKgGb1Z8VDr8gHJRXNSbNEmPqNAaOHgIhALJZmGFUPAYmYq6%2B7OnnVqDbFjbPgjO1psChn3lsM%2B6kKrkFCC4QBRoMMjczNTcwMTk1NDMzIgws29j7N4%2FJOWuFpBAqlgXOOffrSF9dyPy%2BA3PDW%2BoS4d8EHVtpAIm08HG%2BoA6VqI0wI3DDMXQ0M0U4zVPc3Fu5x5Sqm%2FomHcidwLQwD%2FddwuumS4iFGHIUDxKPIW7PYNRP%2BfsQj1KA6X1HQumZWmCgxOQTVd7PWUU3Dz3%2B17JmlAw0a4AzFvB1jDhHYjjqV4IPWj87DyV0ddHabn4lodrJbtrW0TD6mcQxjhCs8sUCWmLr632UX6kxS6i6Hd43mdZFnN5e6JdzGxnTSRTUPVCXani5fwClGlDOlRl6GA9MF1RTQiFbETCvNohaPbwv0R3VDNu24bNORBZ5IhcL%2BGCmKWATjB58Gt0iF9LCqyYtS3YGhwHY12Ds%2FgQLBR7Cs0Uc6CqIz918goh5YPkZ%2FOleJVCppUtmyUCTDq5pp6JvwtzzWEy7etRfNFsR6e%2BHkcJb7tGFWOdQ%2FqmiBSa7zWqmlw%2FJp4pXHMke4iPb6fDvWJVnl5ZNKZ8wdrp2s6uUR5ah%2Bb7vLXg0frMLLtn%2FSHZA6as1tP0Fgx2oR18yijBA8RlhcajWtnAFCOMqswn31wJ4xvvCDPmcoLf%2B74xg6HuPtucEEEAxEjAkul62nqp4pBLdK6u%2F%2FflCdZ%2FxHwuvBr%2FJh6kyKbU2QqdsOQESCyQT9oHjfh9A97zybLRZc6%2Fb3kPtn%2BT05O7Bnf0NRNQQkCXxUxkUni660giUV%2FPO0fHYss1yqYzpozFsRvYbxR6shH%2FCp43vzjF1F2uSkgmfUvv7D5et%2F2IPRzhDwmP3mnGdx0zTh9TyCX2MLD9HMkJkNUeAMRrFQAD38PxzrWU3NoLNg57fFNBwcIItcUTNlBHNUJrH0l9vPF%2BDsY%2BXLBMCn90iTr3iHFLY2A%2FPQKhGAYFwPcZbUjCthP3QBjqwAUsu4Z4AuOHcuZtg9M7jXbRINJAuEUcW7e7fEEuoIfzZgMmNmI7X7GNlb7dX1u%2Bay49F3rgbxWTI654%2B2myuUreK9YvnzfFZZ7DzvyMXsEhxbS%2FzkY2S%2FVQb9aiAaMh%2FOwwyWZGXnAqyGOXH3qNJNBPoQGH6XMLf%2BH8wWvBPlx5dnd8OSjx6gAHI4ESuU340G%2FDp8Tpv%2Ft90Sm2x60pBI9hii6kYSMk%2B1R%2BACJpEixAV&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47U7RYHY7BA%2F20260602%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260602T211449Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=5639b2dd8e5bc8a63baa2e8151a6a101c425faae8f764f3b157cd96bc26c8d3c 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=IQoJb3JpZ2luX2VjEGUaCWV1LXdlc3QtMSJIMEYCIQCCbvlJ4%2FNAkmCAKgGb1Z8VDr8gHJRXNSbNEmPqNAaOHgIhALJZmGFUPAYmYq6%2B7OnnVqDbFjbPgjO1psChn3lsM%2B6kKrkFCC4QBRoMMjczNTcwMTk1NDMzIgws29j7N4%2FJOWuFpBAqlgXOOffrSF9dyPy%2BA3PDW%2BoS4d8EHVtpAIm08HG%2BoA6VqI0wI3DDMXQ0M0U4zVPc3Fu5x5Sqm%2FomHcidwLQwD%2FddwuumS4iFGHIUDxKPIW7PYNRP%2BfsQj1KA6X1HQumZWmCgxOQTVd7PWUU3Dz3%2B17JmlAw0a4AzFvB1jDhHYjjqV4IPWj87DyV0ddHabn4lodrJbtrW0TD6mcQxjhCs8sUCWmLr632UX6kxS6i6Hd43mdZFnN5e6JdzGxnTSRTUPVCXani5fwClGlDOlRl6GA9MF1RTQiFbETCvNohaPbwv0R3VDNu24bNORBZ5IhcL%2BGCmKWATjB58Gt0iF9LCqyYtS3YGhwHY12Ds%2FgQLBR7Cs0Uc6CqIz918goh5YPkZ%2FOleJVCppUtmyUCTDq5pp6JvwtzzWEy7etRfNFsR6e%2BHkcJb7tGFWOdQ%2FqmiBSa7zWqmlw%2FJp4pXHMke4iPb6fDvWJVnl5ZNKZ8wdrp2s6uUR5ah%2Bb7vLXg0frMLLtn%2FSHZA6as1tP0Fgx2oR18yijBA8RlhcajWtnAFCOMqswn31wJ4xvvCDPmcoLf%2B74xg6HuPtucEEEAxEjAkul62nqp4pBLdK6u%2F%2FflCdZ%2FxHwuvBr%2FJh6kyKbU2QqdsOQESCyQT9oHjfh9A97zybLRZc6%2Fb3kPtn%2BT05O7Bnf0NRNQQkCXxUxkUni660giUV%2FPO0fHYss1yqYzpozFsRvYbxR6shH%2FCp43vzjF1F2uSkgmfUvv7D5et%2F2IPRzhDwmP3mnGdx0zTh9TyCX2MLD9HMkJkNUeAMRrFQAD38PxzrWU3NoLNg57fFNBwcIItcUTNlBHNUJrH0l9vPF%2BDsY%2BXLBMCn90iTr3iHFLY2A%2FPQKhGAYFwPcZbUjCthP3QBjqwAUsu4Z4AuOHcuZtg9M7jXbRINJAuEUcW7e7fEEuoIfzZgMmNmI7X7GNlb7dX1u%2Bay49F3rgbxWTI654%2B2myuUreK9YvnzfFZZ7DzvyMXsEhxbS%2FzkY2S%2FVQb9aiAaMh%2FOwwyWZGXnAqyGOXH3qNJNBPoQGH6XMLf%2BH8wWvBPlx5dnd8OSjx6gAHI4ESuU340G%2FDp8Tpv%2Ft90Sm2x60pBI9hii6kYSMk%2B1R%2BACJpEixAV&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47U7RYHY7BA%2F20260602%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260602T211449Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=5639b2dd8e5bc8a63baa2e8151a6a101c425faae8f764f3b157cd96bc26c8d3c\" 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=IQoJb3JpZ2luX2VjEGUaCWV1LXdlc3QtMSJIMEYCIQCCbvlJ4%2FNAkmCAKgGb1Z8VDr8gHJRXNSbNEmPqNAaOHgIhALJZmGFUPAYmYq6%2B7OnnVqDbFjbPgjO1psChn3lsM%2B6kKrkFCC4QBRoMMjczNTcwMTk1NDMzIgws29j7N4%2FJOWuFpBAqlgXOOffrSF9dyPy%2BA3PDW%2BoS4d8EHVtpAIm08HG%2BoA6VqI0wI3DDMXQ0M0U4zVPc3Fu5x5Sqm%2FomHcidwLQwD%2FddwuumS4iFGHIUDxKPIW7PYNRP%2BfsQj1KA6X1HQumZWmCgxOQTVd7PWUU3Dz3%2B17JmlAw0a4AzFvB1jDhHYjjqV4IPWj87DyV0ddHabn4lodrJbtrW0TD6mcQxjhCs8sUCWmLr632UX6kxS6i6Hd43mdZFnN5e6JdzGxnTSRTUPVCXani5fwClGlDOlRl6GA9MF1RTQiFbETCvNohaPbwv0R3VDNu24bNORBZ5IhcL%2BGCmKWATjB58Gt0iF9LCqyYtS3YGhwHY12Ds%2FgQLBR7Cs0Uc6CqIz918goh5YPkZ%2FOleJVCppUtmyUCTDq5pp6JvwtzzWEy7etRfNFsR6e%2BHkcJb7tGFWOdQ%2FqmiBSa7zWqmlw%2FJp4pXHMke4iPb6fDvWJVnl5ZNKZ8wdrp2s6uUR5ah%2Bb7vLXg0frMLLtn%2FSHZA6as1tP0Fgx2oR18yijBA8RlhcajWtnAFCOMqswn31wJ4xvvCDPmcoLf%2B74xg6HuPtucEEEAxEjAkul62nqp4pBLdK6u%2F%2FflCdZ%2FxHwuvBr%2FJh6kyKbU2QqdsOQESCyQT9oHjfh9A97zybLRZc6%2Fb3kPtn%2BT05O7Bnf0NRNQQkCXxUxkUni660giUV%2FPO0fHYss1yqYzpozFsRvYbxR6shH%2FCp43vzjF1F2uSkgmfUvv7D5et%2F2IPRzhDwmP3mnGdx0zTh9TyCX2MLD9HMkJkNUeAMRrFQAD38PxzrWU3NoLNg57fFNBwcIItcUTNlBHNUJrH0l9vPF%2BDsY%2BXLBMCn90iTr3iHFLY2A%2FPQKhGAYFwPcZbUjCthP3QBjqwAUsu4Z4AuOHcuZtg9M7jXbRINJAuEUcW7e7fEEuoIfzZgMmNmI7X7GNlb7dX1u%2Bay49F3rgbxWTI654%2B2myuUreK9YvnzfFZZ7DzvyMXsEhxbS%2FzkY2S%2FVQb9aiAaMh%2FOwwyWZGXnAqyGOXH3qNJNBPoQGH6XMLf%2BH8wWvBPlx5dnd8OSjx6gAHI4ESuU340G%2FDp8Tpv%2Ft90Sm2x60pBI9hii6kYSMk%2B1R%2BACJpEixAV&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47U7RYHY7BA%2F20260602%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260602T211449Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=a32eb82923af6743776a58d8dc8f60292e461f9afc68f6f061e9089a193d94ce\" 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=IQoJb3JpZ2luX2VjEGUaCWV1LXdlc3QtMSJIMEYCIQCCbvlJ4%2FNAkmCAKgGb1Z8VDr8gHJRXNSbNEmPqNAaOHgIhALJZmGFUPAYmYq6%2B7OnnVqDbFjbPgjO1psChn3lsM%2B6kKrkFCC4QBRoMMjczNTcwMTk1NDMzIgws29j7N4%2FJOWuFpBAqlgXOOffrSF9dyPy%2BA3PDW%2BoS4d8EHVtpAIm08HG%2BoA6VqI0wI3DDMXQ0M0U4zVPc3Fu5x5Sqm%2FomHcidwLQwD%2FddwuumS4iFGHIUDxKPIW7PYNRP%2BfsQj1KA6X1HQumZWmCgxOQTVd7PWUU3Dz3%2B17JmlAw0a4AzFvB1jDhHYjjqV4IPWj87DyV0ddHabn4lodrJbtrW0TD6mcQxjhCs8sUCWmLr632UX6kxS6i6Hd43mdZFnN5e6JdzGxnTSRTUPVCXani5fwClGlDOlRl6GA9MF1RTQiFbETCvNohaPbwv0R3VDNu24bNORBZ5IhcL%2BGCmKWATjB58Gt0iF9LCqyYtS3YGhwHY12Ds%2FgQLBR7Cs0Uc6CqIz918goh5YPkZ%2FOleJVCppUtmyUCTDq5pp6JvwtzzWEy7etRfNFsR6e%2BHkcJb7tGFWOdQ%2FqmiBSa7zWqmlw%2FJp4pXHMke4iPb6fDvWJVnl5ZNKZ8wdrp2s6uUR5ah%2Bb7vLXg0frMLLtn%2FSHZA6as1tP0Fgx2oR18yijBA8RlhcajWtnAFCOMqswn31wJ4xvvCDPmcoLf%2B74xg6HuPtucEEEAxEjAkul62nqp4pBLdK6u%2F%2FflCdZ%2FxHwuvBr%2FJh6kyKbU2QqdsOQESCyQT9oHjfh9A97zybLRZc6%2Fb3kPtn%2BT05O7Bnf0NRNQQkCXxUxkUni660giUV%2FPO0fHYss1yqYzpozFsRvYbxR6shH%2FCp43vzjF1F2uSkgmfUvv7D5et%2F2IPRzhDwmP3mnGdx0zTh9TyCX2MLD9HMkJkNUeAMRrFQAD38PxzrWU3NoLNg57fFNBwcIItcUTNlBHNUJrH0l9vPF%2BDsY%2BXLBMCn90iTr3iHFLY2A%2FPQKhGAYFwPcZbUjCthP3QBjqwAUsu4Z4AuOHcuZtg9M7jXbRINJAuEUcW7e7fEEuoIfzZgMmNmI7X7GNlb7dX1u%2Bay49F3rgbxWTI654%2B2myuUreK9YvnzfFZZ7DzvyMXsEhxbS%2FzkY2S%2FVQb9aiAaMh%2FOwwyWZGXnAqyGOXH3qNJNBPoQGH6XMLf%2BH8wWvBPlx5dnd8OSjx6gAHI4ESuU340G%2FDp8Tpv%2Ft90Sm2x60pBI9hii6kYSMk%2B1R%2BACJpEixAV&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47U7RYHY7BA%2F20260602%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260602T211449Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=a32eb82923af6743776a58d8dc8f60292e461f9afc68f6f061e9089a193d94ce 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=IQoJb3JpZ2luX2VjEGUaCWV1LXdlc3QtMSJIMEYCIQCCbvlJ4%2FNAkmCAKgGb1Z8VDr8gHJRXNSbNEmPqNAaOHgIhALJZmGFUPAYmYq6%2B7OnnVqDbFjbPgjO1psChn3lsM%2B6kKrkFCC4QBRoMMjczNTcwMTk1NDMzIgws29j7N4%2FJOWuFpBAqlgXOOffrSF9dyPy%2BA3PDW%2BoS4d8EHVtpAIm08HG%2BoA6VqI0wI3DDMXQ0M0U4zVPc3Fu5x5Sqm%2FomHcidwLQwD%2FddwuumS4iFGHIUDxKPIW7PYNRP%2BfsQj1KA6X1HQumZWmCgxOQTVd7PWUU3Dz3%2B17JmlAw0a4AzFvB1jDhHYjjqV4IPWj87DyV0ddHabn4lodrJbtrW0TD6mcQxjhCs8sUCWmLr632UX6kxS6i6Hd43mdZFnN5e6JdzGxnTSRTUPVCXani5fwClGlDOlRl6GA9MF1RTQiFbETCvNohaPbwv0R3VDNu24bNORBZ5IhcL%2BGCmKWATjB58Gt0iF9LCqyYtS3YGhwHY12Ds%2FgQLBR7Cs0Uc6CqIz918goh5YPkZ%2FOleJVCppUtmyUCTDq5pp6JvwtzzWEy7etRfNFsR6e%2BHkcJb7tGFWOdQ%2FqmiBSa7zWqmlw%2FJp4pXHMke4iPb6fDvWJVnl5ZNKZ8wdrp2s6uUR5ah%2Bb7vLXg0frMLLtn%2FSHZA6as1tP0Fgx2oR18yijBA8RlhcajWtnAFCOMqswn31wJ4xvvCDPmcoLf%2B74xg6HuPtucEEEAxEjAkul62nqp4pBLdK6u%2F%2FflCdZ%2FxHwuvBr%2FJh6kyKbU2QqdsOQESCyQT9oHjfh9A97zybLRZc6%2Fb3kPtn%2BT05O7Bnf0NRNQQkCXxUxkUni660giUV%2FPO0fHYss1yqYzpozFsRvYbxR6shH%2FCp43vzjF1F2uSkgmfUvv7D5et%2F2IPRzhDwmP3mnGdx0zTh9TyCX2MLD9HMkJkNUeAMRrFQAD38PxzrWU3NoLNg57fFNBwcIItcUTNlBHNUJrH0l9vPF%2BDsY%2BXLBMCn90iTr3iHFLY2A%2FPQKhGAYFwPcZbUjCthP3QBjqwAUsu4Z4AuOHcuZtg9M7jXbRINJAuEUcW7e7fEEuoIfzZgMmNmI7X7GNlb7dX1u%2Bay49F3rgbxWTI654%2B2myuUreK9YvnzfFZZ7DzvyMXsEhxbS%2FzkY2S%2FVQb9aiAaMh%2FOwwyWZGXnAqyGOXH3qNJNBPoQGH6XMLf%2BH8wWvBPlx5dnd8OSjx6gAHI4ESuU340G%2FDp8Tpv%2Ft90Sm2x60pBI9hii6kYSMk%2B1R%2BACJpEixAV&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47U7RYHY7BA%2F20260602%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260602T211449Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=34f058b66dee54a95c141809cb36f97480c717753c10417b3fffbfe1ba6c89b1 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=IQoJb3JpZ2luX2VjEGUaCWV1LXdlc3QtMSJIMEYCIQCCbvlJ4%2FNAkmCAKgGb1Z8VDr8gHJRXNSbNEmPqNAaOHgIhALJZmGFUPAYmYq6%2B7OnnVqDbFjbPgjO1psChn3lsM%2B6kKrkFCC4QBRoMMjczNTcwMTk1NDMzIgws29j7N4%2FJOWuFpBAqlgXOOffrSF9dyPy%2BA3PDW%2BoS4d8EHVtpAIm08HG%2BoA6VqI0wI3DDMXQ0M0U4zVPc3Fu5x5Sqm%2FomHcidwLQwD%2FddwuumS4iFGHIUDxKPIW7PYNRP%2BfsQj1KA6X1HQumZWmCgxOQTVd7PWUU3Dz3%2B17JmlAw0a4AzFvB1jDhHYjjqV4IPWj87DyV0ddHabn4lodrJbtrW0TD6mcQxjhCs8sUCWmLr632UX6kxS6i6Hd43mdZFnN5e6JdzGxnTSRTUPVCXani5fwClGlDOlRl6GA9MF1RTQiFbETCvNohaPbwv0R3VDNu24bNORBZ5IhcL%2BGCmKWATjB58Gt0iF9LCqyYtS3YGhwHY12Ds%2FgQLBR7Cs0Uc6CqIz918goh5YPkZ%2FOleJVCppUtmyUCTDq5pp6JvwtzzWEy7etRfNFsR6e%2BHkcJb7tGFWOdQ%2FqmiBSa7zWqmlw%2FJp4pXHMke4iPb6fDvWJVnl5ZNKZ8wdrp2s6uUR5ah%2Bb7vLXg0frMLLtn%2FSHZA6as1tP0Fgx2oR18yijBA8RlhcajWtnAFCOMqswn31wJ4xvvCDPmcoLf%2B74xg6HuPtucEEEAxEjAkul62nqp4pBLdK6u%2F%2FflCdZ%2FxHwuvBr%2FJh6kyKbU2QqdsOQESCyQT9oHjfh9A97zybLRZc6%2Fb3kPtn%2BT05O7Bnf0NRNQQkCXxUxkUni660giUV%2FPO0fHYss1yqYzpozFsRvYbxR6shH%2FCp43vzjF1F2uSkgmfUvv7D5et%2F2IPRzhDwmP3mnGdx0zTh9TyCX2MLD9HMkJkNUeAMRrFQAD38PxzrWU3NoLNg57fFNBwcIItcUTNlBHNUJrH0l9vPF%2BDsY%2BXLBMCn90iTr3iHFLY2A%2FPQKhGAYFwPcZbUjCthP3QBjqwAUsu4Z4AuOHcuZtg9M7jXbRINJAuEUcW7e7fEEuoIfzZgMmNmI7X7GNlb7dX1u%2Bay49F3rgbxWTI654%2B2myuUreK9YvnzfFZZ7DzvyMXsEhxbS%2FzkY2S%2FVQb9aiAaMh%2FOwwyWZGXnAqyGOXH3qNJNBPoQGH6XMLf%2BH8wWvBPlx5dnd8OSjx6gAHI4ESuU340G%2FDp8Tpv%2Ft90Sm2x60pBI9hii6kYSMk%2B1R%2BACJpEixAV&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47U7RYHY7BA%2F20260602%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260602T211449Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=34f058b66dee54a95c141809cb36f97480c717753c10417b3fffbfe1ba6c89b1\" 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}]}}