{"id":151,"date":"2013-02-07T11:05:35","date_gmt":"2013-02-07T11:05:35","guid":{"rendered":"https:\/\/blogs.glowscotland.org.uk\/nl\/ColtnessHS-ComputingScience\/?p=151"},"modified":"2013-02-07T11:05:35","modified_gmt":"2013-02-07T11:05:35","slug":"spreadsheet-formula","status":"publish","type":"post","link":"https:\/\/blogs.glowscotland.org.uk\/nl\/ColtnessHS-ComputingScience\/2013\/02\/07\/spreadsheet-formula\/","title":{"rendered":"Spreadsheet Formula"},"content":{"rendered":"<p>Today we looked at how spreadsheets use formula. Every spreadsheet formula must start with an equals sign (=), this tells the spreadsheet application to treat the cell contents as a formula.<\/p>\n<p>We use the following\u00a0mathematical\u00a0formula in spreadsheets<\/p>\n<ul>\n<li>Add +<\/li>\n<li>Subtract &#8211;<\/li>\n<li>Multiply *<\/li>\n<li>Divide \/<\/li>\n<\/ul>\n<p>The rules of BODMAS apply for complex\u00a0mathematical\u00a0conditions<\/p>\n<ul>\n<li>=A1*A5<\/li>\n<li>=A1*A5 + 5<\/li>\n<li>=A1*(A5+5)<\/li>\n<\/ul>\n<p><!--more--><\/p>\n<div data-carousel-extra='{&quot;blog_id&quot;:12638,&quot;permalink&quot;:&quot;https:\/\/blogs.glowscotland.org.uk\/nl\/ColtnessHS-ComputingScience\/2013\/02\/07\/spreadsheet-formula\/&quot;}' id='gallery-1' class='gallery galleryid-151 gallery-columns-2 gallery-size-thumbnail'><figure class='gallery-item'>\n\t\t\t<div class='gallery-icon landscape'>\n\t\t\t\t<a href='https:\/\/blogs.glowscotland.org.uk\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2013\/02\/Slide123.png'><img decoding=\"async\" width=\"150\" height=\"112\" src=\"https:\/\/glow-prod-nl.s3.eu-west-1.amazonaws.com\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2013\/02\/Slide123-150x112.png?X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&amp;X-Amz-Security-Token=IQoJb3JpZ2luX2VjEKb%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJHMEUCIB8wzBylTr%2FWrXeq44%2BT7KgBfbdpi8zKp3nO8vaotSJGAiEA9KlRQzdpiE%2BeU%2BAskK71CVDiyPGfadmaES5NCePn2B0quAUIbxAFGgwyNzM1NzAxOTU0MzMiDP7A8eg7UIdy0JluWSqVBZHdF1203GJ4EtUE2fgJgXuxonaoCgF8GqRMjoiBHYww9d2CzIgY9dJDjYfuqjl6bCWND7Dd6%2BEp3cFSajTgXcdy752YdGEct2Xi5njzI2TZt9tDMA0silInxsFkWrPV1iQUQLICRNtzLsmZ%2FfT0mvaJaUquDX0ZFtWLwn%2Fvh1AWUl%2FX5Z9O7tRbp%2FKkBhY2VXTe8ZxziAum9XODiY8KREVwbbgTnWQBSMZ56bRb0dIWCAGRk7hf%2FRn7uQ%2Bi0fHBejxox8yQ5QH%2BiguyzSw9QAZpjPltkjCtnqdFJWGPhJn8v%2BqcIL1oQLQmR8DcUnbxWLbkhR8XoViEcLsbj1cMjZqbWE1Jq%2Bj44O60vTYW3hrARjTUOW%2Fw%2BL5ZCmy1WWv9OUvARK%2FYzCkHqbH%2BRdP8F6AbqrfzUS5T%2FkAdc5LAJ6mrI1o320BwKJ%2Fm1qAEjASB4ZO3FzYrzeYXKHMyMcwA%2BQyQy2Aa6rVDsayHGcTwa2zY6guinpf7hbWkY%2BERNdEIKvYjj5KN0G1kDqDjEMoh%2FEN3K%2FfXwrR4cPLnPM71Vj8ikrmiq2KvNtjpMh1R5UL2oiVFhgP9KUXygaw3fbhO0AvGNQ7pvqSp%2BIIi0XRm%2B72R5cdzMLVCGKtDJTjuwviSz2htezhXc0ORV%2Fuh%2BjgM4QO7Eg1CiGxLvYvfWqse%2FaidhxJaSbzDsPYcgdpHjO17lxrLWGh5RenLEC9VjrBl7IqKHTXA4GRkyBEpLm07t%2B%2B77Sz49sWp%2BfQfWTAec4CPOHI3GPwlCP77%2FQSGpY896V9cKHh5arOSXMQPKwo1aEbHXHJZntS4JVK%2F5HWePWXmmiQNC0a6bpFFnTDzC3d6qn2xGOTyLef4QYKzD0vGW1zkUbFRKqQwvK6u1gY6sQEVG9p%2BLmO%2BUN1WqKtLna3pRFBjUK5G7C14QhxXdXel7zKQqDjNn%2BJdXGJm%2BJlEeW81yFxEHTrCenxOg5xwgtkfyVWrox7vD5Iwihsk9pIZE%2B4DASUFbFtFaO6LYeFXGc%2FdVeSE08vucgvVZ0%2FkscFothvFfevzrAF1PErp1oliX%2FntLd3yNPLQQgr2dplIv6bPfMnMe76OvTM%2FAnMpUvteIq8pC53EKKDd2R%2BXhezcmxI%3D&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47UR5ILKSLD%2F20261011%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20261011T143044Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=69a927c3d58cf53cfea35565d5dd8d77b2eb7d138bef2914cdabd99e36d85e9e\" class=\"attachment-thumbnail size-thumbnail\" alt=\"\" srcset=\"https:\/\/glow-prod-nl.s3.eu-west-1.amazonaws.com\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2013\/02\/Slide123-150x112.png?X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&amp;X-Amz-Security-Token=IQoJb3JpZ2luX2VjEKb%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJHMEUCIB8wzBylTr%2FWrXeq44%2BT7KgBfbdpi8zKp3nO8vaotSJGAiEA9KlRQzdpiE%2BeU%2BAskK71CVDiyPGfadmaES5NCePn2B0quAUIbxAFGgwyNzM1NzAxOTU0MzMiDP7A8eg7UIdy0JluWSqVBZHdF1203GJ4EtUE2fgJgXuxonaoCgF8GqRMjoiBHYww9d2CzIgY9dJDjYfuqjl6bCWND7Dd6%2BEp3cFSajTgXcdy752YdGEct2Xi5njzI2TZt9tDMA0silInxsFkWrPV1iQUQLICRNtzLsmZ%2FfT0mvaJaUquDX0ZFtWLwn%2Fvh1AWUl%2FX5Z9O7tRbp%2FKkBhY2VXTe8ZxziAum9XODiY8KREVwbbgTnWQBSMZ56bRb0dIWCAGRk7hf%2FRn7uQ%2Bi0fHBejxox8yQ5QH%2BiguyzSw9QAZpjPltkjCtnqdFJWGPhJn8v%2BqcIL1oQLQmR8DcUnbxWLbkhR8XoViEcLsbj1cMjZqbWE1Jq%2Bj44O60vTYW3hrARjTUOW%2Fw%2BL5ZCmy1WWv9OUvARK%2FYzCkHqbH%2BRdP8F6AbqrfzUS5T%2FkAdc5LAJ6mrI1o320BwKJ%2Fm1qAEjASB4ZO3FzYrzeYXKHMyMcwA%2BQyQy2Aa6rVDsayHGcTwa2zY6guinpf7hbWkY%2BERNdEIKvYjj5KN0G1kDqDjEMoh%2FEN3K%2FfXwrR4cPLnPM71Vj8ikrmiq2KvNtjpMh1R5UL2oiVFhgP9KUXygaw3fbhO0AvGNQ7pvqSp%2BIIi0XRm%2B72R5cdzMLVCGKtDJTjuwviSz2htezhXc0ORV%2Fuh%2BjgM4QO7Eg1CiGxLvYvfWqse%2FaidhxJaSbzDsPYcgdpHjO17lxrLWGh5RenLEC9VjrBl7IqKHTXA4GRkyBEpLm07t%2B%2B77Sz49sWp%2BfQfWTAec4CPOHI3GPwlCP77%2FQSGpY896V9cKHh5arOSXMQPKwo1aEbHXHJZntS4JVK%2F5HWePWXmmiQNC0a6bpFFnTDzC3d6qn2xGOTyLef4QYKzD0vGW1zkUbFRKqQwvK6u1gY6sQEVG9p%2BLmO%2BUN1WqKtLna3pRFBjUK5G7C14QhxXdXel7zKQqDjNn%2BJdXGJm%2BJlEeW81yFxEHTrCenxOg5xwgtkfyVWrox7vD5Iwihsk9pIZE%2B4DASUFbFtFaO6LYeFXGc%2FdVeSE08vucgvVZ0%2FkscFothvFfevzrAF1PErp1oliX%2FntLd3yNPLQQgr2dplIv6bPfMnMe76OvTM%2FAnMpUvteIq8pC53EKKDd2R%2BXhezcmxI%3D&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47UR5ILKSLD%2F20261011%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20261011T143044Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=69a927c3d58cf53cfea35565d5dd8d77b2eb7d138bef2914cdabd99e36d85e9e 150w, https:\/\/glow-prod-nl.s3.eu-west-1.amazonaws.com\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2013\/02\/Slide123-300x225.png?X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&amp;X-Amz-Security-Token=IQoJb3JpZ2luX2VjEKb%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJHMEUCIB8wzBylTr%2FWrXeq44%2BT7KgBfbdpi8zKp3nO8vaotSJGAiEA9KlRQzdpiE%2BeU%2BAskK71CVDiyPGfadmaES5NCePn2B0quAUIbxAFGgwyNzM1NzAxOTU0MzMiDP7A8eg7UIdy0JluWSqVBZHdF1203GJ4EtUE2fgJgXuxonaoCgF8GqRMjoiBHYww9d2CzIgY9dJDjYfuqjl6bCWND7Dd6%2BEp3cFSajTgXcdy752YdGEct2Xi5njzI2TZt9tDMA0silInxsFkWrPV1iQUQLICRNtzLsmZ%2FfT0mvaJaUquDX0ZFtWLwn%2Fvh1AWUl%2FX5Z9O7tRbp%2FKkBhY2VXTe8ZxziAum9XODiY8KREVwbbgTnWQBSMZ56bRb0dIWCAGRk7hf%2FRn7uQ%2Bi0fHBejxox8yQ5QH%2BiguyzSw9QAZpjPltkjCtnqdFJWGPhJn8v%2BqcIL1oQLQmR8DcUnbxWLbkhR8XoViEcLsbj1cMjZqbWE1Jq%2Bj44O60vTYW3hrARjTUOW%2Fw%2BL5ZCmy1WWv9OUvARK%2FYzCkHqbH%2BRdP8F6AbqrfzUS5T%2FkAdc5LAJ6mrI1o320BwKJ%2Fm1qAEjASB4ZO3FzYrzeYXKHMyMcwA%2BQyQy2Aa6rVDsayHGcTwa2zY6guinpf7hbWkY%2BERNdEIKvYjj5KN0G1kDqDjEMoh%2FEN3K%2FfXwrR4cPLnPM71Vj8ikrmiq2KvNtjpMh1R5UL2oiVFhgP9KUXygaw3fbhO0AvGNQ7pvqSp%2BIIi0XRm%2B72R5cdzMLVCGKtDJTjuwviSz2htezhXc0ORV%2Fuh%2BjgM4QO7Eg1CiGxLvYvfWqse%2FaidhxJaSbzDsPYcgdpHjO17lxrLWGh5RenLEC9VjrBl7IqKHTXA4GRkyBEpLm07t%2B%2B77Sz49sWp%2BfQfWTAec4CPOHI3GPwlCP77%2FQSGpY896V9cKHh5arOSXMQPKwo1aEbHXHJZntS4JVK%2F5HWePWXmmiQNC0a6bpFFnTDzC3d6qn2xGOTyLef4QYKzD0vGW1zkUbFRKqQwvK6u1gY6sQEVG9p%2BLmO%2BUN1WqKtLna3pRFBjUK5G7C14QhxXdXel7zKQqDjNn%2BJdXGJm%2BJlEeW81yFxEHTrCenxOg5xwgtkfyVWrox7vD5Iwihsk9pIZE%2B4DASUFbFtFaO6LYeFXGc%2FdVeSE08vucgvVZ0%2FkscFothvFfevzrAF1PErp1oliX%2FntLd3yNPLQQgr2dplIv6bPfMnMe76OvTM%2FAnMpUvteIq8pC53EKKDd2R%2BXhezcmxI%3D&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47UR5ILKSLD%2F20261011%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20261011T143044Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=1bafb2f6bf81260e858332ca25073b3751bb4e20d182dd1f2ff07a51470cf11b 300w, https:\/\/blogs.glowscotland.org.uk\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2013\/02\/Slide123.png 600w\" sizes=\"(max-width: 150px) 100vw, 150px\" data-attachment-id=\"152\" data-permalink=\"https:\/\/blogs.glowscotland.org.uk\/nl\/ColtnessHS-ComputingScience\/2013\/02\/07\/spreadsheet-formula\/slide12-4\/\" data-orig-file=\"https:\/\/blogs.glowscotland.org.uk\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2013\/02\/Slide123.png\" data-orig-size=\"600,450\" data-comments-opened=\"1\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;}\" data-image-title=\"Slide12\" data-image-description=\"\" data-image-caption=\"\" data-medium-file=\"https:\/\/glow-prod-nl.s3.eu-west-1.amazonaws.com\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2013\/02\/Slide123-300x225.png?X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&amp;X-Amz-Security-Token=IQoJb3JpZ2luX2VjEKb%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJHMEUCIB8wzBylTr%2FWrXeq44%2BT7KgBfbdpi8zKp3nO8vaotSJGAiEA9KlRQzdpiE%2BeU%2BAskK71CVDiyPGfadmaES5NCePn2B0quAUIbxAFGgwyNzM1NzAxOTU0MzMiDP7A8eg7UIdy0JluWSqVBZHdF1203GJ4EtUE2fgJgXuxonaoCgF8GqRMjoiBHYww9d2CzIgY9dJDjYfuqjl6bCWND7Dd6%2BEp3cFSajTgXcdy752YdGEct2Xi5njzI2TZt9tDMA0silInxsFkWrPV1iQUQLICRNtzLsmZ%2FfT0mvaJaUquDX0ZFtWLwn%2Fvh1AWUl%2FX5Z9O7tRbp%2FKkBhY2VXTe8ZxziAum9XODiY8KREVwbbgTnWQBSMZ56bRb0dIWCAGRk7hf%2FRn7uQ%2Bi0fHBejxox8yQ5QH%2BiguyzSw9QAZpjPltkjCtnqdFJWGPhJn8v%2BqcIL1oQLQmR8DcUnbxWLbkhR8XoViEcLsbj1cMjZqbWE1Jq%2Bj44O60vTYW3hrARjTUOW%2Fw%2BL5ZCmy1WWv9OUvARK%2FYzCkHqbH%2BRdP8F6AbqrfzUS5T%2FkAdc5LAJ6mrI1o320BwKJ%2Fm1qAEjASB4ZO3FzYrzeYXKHMyMcwA%2BQyQy2Aa6rVDsayHGcTwa2zY6guinpf7hbWkY%2BERNdEIKvYjj5KN0G1kDqDjEMoh%2FEN3K%2FfXwrR4cPLnPM71Vj8ikrmiq2KvNtjpMh1R5UL2oiVFhgP9KUXygaw3fbhO0AvGNQ7pvqSp%2BIIi0XRm%2B72R5cdzMLVCGKtDJTjuwviSz2htezhXc0ORV%2Fuh%2BjgM4QO7Eg1CiGxLvYvfWqse%2FaidhxJaSbzDsPYcgdpHjO17lxrLWGh5RenLEC9VjrBl7IqKHTXA4GRkyBEpLm07t%2B%2B77Sz49sWp%2BfQfWTAec4CPOHI3GPwlCP77%2FQSGpY896V9cKHh5arOSXMQPKwo1aEbHXHJZntS4JVK%2F5HWePWXmmiQNC0a6bpFFnTDzC3d6qn2xGOTyLef4QYKzD0vGW1zkUbFRKqQwvK6u1gY6sQEVG9p%2BLmO%2BUN1WqKtLna3pRFBjUK5G7C14QhxXdXel7zKQqDjNn%2BJdXGJm%2BJlEeW81yFxEHTrCenxOg5xwgtkfyVWrox7vD5Iwihsk9pIZE%2B4DASUFbFtFaO6LYeFXGc%2FdVeSE08vucgvVZ0%2FkscFothvFfevzrAF1PErp1oliX%2FntLd3yNPLQQgr2dplIv6bPfMnMe76OvTM%2FAnMpUvteIq8pC53EKKDd2R%2BXhezcmxI%3D&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47UR5ILKSLD%2F20261011%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20261011T143044Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=1bafb2f6bf81260e858332ca25073b3751bb4e20d182dd1f2ff07a51470cf11b\" data-large-file=\"https:\/\/blogs.glowscotland.org.uk\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2013\/02\/Slide123.png\" \/><\/a>\n\t\t\t<\/div><\/figure><figure class='gallery-item'>\n\t\t\t<div class='gallery-icon landscape'>\n\t\t\t\t<a href='https:\/\/blogs.glowscotland.org.uk\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2013\/02\/Slide133.png'><img decoding=\"async\" width=\"150\" height=\"112\" src=\"https:\/\/glow-prod-nl.s3.eu-west-1.amazonaws.com\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2013\/02\/Slide133-150x112.png?X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&amp;X-Amz-Security-Token=IQoJb3JpZ2luX2VjEKb%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJHMEUCIB8wzBylTr%2FWrXeq44%2BT7KgBfbdpi8zKp3nO8vaotSJGAiEA9KlRQzdpiE%2BeU%2BAskK71CVDiyPGfadmaES5NCePn2B0quAUIbxAFGgwyNzM1NzAxOTU0MzMiDP7A8eg7UIdy0JluWSqVBZHdF1203GJ4EtUE2fgJgXuxonaoCgF8GqRMjoiBHYww9d2CzIgY9dJDjYfuqjl6bCWND7Dd6%2BEp3cFSajTgXcdy752YdGEct2Xi5njzI2TZt9tDMA0silInxsFkWrPV1iQUQLICRNtzLsmZ%2FfT0mvaJaUquDX0ZFtWLwn%2Fvh1AWUl%2FX5Z9O7tRbp%2FKkBhY2VXTe8ZxziAum9XODiY8KREVwbbgTnWQBSMZ56bRb0dIWCAGRk7hf%2FRn7uQ%2Bi0fHBejxox8yQ5QH%2BiguyzSw9QAZpjPltkjCtnqdFJWGPhJn8v%2BqcIL1oQLQmR8DcUnbxWLbkhR8XoViEcLsbj1cMjZqbWE1Jq%2Bj44O60vTYW3hrARjTUOW%2Fw%2BL5ZCmy1WWv9OUvARK%2FYzCkHqbH%2BRdP8F6AbqrfzUS5T%2FkAdc5LAJ6mrI1o320BwKJ%2Fm1qAEjASB4ZO3FzYrzeYXKHMyMcwA%2BQyQy2Aa6rVDsayHGcTwa2zY6guinpf7hbWkY%2BERNdEIKvYjj5KN0G1kDqDjEMoh%2FEN3K%2FfXwrR4cPLnPM71Vj8ikrmiq2KvNtjpMh1R5UL2oiVFhgP9KUXygaw3fbhO0AvGNQ7pvqSp%2BIIi0XRm%2B72R5cdzMLVCGKtDJTjuwviSz2htezhXc0ORV%2Fuh%2BjgM4QO7Eg1CiGxLvYvfWqse%2FaidhxJaSbzDsPYcgdpHjO17lxrLWGh5RenLEC9VjrBl7IqKHTXA4GRkyBEpLm07t%2B%2B77Sz49sWp%2BfQfWTAec4CPOHI3GPwlCP77%2FQSGpY896V9cKHh5arOSXMQPKwo1aEbHXHJZntS4JVK%2F5HWePWXmmiQNC0a6bpFFnTDzC3d6qn2xGOTyLef4QYKzD0vGW1zkUbFRKqQwvK6u1gY6sQEVG9p%2BLmO%2BUN1WqKtLna3pRFBjUK5G7C14QhxXdXel7zKQqDjNn%2BJdXGJm%2BJlEeW81yFxEHTrCenxOg5xwgtkfyVWrox7vD5Iwihsk9pIZE%2B4DASUFbFtFaO6LYeFXGc%2FdVeSE08vucgvVZ0%2FkscFothvFfevzrAF1PErp1oliX%2FntLd3yNPLQQgr2dplIv6bPfMnMe76OvTM%2FAnMpUvteIq8pC53EKKDd2R%2BXhezcmxI%3D&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47UR5ILKSLD%2F20261011%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20261011T143044Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=a7638e85acf25b6f44a0d5914c82ee757adaaa3b08bee4c354017dc18653c750\" class=\"attachment-thumbnail size-thumbnail\" alt=\"\" srcset=\"https:\/\/glow-prod-nl.s3.eu-west-1.amazonaws.com\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2013\/02\/Slide133-150x112.png?X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&amp;X-Amz-Security-Token=IQoJb3JpZ2luX2VjEKb%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJHMEUCIB8wzBylTr%2FWrXeq44%2BT7KgBfbdpi8zKp3nO8vaotSJGAiEA9KlRQzdpiE%2BeU%2BAskK71CVDiyPGfadmaES5NCePn2B0quAUIbxAFGgwyNzM1NzAxOTU0MzMiDP7A8eg7UIdy0JluWSqVBZHdF1203GJ4EtUE2fgJgXuxonaoCgF8GqRMjoiBHYww9d2CzIgY9dJDjYfuqjl6bCWND7Dd6%2BEp3cFSajTgXcdy752YdGEct2Xi5njzI2TZt9tDMA0silInxsFkWrPV1iQUQLICRNtzLsmZ%2FfT0mvaJaUquDX0ZFtWLwn%2Fvh1AWUl%2FX5Z9O7tRbp%2FKkBhY2VXTe8ZxziAum9XODiY8KREVwbbgTnWQBSMZ56bRb0dIWCAGRk7hf%2FRn7uQ%2Bi0fHBejxox8yQ5QH%2BiguyzSw9QAZpjPltkjCtnqdFJWGPhJn8v%2BqcIL1oQLQmR8DcUnbxWLbkhR8XoViEcLsbj1cMjZqbWE1Jq%2Bj44O60vTYW3hrARjTUOW%2Fw%2BL5ZCmy1WWv9OUvARK%2FYzCkHqbH%2BRdP8F6AbqrfzUS5T%2FkAdc5LAJ6mrI1o320BwKJ%2Fm1qAEjASB4ZO3FzYrzeYXKHMyMcwA%2BQyQy2Aa6rVDsayHGcTwa2zY6guinpf7hbWkY%2BERNdEIKvYjj5KN0G1kDqDjEMoh%2FEN3K%2FfXwrR4cPLnPM71Vj8ikrmiq2KvNtjpMh1R5UL2oiVFhgP9KUXygaw3fbhO0AvGNQ7pvqSp%2BIIi0XRm%2B72R5cdzMLVCGKtDJTjuwviSz2htezhXc0ORV%2Fuh%2BjgM4QO7Eg1CiGxLvYvfWqse%2FaidhxJaSbzDsPYcgdpHjO17lxrLWGh5RenLEC9VjrBl7IqKHTXA4GRkyBEpLm07t%2B%2B77Sz49sWp%2BfQfWTAec4CPOHI3GPwlCP77%2FQSGpY896V9cKHh5arOSXMQPKwo1aEbHXHJZntS4JVK%2F5HWePWXmmiQNC0a6bpFFnTDzC3d6qn2xGOTyLef4QYKzD0vGW1zkUbFRKqQwvK6u1gY6sQEVG9p%2BLmO%2BUN1WqKtLna3pRFBjUK5G7C14QhxXdXel7zKQqDjNn%2BJdXGJm%2BJlEeW81yFxEHTrCenxOg5xwgtkfyVWrox7vD5Iwihsk9pIZE%2B4DASUFbFtFaO6LYeFXGc%2FdVeSE08vucgvVZ0%2FkscFothvFfevzrAF1PErp1oliX%2FntLd3yNPLQQgr2dplIv6bPfMnMe76OvTM%2FAnMpUvteIq8pC53EKKDd2R%2BXhezcmxI%3D&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47UR5ILKSLD%2F20261011%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20261011T143044Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=a7638e85acf25b6f44a0d5914c82ee757adaaa3b08bee4c354017dc18653c750 150w, https:\/\/glow-prod-nl.s3.eu-west-1.amazonaws.com\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2013\/02\/Slide133-300x225.png?X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&amp;X-Amz-Security-Token=IQoJb3JpZ2luX2VjEKb%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJHMEUCIB8wzBylTr%2FWrXeq44%2BT7KgBfbdpi8zKp3nO8vaotSJGAiEA9KlRQzdpiE%2BeU%2BAskK71CVDiyPGfadmaES5NCePn2B0quAUIbxAFGgwyNzM1NzAxOTU0MzMiDP7A8eg7UIdy0JluWSqVBZHdF1203GJ4EtUE2fgJgXuxonaoCgF8GqRMjoiBHYww9d2CzIgY9dJDjYfuqjl6bCWND7Dd6%2BEp3cFSajTgXcdy752YdGEct2Xi5njzI2TZt9tDMA0silInxsFkWrPV1iQUQLICRNtzLsmZ%2FfT0mvaJaUquDX0ZFtWLwn%2Fvh1AWUl%2FX5Z9O7tRbp%2FKkBhY2VXTe8ZxziAum9XODiY8KREVwbbgTnWQBSMZ56bRb0dIWCAGRk7hf%2FRn7uQ%2Bi0fHBejxox8yQ5QH%2BiguyzSw9QAZpjPltkjCtnqdFJWGPhJn8v%2BqcIL1oQLQmR8DcUnbxWLbkhR8XoViEcLsbj1cMjZqbWE1Jq%2Bj44O60vTYW3hrARjTUOW%2Fw%2BL5ZCmy1WWv9OUvARK%2FYzCkHqbH%2BRdP8F6AbqrfzUS5T%2FkAdc5LAJ6mrI1o320BwKJ%2Fm1qAEjASB4ZO3FzYrzeYXKHMyMcwA%2BQyQy2Aa6rVDsayHGcTwa2zY6guinpf7hbWkY%2BERNdEIKvYjj5KN0G1kDqDjEMoh%2FEN3K%2FfXwrR4cPLnPM71Vj8ikrmiq2KvNtjpMh1R5UL2oiVFhgP9KUXygaw3fbhO0AvGNQ7pvqSp%2BIIi0XRm%2B72R5cdzMLVCGKtDJTjuwviSz2htezhXc0ORV%2Fuh%2BjgM4QO7Eg1CiGxLvYvfWqse%2FaidhxJaSbzDsPYcgdpHjO17lxrLWGh5RenLEC9VjrBl7IqKHTXA4GRkyBEpLm07t%2B%2B77Sz49sWp%2BfQfWTAec4CPOHI3GPwlCP77%2FQSGpY896V9cKHh5arOSXMQPKwo1aEbHXHJZntS4JVK%2F5HWePWXmmiQNC0a6bpFFnTDzC3d6qn2xGOTyLef4QYKzD0vGW1zkUbFRKqQwvK6u1gY6sQEVG9p%2BLmO%2BUN1WqKtLna3pRFBjUK5G7C14QhxXdXel7zKQqDjNn%2BJdXGJm%2BJlEeW81yFxEHTrCenxOg5xwgtkfyVWrox7vD5Iwihsk9pIZE%2B4DASUFbFtFaO6LYeFXGc%2FdVeSE08vucgvVZ0%2FkscFothvFfevzrAF1PErp1oliX%2FntLd3yNPLQQgr2dplIv6bPfMnMe76OvTM%2FAnMpUvteIq8pC53EKKDd2R%2BXhezcmxI%3D&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47UR5ILKSLD%2F20261011%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20261011T143044Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=186bf173656a35ec8fee5e1efb2318ba823ef3ae851bd8756e911f629a22f6cc 300w, https:\/\/blogs.glowscotland.org.uk\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2013\/02\/Slide133.png 600w\" sizes=\"(max-width: 150px) 100vw, 150px\" data-attachment-id=\"153\" data-permalink=\"https:\/\/blogs.glowscotland.org.uk\/nl\/ColtnessHS-ComputingScience\/2013\/02\/07\/spreadsheet-formula\/slide13-4\/\" data-orig-file=\"https:\/\/blogs.glowscotland.org.uk\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2013\/02\/Slide133.png\" data-orig-size=\"600,450\" data-comments-opened=\"1\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;}\" data-image-title=\"Slide13\" data-image-description=\"\" data-image-caption=\"\" data-medium-file=\"https:\/\/glow-prod-nl.s3.eu-west-1.amazonaws.com\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2013\/02\/Slide133-300x225.png?X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&amp;X-Amz-Security-Token=IQoJb3JpZ2luX2VjEKb%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJHMEUCIB8wzBylTr%2FWrXeq44%2BT7KgBfbdpi8zKp3nO8vaotSJGAiEA9KlRQzdpiE%2BeU%2BAskK71CVDiyPGfadmaES5NCePn2B0quAUIbxAFGgwyNzM1NzAxOTU0MzMiDP7A8eg7UIdy0JluWSqVBZHdF1203GJ4EtUE2fgJgXuxonaoCgF8GqRMjoiBHYww9d2CzIgY9dJDjYfuqjl6bCWND7Dd6%2BEp3cFSajTgXcdy752YdGEct2Xi5njzI2TZt9tDMA0silInxsFkWrPV1iQUQLICRNtzLsmZ%2FfT0mvaJaUquDX0ZFtWLwn%2Fvh1AWUl%2FX5Z9O7tRbp%2FKkBhY2VXTe8ZxziAum9XODiY8KREVwbbgTnWQBSMZ56bRb0dIWCAGRk7hf%2FRn7uQ%2Bi0fHBejxox8yQ5QH%2BiguyzSw9QAZpjPltkjCtnqdFJWGPhJn8v%2BqcIL1oQLQmR8DcUnbxWLbkhR8XoViEcLsbj1cMjZqbWE1Jq%2Bj44O60vTYW3hrARjTUOW%2Fw%2BL5ZCmy1WWv9OUvARK%2FYzCkHqbH%2BRdP8F6AbqrfzUS5T%2FkAdc5LAJ6mrI1o320BwKJ%2Fm1qAEjASB4ZO3FzYrzeYXKHMyMcwA%2BQyQy2Aa6rVDsayHGcTwa2zY6guinpf7hbWkY%2BERNdEIKvYjj5KN0G1kDqDjEMoh%2FEN3K%2FfXwrR4cPLnPM71Vj8ikrmiq2KvNtjpMh1R5UL2oiVFhgP9KUXygaw3fbhO0AvGNQ7pvqSp%2BIIi0XRm%2B72R5cdzMLVCGKtDJTjuwviSz2htezhXc0ORV%2Fuh%2BjgM4QO7Eg1CiGxLvYvfWqse%2FaidhxJaSbzDsPYcgdpHjO17lxrLWGh5RenLEC9VjrBl7IqKHTXA4GRkyBEpLm07t%2B%2B77Sz49sWp%2BfQfWTAec4CPOHI3GPwlCP77%2FQSGpY896V9cKHh5arOSXMQPKwo1aEbHXHJZntS4JVK%2F5HWePWXmmiQNC0a6bpFFnTDzC3d6qn2xGOTyLef4QYKzD0vGW1zkUbFRKqQwvK6u1gY6sQEVG9p%2BLmO%2BUN1WqKtLna3pRFBjUK5G7C14QhxXdXel7zKQqDjNn%2BJdXGJm%2BJlEeW81yFxEHTrCenxOg5xwgtkfyVWrox7vD5Iwihsk9pIZE%2B4DASUFbFtFaO6LYeFXGc%2FdVeSE08vucgvVZ0%2FkscFothvFfevzrAF1PErp1oliX%2FntLd3yNPLQQgr2dplIv6bPfMnMe76OvTM%2FAnMpUvteIq8pC53EKKDd2R%2BXhezcmxI%3D&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47UR5ILKSLD%2F20261011%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20261011T143044Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=186bf173656a35ec8fee5e1efb2318ba823ef3ae851bd8756e911f629a22f6cc\" data-large-file=\"https:\/\/blogs.glowscotland.org.uk\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2013\/02\/Slide133.png\" \/><\/a>\n\t\t\t<\/div><\/figure><figure class='gallery-item'>\n\t\t\t<div class='gallery-icon landscape'>\n\t\t\t\t<a href='https:\/\/blogs.glowscotland.org.uk\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2013\/02\/Slide143.png'><img decoding=\"async\" width=\"150\" height=\"112\" src=\"https:\/\/glow-prod-nl.s3.eu-west-1.amazonaws.com\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2013\/02\/Slide143-150x112.png?X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&amp;X-Amz-Security-Token=IQoJb3JpZ2luX2VjEKb%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJHMEUCIB8wzBylTr%2FWrXeq44%2BT7KgBfbdpi8zKp3nO8vaotSJGAiEA9KlRQzdpiE%2BeU%2BAskK71CVDiyPGfadmaES5NCePn2B0quAUIbxAFGgwyNzM1NzAxOTU0MzMiDP7A8eg7UIdy0JluWSqVBZHdF1203GJ4EtUE2fgJgXuxonaoCgF8GqRMjoiBHYww9d2CzIgY9dJDjYfuqjl6bCWND7Dd6%2BEp3cFSajTgXcdy752YdGEct2Xi5njzI2TZt9tDMA0silInxsFkWrPV1iQUQLICRNtzLsmZ%2FfT0mvaJaUquDX0ZFtWLwn%2Fvh1AWUl%2FX5Z9O7tRbp%2FKkBhY2VXTe8ZxziAum9XODiY8KREVwbbgTnWQBSMZ56bRb0dIWCAGRk7hf%2FRn7uQ%2Bi0fHBejxox8yQ5QH%2BiguyzSw9QAZpjPltkjCtnqdFJWGPhJn8v%2BqcIL1oQLQmR8DcUnbxWLbkhR8XoViEcLsbj1cMjZqbWE1Jq%2Bj44O60vTYW3hrARjTUOW%2Fw%2BL5ZCmy1WWv9OUvARK%2FYzCkHqbH%2BRdP8F6AbqrfzUS5T%2FkAdc5LAJ6mrI1o320BwKJ%2Fm1qAEjASB4ZO3FzYrzeYXKHMyMcwA%2BQyQy2Aa6rVDsayHGcTwa2zY6guinpf7hbWkY%2BERNdEIKvYjj5KN0G1kDqDjEMoh%2FEN3K%2FfXwrR4cPLnPM71Vj8ikrmiq2KvNtjpMh1R5UL2oiVFhgP9KUXygaw3fbhO0AvGNQ7pvqSp%2BIIi0XRm%2B72R5cdzMLVCGKtDJTjuwviSz2htezhXc0ORV%2Fuh%2BjgM4QO7Eg1CiGxLvYvfWqse%2FaidhxJaSbzDsPYcgdpHjO17lxrLWGh5RenLEC9VjrBl7IqKHTXA4GRkyBEpLm07t%2B%2B77Sz49sWp%2BfQfWTAec4CPOHI3GPwlCP77%2FQSGpY896V9cKHh5arOSXMQPKwo1aEbHXHJZntS4JVK%2F5HWePWXmmiQNC0a6bpFFnTDzC3d6qn2xGOTyLef4QYKzD0vGW1zkUbFRKqQwvK6u1gY6sQEVG9p%2BLmO%2BUN1WqKtLna3pRFBjUK5G7C14QhxXdXel7zKQqDjNn%2BJdXGJm%2BJlEeW81yFxEHTrCenxOg5xwgtkfyVWrox7vD5Iwihsk9pIZE%2B4DASUFbFtFaO6LYeFXGc%2FdVeSE08vucgvVZ0%2FkscFothvFfevzrAF1PErp1oliX%2FntLd3yNPLQQgr2dplIv6bPfMnMe76OvTM%2FAnMpUvteIq8pC53EKKDd2R%2BXhezcmxI%3D&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47UR5ILKSLD%2F20261011%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20261011T143044Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=764bff983be011a346a769101dca791300b4463230acf1839926a8756209ae31\" class=\"attachment-thumbnail size-thumbnail\" alt=\"\" srcset=\"https:\/\/glow-prod-nl.s3.eu-west-1.amazonaws.com\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2013\/02\/Slide143-150x112.png?X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&amp;X-Amz-Security-Token=IQoJb3JpZ2luX2VjEKb%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJHMEUCIB8wzBylTr%2FWrXeq44%2BT7KgBfbdpi8zKp3nO8vaotSJGAiEA9KlRQzdpiE%2BeU%2BAskK71CVDiyPGfadmaES5NCePn2B0quAUIbxAFGgwyNzM1NzAxOTU0MzMiDP7A8eg7UIdy0JluWSqVBZHdF1203GJ4EtUE2fgJgXuxonaoCgF8GqRMjoiBHYww9d2CzIgY9dJDjYfuqjl6bCWND7Dd6%2BEp3cFSajTgXcdy752YdGEct2Xi5njzI2TZt9tDMA0silInxsFkWrPV1iQUQLICRNtzLsmZ%2FfT0mvaJaUquDX0ZFtWLwn%2Fvh1AWUl%2FX5Z9O7tRbp%2FKkBhY2VXTe8ZxziAum9XODiY8KREVwbbgTnWQBSMZ56bRb0dIWCAGRk7hf%2FRn7uQ%2Bi0fHBejxox8yQ5QH%2BiguyzSw9QAZpjPltkjCtnqdFJWGPhJn8v%2BqcIL1oQLQmR8DcUnbxWLbkhR8XoViEcLsbj1cMjZqbWE1Jq%2Bj44O60vTYW3hrARjTUOW%2Fw%2BL5ZCmy1WWv9OUvARK%2FYzCkHqbH%2BRdP8F6AbqrfzUS5T%2FkAdc5LAJ6mrI1o320BwKJ%2Fm1qAEjASB4ZO3FzYrzeYXKHMyMcwA%2BQyQy2Aa6rVDsayHGcTwa2zY6guinpf7hbWkY%2BERNdEIKvYjj5KN0G1kDqDjEMoh%2FEN3K%2FfXwrR4cPLnPM71Vj8ikrmiq2KvNtjpMh1R5UL2oiVFhgP9KUXygaw3fbhO0AvGNQ7pvqSp%2BIIi0XRm%2B72R5cdzMLVCGKtDJTjuwviSz2htezhXc0ORV%2Fuh%2BjgM4QO7Eg1CiGxLvYvfWqse%2FaidhxJaSbzDsPYcgdpHjO17lxrLWGh5RenLEC9VjrBl7IqKHTXA4GRkyBEpLm07t%2B%2B77Sz49sWp%2BfQfWTAec4CPOHI3GPwlCP77%2FQSGpY896V9cKHh5arOSXMQPKwo1aEbHXHJZntS4JVK%2F5HWePWXmmiQNC0a6bpFFnTDzC3d6qn2xGOTyLef4QYKzD0vGW1zkUbFRKqQwvK6u1gY6sQEVG9p%2BLmO%2BUN1WqKtLna3pRFBjUK5G7C14QhxXdXel7zKQqDjNn%2BJdXGJm%2BJlEeW81yFxEHTrCenxOg5xwgtkfyVWrox7vD5Iwihsk9pIZE%2B4DASUFbFtFaO6LYeFXGc%2FdVeSE08vucgvVZ0%2FkscFothvFfevzrAF1PErp1oliX%2FntLd3yNPLQQgr2dplIv6bPfMnMe76OvTM%2FAnMpUvteIq8pC53EKKDd2R%2BXhezcmxI%3D&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47UR5ILKSLD%2F20261011%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20261011T143044Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=764bff983be011a346a769101dca791300b4463230acf1839926a8756209ae31 150w, https:\/\/glow-prod-nl.s3.eu-west-1.amazonaws.com\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2013\/02\/Slide143-300x225.png?X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&amp;X-Amz-Security-Token=IQoJb3JpZ2luX2VjEKb%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJHMEUCIB8wzBylTr%2FWrXeq44%2BT7KgBfbdpi8zKp3nO8vaotSJGAiEA9KlRQzdpiE%2BeU%2BAskK71CVDiyPGfadmaES5NCePn2B0quAUIbxAFGgwyNzM1NzAxOTU0MzMiDP7A8eg7UIdy0JluWSqVBZHdF1203GJ4EtUE2fgJgXuxonaoCgF8GqRMjoiBHYww9d2CzIgY9dJDjYfuqjl6bCWND7Dd6%2BEp3cFSajTgXcdy752YdGEct2Xi5njzI2TZt9tDMA0silInxsFkWrPV1iQUQLICRNtzLsmZ%2FfT0mvaJaUquDX0ZFtWLwn%2Fvh1AWUl%2FX5Z9O7tRbp%2FKkBhY2VXTe8ZxziAum9XODiY8KREVwbbgTnWQBSMZ56bRb0dIWCAGRk7hf%2FRn7uQ%2Bi0fHBejxox8yQ5QH%2BiguyzSw9QAZpjPltkjCtnqdFJWGPhJn8v%2BqcIL1oQLQmR8DcUnbxWLbkhR8XoViEcLsbj1cMjZqbWE1Jq%2Bj44O60vTYW3hrARjTUOW%2Fw%2BL5ZCmy1WWv9OUvARK%2FYzCkHqbH%2BRdP8F6AbqrfzUS5T%2FkAdc5LAJ6mrI1o320BwKJ%2Fm1qAEjASB4ZO3FzYrzeYXKHMyMcwA%2BQyQy2Aa6rVDsayHGcTwa2zY6guinpf7hbWkY%2BERNdEIKvYjj5KN0G1kDqDjEMoh%2FEN3K%2FfXwrR4cPLnPM71Vj8ikrmiq2KvNtjpMh1R5UL2oiVFhgP9KUXygaw3fbhO0AvGNQ7pvqSp%2BIIi0XRm%2B72R5cdzMLVCGKtDJTjuwviSz2htezhXc0ORV%2Fuh%2BjgM4QO7Eg1CiGxLvYvfWqse%2FaidhxJaSbzDsPYcgdpHjO17lxrLWGh5RenLEC9VjrBl7IqKHTXA4GRkyBEpLm07t%2B%2B77Sz49sWp%2BfQfWTAec4CPOHI3GPwlCP77%2FQSGpY896V9cKHh5arOSXMQPKwo1aEbHXHJZntS4JVK%2F5HWePWXmmiQNC0a6bpFFnTDzC3d6qn2xGOTyLef4QYKzD0vGW1zkUbFRKqQwvK6u1gY6sQEVG9p%2BLmO%2BUN1WqKtLna3pRFBjUK5G7C14QhxXdXel7zKQqDjNn%2BJdXGJm%2BJlEeW81yFxEHTrCenxOg5xwgtkfyVWrox7vD5Iwihsk9pIZE%2B4DASUFbFtFaO6LYeFXGc%2FdVeSE08vucgvVZ0%2FkscFothvFfevzrAF1PErp1oliX%2FntLd3yNPLQQgr2dplIv6bPfMnMe76OvTM%2FAnMpUvteIq8pC53EKKDd2R%2BXhezcmxI%3D&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47UR5ILKSLD%2F20261011%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20261011T143044Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=c20dc3288916443647848cb620fa7f6b08b679c536cedacd5d75e5252f9a23ae 300w, https:\/\/blogs.glowscotland.org.uk\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2013\/02\/Slide143.png 600w\" sizes=\"(max-width: 150px) 100vw, 150px\" data-attachment-id=\"154\" data-permalink=\"https:\/\/blogs.glowscotland.org.uk\/nl\/ColtnessHS-ComputingScience\/2013\/02\/07\/spreadsheet-formula\/slide14-4\/\" data-orig-file=\"https:\/\/blogs.glowscotland.org.uk\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2013\/02\/Slide143.png\" data-orig-size=\"600,450\" data-comments-opened=\"1\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;}\" data-image-title=\"Slide14\" data-image-description=\"\" data-image-caption=\"\" data-medium-file=\"https:\/\/glow-prod-nl.s3.eu-west-1.amazonaws.com\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2013\/02\/Slide143-300x225.png?X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&amp;X-Amz-Security-Token=IQoJb3JpZ2luX2VjEKb%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJHMEUCIB8wzBylTr%2FWrXeq44%2BT7KgBfbdpi8zKp3nO8vaotSJGAiEA9KlRQzdpiE%2BeU%2BAskK71CVDiyPGfadmaES5NCePn2B0quAUIbxAFGgwyNzM1NzAxOTU0MzMiDP7A8eg7UIdy0JluWSqVBZHdF1203GJ4EtUE2fgJgXuxonaoCgF8GqRMjoiBHYww9d2CzIgY9dJDjYfuqjl6bCWND7Dd6%2BEp3cFSajTgXcdy752YdGEct2Xi5njzI2TZt9tDMA0silInxsFkWrPV1iQUQLICRNtzLsmZ%2FfT0mvaJaUquDX0ZFtWLwn%2Fvh1AWUl%2FX5Z9O7tRbp%2FKkBhY2VXTe8ZxziAum9XODiY8KREVwbbgTnWQBSMZ56bRb0dIWCAGRk7hf%2FRn7uQ%2Bi0fHBejxox8yQ5QH%2BiguyzSw9QAZpjPltkjCtnqdFJWGPhJn8v%2BqcIL1oQLQmR8DcUnbxWLbkhR8XoViEcLsbj1cMjZqbWE1Jq%2Bj44O60vTYW3hrARjTUOW%2Fw%2BL5ZCmy1WWv9OUvARK%2FYzCkHqbH%2BRdP8F6AbqrfzUS5T%2FkAdc5LAJ6mrI1o320BwKJ%2Fm1qAEjASB4ZO3FzYrzeYXKHMyMcwA%2BQyQy2Aa6rVDsayHGcTwa2zY6guinpf7hbWkY%2BERNdEIKvYjj5KN0G1kDqDjEMoh%2FEN3K%2FfXwrR4cPLnPM71Vj8ikrmiq2KvNtjpMh1R5UL2oiVFhgP9KUXygaw3fbhO0AvGNQ7pvqSp%2BIIi0XRm%2B72R5cdzMLVCGKtDJTjuwviSz2htezhXc0ORV%2Fuh%2BjgM4QO7Eg1CiGxLvYvfWqse%2FaidhxJaSbzDsPYcgdpHjO17lxrLWGh5RenLEC9VjrBl7IqKHTXA4GRkyBEpLm07t%2B%2B77Sz49sWp%2BfQfWTAec4CPOHI3GPwlCP77%2FQSGpY896V9cKHh5arOSXMQPKwo1aEbHXHJZntS4JVK%2F5HWePWXmmiQNC0a6bpFFnTDzC3d6qn2xGOTyLef4QYKzD0vGW1zkUbFRKqQwvK6u1gY6sQEVG9p%2BLmO%2BUN1WqKtLna3pRFBjUK5G7C14QhxXdXel7zKQqDjNn%2BJdXGJm%2BJlEeW81yFxEHTrCenxOg5xwgtkfyVWrox7vD5Iwihsk9pIZE%2B4DASUFbFtFaO6LYeFXGc%2FdVeSE08vucgvVZ0%2FkscFothvFfevzrAF1PErp1oliX%2FntLd3yNPLQQgr2dplIv6bPfMnMe76OvTM%2FAnMpUvteIq8pC53EKKDd2R%2BXhezcmxI%3D&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47UR5ILKSLD%2F20261011%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20261011T143044Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=c20dc3288916443647848cb620fa7f6b08b679c536cedacd5d75e5252f9a23ae\" data-large-file=\"https:\/\/blogs.glowscotland.org.uk\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2013\/02\/Slide143.png\" \/><\/a>\n\t\t\t<\/div><\/figure><figure class='gallery-item'>\n\t\t\t<div class='gallery-icon landscape'>\n\t\t\t\t<a href='https:\/\/blogs.glowscotland.org.uk\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2013\/02\/Slide153.png'><img decoding=\"async\" width=\"150\" height=\"112\" src=\"https:\/\/glow-prod-nl.s3.eu-west-1.amazonaws.com\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2013\/02\/Slide153-150x112.png?X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&amp;X-Amz-Security-Token=IQoJb3JpZ2luX2VjEKb%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJHMEUCIB8wzBylTr%2FWrXeq44%2BT7KgBfbdpi8zKp3nO8vaotSJGAiEA9KlRQzdpiE%2BeU%2BAskK71CVDiyPGfadmaES5NCePn2B0quAUIbxAFGgwyNzM1NzAxOTU0MzMiDP7A8eg7UIdy0JluWSqVBZHdF1203GJ4EtUE2fgJgXuxonaoCgF8GqRMjoiBHYww9d2CzIgY9dJDjYfuqjl6bCWND7Dd6%2BEp3cFSajTgXcdy752YdGEct2Xi5njzI2TZt9tDMA0silInxsFkWrPV1iQUQLICRNtzLsmZ%2FfT0mvaJaUquDX0ZFtWLwn%2Fvh1AWUl%2FX5Z9O7tRbp%2FKkBhY2VXTe8ZxziAum9XODiY8KREVwbbgTnWQBSMZ56bRb0dIWCAGRk7hf%2FRn7uQ%2Bi0fHBejxox8yQ5QH%2BiguyzSw9QAZpjPltkjCtnqdFJWGPhJn8v%2BqcIL1oQLQmR8DcUnbxWLbkhR8XoViEcLsbj1cMjZqbWE1Jq%2Bj44O60vTYW3hrARjTUOW%2Fw%2BL5ZCmy1WWv9OUvARK%2FYzCkHqbH%2BRdP8F6AbqrfzUS5T%2FkAdc5LAJ6mrI1o320BwKJ%2Fm1qAEjASB4ZO3FzYrzeYXKHMyMcwA%2BQyQy2Aa6rVDsayHGcTwa2zY6guinpf7hbWkY%2BERNdEIKvYjj5KN0G1kDqDjEMoh%2FEN3K%2FfXwrR4cPLnPM71Vj8ikrmiq2KvNtjpMh1R5UL2oiVFhgP9KUXygaw3fbhO0AvGNQ7pvqSp%2BIIi0XRm%2B72R5cdzMLVCGKtDJTjuwviSz2htezhXc0ORV%2Fuh%2BjgM4QO7Eg1CiGxLvYvfWqse%2FaidhxJaSbzDsPYcgdpHjO17lxrLWGh5RenLEC9VjrBl7IqKHTXA4GRkyBEpLm07t%2B%2B77Sz49sWp%2BfQfWTAec4CPOHI3GPwlCP77%2FQSGpY896V9cKHh5arOSXMQPKwo1aEbHXHJZntS4JVK%2F5HWePWXmmiQNC0a6bpFFnTDzC3d6qn2xGOTyLef4QYKzD0vGW1zkUbFRKqQwvK6u1gY6sQEVG9p%2BLmO%2BUN1WqKtLna3pRFBjUK5G7C14QhxXdXel7zKQqDjNn%2BJdXGJm%2BJlEeW81yFxEHTrCenxOg5xwgtkfyVWrox7vD5Iwihsk9pIZE%2B4DASUFbFtFaO6LYeFXGc%2FdVeSE08vucgvVZ0%2FkscFothvFfevzrAF1PErp1oliX%2FntLd3yNPLQQgr2dplIv6bPfMnMe76OvTM%2FAnMpUvteIq8pC53EKKDd2R%2BXhezcmxI%3D&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47UR5ILKSLD%2F20261011%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20261011T143044Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=0710d778dd4cf20eb54fd046a734d6b7d3888c3a887c6e48fcf4561d633bc68c\" class=\"attachment-thumbnail size-thumbnail\" alt=\"\" srcset=\"https:\/\/glow-prod-nl.s3.eu-west-1.amazonaws.com\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2013\/02\/Slide153-150x112.png?X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&amp;X-Amz-Security-Token=IQoJb3JpZ2luX2VjEKb%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJHMEUCIB8wzBylTr%2FWrXeq44%2BT7KgBfbdpi8zKp3nO8vaotSJGAiEA9KlRQzdpiE%2BeU%2BAskK71CVDiyPGfadmaES5NCePn2B0quAUIbxAFGgwyNzM1NzAxOTU0MzMiDP7A8eg7UIdy0JluWSqVBZHdF1203GJ4EtUE2fgJgXuxonaoCgF8GqRMjoiBHYww9d2CzIgY9dJDjYfuqjl6bCWND7Dd6%2BEp3cFSajTgXcdy752YdGEct2Xi5njzI2TZt9tDMA0silInxsFkWrPV1iQUQLICRNtzLsmZ%2FfT0mvaJaUquDX0ZFtWLwn%2Fvh1AWUl%2FX5Z9O7tRbp%2FKkBhY2VXTe8ZxziAum9XODiY8KREVwbbgTnWQBSMZ56bRb0dIWCAGRk7hf%2FRn7uQ%2Bi0fHBejxox8yQ5QH%2BiguyzSw9QAZpjPltkjCtnqdFJWGPhJn8v%2BqcIL1oQLQmR8DcUnbxWLbkhR8XoViEcLsbj1cMjZqbWE1Jq%2Bj44O60vTYW3hrARjTUOW%2Fw%2BL5ZCmy1WWv9OUvARK%2FYzCkHqbH%2BRdP8F6AbqrfzUS5T%2FkAdc5LAJ6mrI1o320BwKJ%2Fm1qAEjASB4ZO3FzYrzeYXKHMyMcwA%2BQyQy2Aa6rVDsayHGcTwa2zY6guinpf7hbWkY%2BERNdEIKvYjj5KN0G1kDqDjEMoh%2FEN3K%2FfXwrR4cPLnPM71Vj8ikrmiq2KvNtjpMh1R5UL2oiVFhgP9KUXygaw3fbhO0AvGNQ7pvqSp%2BIIi0XRm%2B72R5cdzMLVCGKtDJTjuwviSz2htezhXc0ORV%2Fuh%2BjgM4QO7Eg1CiGxLvYvfWqse%2FaidhxJaSbzDsPYcgdpHjO17lxrLWGh5RenLEC9VjrBl7IqKHTXA4GRkyBEpLm07t%2B%2B77Sz49sWp%2BfQfWTAec4CPOHI3GPwlCP77%2FQSGpY896V9cKHh5arOSXMQPKwo1aEbHXHJZntS4JVK%2F5HWePWXmmiQNC0a6bpFFnTDzC3d6qn2xGOTyLef4QYKzD0vGW1zkUbFRKqQwvK6u1gY6sQEVG9p%2BLmO%2BUN1WqKtLna3pRFBjUK5G7C14QhxXdXel7zKQqDjNn%2BJdXGJm%2BJlEeW81yFxEHTrCenxOg5xwgtkfyVWrox7vD5Iwihsk9pIZE%2B4DASUFbFtFaO6LYeFXGc%2FdVeSE08vucgvVZ0%2FkscFothvFfevzrAF1PErp1oliX%2FntLd3yNPLQQgr2dplIv6bPfMnMe76OvTM%2FAnMpUvteIq8pC53EKKDd2R%2BXhezcmxI%3D&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47UR5ILKSLD%2F20261011%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20261011T143044Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=0710d778dd4cf20eb54fd046a734d6b7d3888c3a887c6e48fcf4561d633bc68c 150w, https:\/\/glow-prod-nl.s3.eu-west-1.amazonaws.com\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2013\/02\/Slide153-300x225.png?X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&amp;X-Amz-Security-Token=IQoJb3JpZ2luX2VjEKb%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJHMEUCIB8wzBylTr%2FWrXeq44%2BT7KgBfbdpi8zKp3nO8vaotSJGAiEA9KlRQzdpiE%2BeU%2BAskK71CVDiyPGfadmaES5NCePn2B0quAUIbxAFGgwyNzM1NzAxOTU0MzMiDP7A8eg7UIdy0JluWSqVBZHdF1203GJ4EtUE2fgJgXuxonaoCgF8GqRMjoiBHYww9d2CzIgY9dJDjYfuqjl6bCWND7Dd6%2BEp3cFSajTgXcdy752YdGEct2Xi5njzI2TZt9tDMA0silInxsFkWrPV1iQUQLICRNtzLsmZ%2FfT0mvaJaUquDX0ZFtWLwn%2Fvh1AWUl%2FX5Z9O7tRbp%2FKkBhY2VXTe8ZxziAum9XODiY8KREVwbbgTnWQBSMZ56bRb0dIWCAGRk7hf%2FRn7uQ%2Bi0fHBejxox8yQ5QH%2BiguyzSw9QAZpjPltkjCtnqdFJWGPhJn8v%2BqcIL1oQLQmR8DcUnbxWLbkhR8XoViEcLsbj1cMjZqbWE1Jq%2Bj44O60vTYW3hrARjTUOW%2Fw%2BL5ZCmy1WWv9OUvARK%2FYzCkHqbH%2BRdP8F6AbqrfzUS5T%2FkAdc5LAJ6mrI1o320BwKJ%2Fm1qAEjASB4ZO3FzYrzeYXKHMyMcwA%2BQyQy2Aa6rVDsayHGcTwa2zY6guinpf7hbWkY%2BERNdEIKvYjj5KN0G1kDqDjEMoh%2FEN3K%2FfXwrR4cPLnPM71Vj8ikrmiq2KvNtjpMh1R5UL2oiVFhgP9KUXygaw3fbhO0AvGNQ7pvqSp%2BIIi0XRm%2B72R5cdzMLVCGKtDJTjuwviSz2htezhXc0ORV%2Fuh%2BjgM4QO7Eg1CiGxLvYvfWqse%2FaidhxJaSbzDsPYcgdpHjO17lxrLWGh5RenLEC9VjrBl7IqKHTXA4GRkyBEpLm07t%2B%2B77Sz49sWp%2BfQfWTAec4CPOHI3GPwlCP77%2FQSGpY896V9cKHh5arOSXMQPKwo1aEbHXHJZntS4JVK%2F5HWePWXmmiQNC0a6bpFFnTDzC3d6qn2xGOTyLef4QYKzD0vGW1zkUbFRKqQwvK6u1gY6sQEVG9p%2BLmO%2BUN1WqKtLna3pRFBjUK5G7C14QhxXdXel7zKQqDjNn%2BJdXGJm%2BJlEeW81yFxEHTrCenxOg5xwgtkfyVWrox7vD5Iwihsk9pIZE%2B4DASUFbFtFaO6LYeFXGc%2FdVeSE08vucgvVZ0%2FkscFothvFfevzrAF1PErp1oliX%2FntLd3yNPLQQgr2dplIv6bPfMnMe76OvTM%2FAnMpUvteIq8pC53EKKDd2R%2BXhezcmxI%3D&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47UR5ILKSLD%2F20261011%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20261011T143044Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=120d4a29cb681905721b9d84a4bd03ec218dfeec64a103bb3b0b030d1a2097e1 300w, https:\/\/blogs.glowscotland.org.uk\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2013\/02\/Slide153.png 600w\" sizes=\"(max-width: 150px) 100vw, 150px\" data-attachment-id=\"155\" data-permalink=\"https:\/\/blogs.glowscotland.org.uk\/nl\/ColtnessHS-ComputingScience\/2013\/02\/07\/spreadsheet-formula\/slide15-4\/\" data-orig-file=\"https:\/\/blogs.glowscotland.org.uk\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2013\/02\/Slide153.png\" data-orig-size=\"600,450\" data-comments-opened=\"1\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;}\" data-image-title=\"Slide15\" data-image-description=\"\" data-image-caption=\"\" data-medium-file=\"https:\/\/glow-prod-nl.s3.eu-west-1.amazonaws.com\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2013\/02\/Slide153-300x225.png?X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&amp;X-Amz-Security-Token=IQoJb3JpZ2luX2VjEKb%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJHMEUCIB8wzBylTr%2FWrXeq44%2BT7KgBfbdpi8zKp3nO8vaotSJGAiEA9KlRQzdpiE%2BeU%2BAskK71CVDiyPGfadmaES5NCePn2B0quAUIbxAFGgwyNzM1NzAxOTU0MzMiDP7A8eg7UIdy0JluWSqVBZHdF1203GJ4EtUE2fgJgXuxonaoCgF8GqRMjoiBHYww9d2CzIgY9dJDjYfuqjl6bCWND7Dd6%2BEp3cFSajTgXcdy752YdGEct2Xi5njzI2TZt9tDMA0silInxsFkWrPV1iQUQLICRNtzLsmZ%2FfT0mvaJaUquDX0ZFtWLwn%2Fvh1AWUl%2FX5Z9O7tRbp%2FKkBhY2VXTe8ZxziAum9XODiY8KREVwbbgTnWQBSMZ56bRb0dIWCAGRk7hf%2FRn7uQ%2Bi0fHBejxox8yQ5QH%2BiguyzSw9QAZpjPltkjCtnqdFJWGPhJn8v%2BqcIL1oQLQmR8DcUnbxWLbkhR8XoViEcLsbj1cMjZqbWE1Jq%2Bj44O60vTYW3hrARjTUOW%2Fw%2BL5ZCmy1WWv9OUvARK%2FYzCkHqbH%2BRdP8F6AbqrfzUS5T%2FkAdc5LAJ6mrI1o320BwKJ%2Fm1qAEjASB4ZO3FzYrzeYXKHMyMcwA%2BQyQy2Aa6rVDsayHGcTwa2zY6guinpf7hbWkY%2BERNdEIKvYjj5KN0G1kDqDjEMoh%2FEN3K%2FfXwrR4cPLnPM71Vj8ikrmiq2KvNtjpMh1R5UL2oiVFhgP9KUXygaw3fbhO0AvGNQ7pvqSp%2BIIi0XRm%2B72R5cdzMLVCGKtDJTjuwviSz2htezhXc0ORV%2Fuh%2BjgM4QO7Eg1CiGxLvYvfWqse%2FaidhxJaSbzDsPYcgdpHjO17lxrLWGh5RenLEC9VjrBl7IqKHTXA4GRkyBEpLm07t%2B%2B77Sz49sWp%2BfQfWTAec4CPOHI3GPwlCP77%2FQSGpY896V9cKHh5arOSXMQPKwo1aEbHXHJZntS4JVK%2F5HWePWXmmiQNC0a6bpFFnTDzC3d6qn2xGOTyLef4QYKzD0vGW1zkUbFRKqQwvK6u1gY6sQEVG9p%2BLmO%2BUN1WqKtLna3pRFBjUK5G7C14QhxXdXel7zKQqDjNn%2BJdXGJm%2BJlEeW81yFxEHTrCenxOg5xwgtkfyVWrox7vD5Iwihsk9pIZE%2B4DASUFbFtFaO6LYeFXGc%2FdVeSE08vucgvVZ0%2FkscFothvFfevzrAF1PErp1oliX%2FntLd3yNPLQQgr2dplIv6bPfMnMe76OvTM%2FAnMpUvteIq8pC53EKKDd2R%2BXhezcmxI%3D&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47UR5ILKSLD%2F20261011%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20261011T143044Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=120d4a29cb681905721b9d84a4bd03ec218dfeec64a103bb3b0b030d1a2097e1\" data-large-file=\"https:\/\/blogs.glowscotland.org.uk\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2013\/02\/Slide153.png\" \/><\/a>\n\t\t\t<\/div><\/figure><figure class='gallery-item'>\n\t\t\t<div class='gallery-icon landscape'>\n\t\t\t\t<a href='https:\/\/blogs.glowscotland.org.uk\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2013\/02\/Slide163.png'><img decoding=\"async\" width=\"150\" height=\"112\" src=\"https:\/\/glow-prod-nl.s3.eu-west-1.amazonaws.com\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2013\/02\/Slide163-150x112.png?X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&amp;X-Amz-Security-Token=IQoJb3JpZ2luX2VjEKb%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJHMEUCIB8wzBylTr%2FWrXeq44%2BT7KgBfbdpi8zKp3nO8vaotSJGAiEA9KlRQzdpiE%2BeU%2BAskK71CVDiyPGfadmaES5NCePn2B0quAUIbxAFGgwyNzM1NzAxOTU0MzMiDP7A8eg7UIdy0JluWSqVBZHdF1203GJ4EtUE2fgJgXuxonaoCgF8GqRMjoiBHYww9d2CzIgY9dJDjYfuqjl6bCWND7Dd6%2BEp3cFSajTgXcdy752YdGEct2Xi5njzI2TZt9tDMA0silInxsFkWrPV1iQUQLICRNtzLsmZ%2FfT0mvaJaUquDX0ZFtWLwn%2Fvh1AWUl%2FX5Z9O7tRbp%2FKkBhY2VXTe8ZxziAum9XODiY8KREVwbbgTnWQBSMZ56bRb0dIWCAGRk7hf%2FRn7uQ%2Bi0fHBejxox8yQ5QH%2BiguyzSw9QAZpjPltkjCtnqdFJWGPhJn8v%2BqcIL1oQLQmR8DcUnbxWLbkhR8XoViEcLsbj1cMjZqbWE1Jq%2Bj44O60vTYW3hrARjTUOW%2Fw%2BL5ZCmy1WWv9OUvARK%2FYzCkHqbH%2BRdP8F6AbqrfzUS5T%2FkAdc5LAJ6mrI1o320BwKJ%2Fm1qAEjASB4ZO3FzYrzeYXKHMyMcwA%2BQyQy2Aa6rVDsayHGcTwa2zY6guinpf7hbWkY%2BERNdEIKvYjj5KN0G1kDqDjEMoh%2FEN3K%2FfXwrR4cPLnPM71Vj8ikrmiq2KvNtjpMh1R5UL2oiVFhgP9KUXygaw3fbhO0AvGNQ7pvqSp%2BIIi0XRm%2B72R5cdzMLVCGKtDJTjuwviSz2htezhXc0ORV%2Fuh%2BjgM4QO7Eg1CiGxLvYvfWqse%2FaidhxJaSbzDsPYcgdpHjO17lxrLWGh5RenLEC9VjrBl7IqKHTXA4GRkyBEpLm07t%2B%2B77Sz49sWp%2BfQfWTAec4CPOHI3GPwlCP77%2FQSGpY896V9cKHh5arOSXMQPKwo1aEbHXHJZntS4JVK%2F5HWePWXmmiQNC0a6bpFFnTDzC3d6qn2xGOTyLef4QYKzD0vGW1zkUbFRKqQwvK6u1gY6sQEVG9p%2BLmO%2BUN1WqKtLna3pRFBjUK5G7C14QhxXdXel7zKQqDjNn%2BJdXGJm%2BJlEeW81yFxEHTrCenxOg5xwgtkfyVWrox7vD5Iwihsk9pIZE%2B4DASUFbFtFaO6LYeFXGc%2FdVeSE08vucgvVZ0%2FkscFothvFfevzrAF1PErp1oliX%2FntLd3yNPLQQgr2dplIv6bPfMnMe76OvTM%2FAnMpUvteIq8pC53EKKDd2R%2BXhezcmxI%3D&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47UR5ILKSLD%2F20261011%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20261011T143044Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=1bdb7fcf3214c4c0906aa2d50da9b776bdb3e96f903607cd6b0f119ef9fc2dde\" class=\"attachment-thumbnail size-thumbnail\" alt=\"\" srcset=\"https:\/\/glow-prod-nl.s3.eu-west-1.amazonaws.com\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2013\/02\/Slide163-150x112.png?X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&amp;X-Amz-Security-Token=IQoJb3JpZ2luX2VjEKb%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJHMEUCIB8wzBylTr%2FWrXeq44%2BT7KgBfbdpi8zKp3nO8vaotSJGAiEA9KlRQzdpiE%2BeU%2BAskK71CVDiyPGfadmaES5NCePn2B0quAUIbxAFGgwyNzM1NzAxOTU0MzMiDP7A8eg7UIdy0JluWSqVBZHdF1203GJ4EtUE2fgJgXuxonaoCgF8GqRMjoiBHYww9d2CzIgY9dJDjYfuqjl6bCWND7Dd6%2BEp3cFSajTgXcdy752YdGEct2Xi5njzI2TZt9tDMA0silInxsFkWrPV1iQUQLICRNtzLsmZ%2FfT0mvaJaUquDX0ZFtWLwn%2Fvh1AWUl%2FX5Z9O7tRbp%2FKkBhY2VXTe8ZxziAum9XODiY8KREVwbbgTnWQBSMZ56bRb0dIWCAGRk7hf%2FRn7uQ%2Bi0fHBejxox8yQ5QH%2BiguyzSw9QAZpjPltkjCtnqdFJWGPhJn8v%2BqcIL1oQLQmR8DcUnbxWLbkhR8XoViEcLsbj1cMjZqbWE1Jq%2Bj44O60vTYW3hrARjTUOW%2Fw%2BL5ZCmy1WWv9OUvARK%2FYzCkHqbH%2BRdP8F6AbqrfzUS5T%2FkAdc5LAJ6mrI1o320BwKJ%2Fm1qAEjASB4ZO3FzYrzeYXKHMyMcwA%2BQyQy2Aa6rVDsayHGcTwa2zY6guinpf7hbWkY%2BERNdEIKvYjj5KN0G1kDqDjEMoh%2FEN3K%2FfXwrR4cPLnPM71Vj8ikrmiq2KvNtjpMh1R5UL2oiVFhgP9KUXygaw3fbhO0AvGNQ7pvqSp%2BIIi0XRm%2B72R5cdzMLVCGKtDJTjuwviSz2htezhXc0ORV%2Fuh%2BjgM4QO7Eg1CiGxLvYvfWqse%2FaidhxJaSbzDsPYcgdpHjO17lxrLWGh5RenLEC9VjrBl7IqKHTXA4GRkyBEpLm07t%2B%2B77Sz49sWp%2BfQfWTAec4CPOHI3GPwlCP77%2FQSGpY896V9cKHh5arOSXMQPKwo1aEbHXHJZntS4JVK%2F5HWePWXmmiQNC0a6bpFFnTDzC3d6qn2xGOTyLef4QYKzD0vGW1zkUbFRKqQwvK6u1gY6sQEVG9p%2BLmO%2BUN1WqKtLna3pRFBjUK5G7C14QhxXdXel7zKQqDjNn%2BJdXGJm%2BJlEeW81yFxEHTrCenxOg5xwgtkfyVWrox7vD5Iwihsk9pIZE%2B4DASUFbFtFaO6LYeFXGc%2FdVeSE08vucgvVZ0%2FkscFothvFfevzrAF1PErp1oliX%2FntLd3yNPLQQgr2dplIv6bPfMnMe76OvTM%2FAnMpUvteIq8pC53EKKDd2R%2BXhezcmxI%3D&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47UR5ILKSLD%2F20261011%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20261011T143044Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=1bdb7fcf3214c4c0906aa2d50da9b776bdb3e96f903607cd6b0f119ef9fc2dde 150w, https:\/\/glow-prod-nl.s3.eu-west-1.amazonaws.com\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2013\/02\/Slide163-300x225.png?X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&amp;X-Amz-Security-Token=IQoJb3JpZ2luX2VjEKb%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJHMEUCIB8wzBylTr%2FWrXeq44%2BT7KgBfbdpi8zKp3nO8vaotSJGAiEA9KlRQzdpiE%2BeU%2BAskK71CVDiyPGfadmaES5NCePn2B0quAUIbxAFGgwyNzM1NzAxOTU0MzMiDP7A8eg7UIdy0JluWSqVBZHdF1203GJ4EtUE2fgJgXuxonaoCgF8GqRMjoiBHYww9d2CzIgY9dJDjYfuqjl6bCWND7Dd6%2BEp3cFSajTgXcdy752YdGEct2Xi5njzI2TZt9tDMA0silInxsFkWrPV1iQUQLICRNtzLsmZ%2FfT0mvaJaUquDX0ZFtWLwn%2Fvh1AWUl%2FX5Z9O7tRbp%2FKkBhY2VXTe8ZxziAum9XODiY8KREVwbbgTnWQBSMZ56bRb0dIWCAGRk7hf%2FRn7uQ%2Bi0fHBejxox8yQ5QH%2BiguyzSw9QAZpjPltkjCtnqdFJWGPhJn8v%2BqcIL1oQLQmR8DcUnbxWLbkhR8XoViEcLsbj1cMjZqbWE1Jq%2Bj44O60vTYW3hrARjTUOW%2Fw%2BL5ZCmy1WWv9OUvARK%2FYzCkHqbH%2BRdP8F6AbqrfzUS5T%2FkAdc5LAJ6mrI1o320BwKJ%2Fm1qAEjASB4ZO3FzYrzeYXKHMyMcwA%2BQyQy2Aa6rVDsayHGcTwa2zY6guinpf7hbWkY%2BERNdEIKvYjj5KN0G1kDqDjEMoh%2FEN3K%2FfXwrR4cPLnPM71Vj8ikrmiq2KvNtjpMh1R5UL2oiVFhgP9KUXygaw3fbhO0AvGNQ7pvqSp%2BIIi0XRm%2B72R5cdzMLVCGKtDJTjuwviSz2htezhXc0ORV%2Fuh%2BjgM4QO7Eg1CiGxLvYvfWqse%2FaidhxJaSbzDsPYcgdpHjO17lxrLWGh5RenLEC9VjrBl7IqKHTXA4GRkyBEpLm07t%2B%2B77Sz49sWp%2BfQfWTAec4CPOHI3GPwlCP77%2FQSGpY896V9cKHh5arOSXMQPKwo1aEbHXHJZntS4JVK%2F5HWePWXmmiQNC0a6bpFFnTDzC3d6qn2xGOTyLef4QYKzD0vGW1zkUbFRKqQwvK6u1gY6sQEVG9p%2BLmO%2BUN1WqKtLna3pRFBjUK5G7C14QhxXdXel7zKQqDjNn%2BJdXGJm%2BJlEeW81yFxEHTrCenxOg5xwgtkfyVWrox7vD5Iwihsk9pIZE%2B4DASUFbFtFaO6LYeFXGc%2FdVeSE08vucgvVZ0%2FkscFothvFfevzrAF1PErp1oliX%2FntLd3yNPLQQgr2dplIv6bPfMnMe76OvTM%2FAnMpUvteIq8pC53EKKDd2R%2BXhezcmxI%3D&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47UR5ILKSLD%2F20261011%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20261011T143044Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=8da7ec168a3628854cd1a89aaddd58174874ba6948a794efe39c3d8ca2d66d33 300w, https:\/\/blogs.glowscotland.org.uk\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2013\/02\/Slide163.png 600w\" sizes=\"(max-width: 150px) 100vw, 150px\" data-attachment-id=\"156\" data-permalink=\"https:\/\/blogs.glowscotland.org.uk\/nl\/ColtnessHS-ComputingScience\/2013\/02\/07\/spreadsheet-formula\/slide16-4\/\" data-orig-file=\"https:\/\/blogs.glowscotland.org.uk\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2013\/02\/Slide163.png\" data-orig-size=\"600,450\" data-comments-opened=\"1\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;}\" data-image-title=\"Slide16\" data-image-description=\"\" data-image-caption=\"\" data-medium-file=\"https:\/\/glow-prod-nl.s3.eu-west-1.amazonaws.com\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2013\/02\/Slide163-300x225.png?X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&amp;X-Amz-Security-Token=IQoJb3JpZ2luX2VjEKb%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJHMEUCIB8wzBylTr%2FWrXeq44%2BT7KgBfbdpi8zKp3nO8vaotSJGAiEA9KlRQzdpiE%2BeU%2BAskK71CVDiyPGfadmaES5NCePn2B0quAUIbxAFGgwyNzM1NzAxOTU0MzMiDP7A8eg7UIdy0JluWSqVBZHdF1203GJ4EtUE2fgJgXuxonaoCgF8GqRMjoiBHYww9d2CzIgY9dJDjYfuqjl6bCWND7Dd6%2BEp3cFSajTgXcdy752YdGEct2Xi5njzI2TZt9tDMA0silInxsFkWrPV1iQUQLICRNtzLsmZ%2FfT0mvaJaUquDX0ZFtWLwn%2Fvh1AWUl%2FX5Z9O7tRbp%2FKkBhY2VXTe8ZxziAum9XODiY8KREVwbbgTnWQBSMZ56bRb0dIWCAGRk7hf%2FRn7uQ%2Bi0fHBejxox8yQ5QH%2BiguyzSw9QAZpjPltkjCtnqdFJWGPhJn8v%2BqcIL1oQLQmR8DcUnbxWLbkhR8XoViEcLsbj1cMjZqbWE1Jq%2Bj44O60vTYW3hrARjTUOW%2Fw%2BL5ZCmy1WWv9OUvARK%2FYzCkHqbH%2BRdP8F6AbqrfzUS5T%2FkAdc5LAJ6mrI1o320BwKJ%2Fm1qAEjASB4ZO3FzYrzeYXKHMyMcwA%2BQyQy2Aa6rVDsayHGcTwa2zY6guinpf7hbWkY%2BERNdEIKvYjj5KN0G1kDqDjEMoh%2FEN3K%2FfXwrR4cPLnPM71Vj8ikrmiq2KvNtjpMh1R5UL2oiVFhgP9KUXygaw3fbhO0AvGNQ7pvqSp%2BIIi0XRm%2B72R5cdzMLVCGKtDJTjuwviSz2htezhXc0ORV%2Fuh%2BjgM4QO7Eg1CiGxLvYvfWqse%2FaidhxJaSbzDsPYcgdpHjO17lxrLWGh5RenLEC9VjrBl7IqKHTXA4GRkyBEpLm07t%2B%2B77Sz49sWp%2BfQfWTAec4CPOHI3GPwlCP77%2FQSGpY896V9cKHh5arOSXMQPKwo1aEbHXHJZntS4JVK%2F5HWePWXmmiQNC0a6bpFFnTDzC3d6qn2xGOTyLef4QYKzD0vGW1zkUbFRKqQwvK6u1gY6sQEVG9p%2BLmO%2BUN1WqKtLna3pRFBjUK5G7C14QhxXdXel7zKQqDjNn%2BJdXGJm%2BJlEeW81yFxEHTrCenxOg5xwgtkfyVWrox7vD5Iwihsk9pIZE%2B4DASUFbFtFaO6LYeFXGc%2FdVeSE08vucgvVZ0%2FkscFothvFfevzrAF1PErp1oliX%2FntLd3yNPLQQgr2dplIv6bPfMnMe76OvTM%2FAnMpUvteIq8pC53EKKDd2R%2BXhezcmxI%3D&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47UR5ILKSLD%2F20261011%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20261011T143044Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=8da7ec168a3628854cd1a89aaddd58174874ba6948a794efe39c3d8ca2d66d33\" data-large-file=\"https:\/\/blogs.glowscotland.org.uk\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2013\/02\/Slide163.png\" \/><\/a>\n\t\t\t<\/div><\/figure><figure class='gallery-item'>\n\t\t\t<div class='gallery-icon landscape'>\n\t\t\t\t<a href='https:\/\/blogs.glowscotland.org.uk\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2013\/02\/Slide173.png'><img decoding=\"async\" width=\"150\" height=\"112\" src=\"https:\/\/glow-prod-nl.s3.eu-west-1.amazonaws.com\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2013\/02\/Slide173-150x112.png?X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&amp;X-Amz-Security-Token=IQoJb3JpZ2luX2VjEKb%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJHMEUCIB8wzBylTr%2FWrXeq44%2BT7KgBfbdpi8zKp3nO8vaotSJGAiEA9KlRQzdpiE%2BeU%2BAskK71CVDiyPGfadmaES5NCePn2B0quAUIbxAFGgwyNzM1NzAxOTU0MzMiDP7A8eg7UIdy0JluWSqVBZHdF1203GJ4EtUE2fgJgXuxonaoCgF8GqRMjoiBHYww9d2CzIgY9dJDjYfuqjl6bCWND7Dd6%2BEp3cFSajTgXcdy752YdGEct2Xi5njzI2TZt9tDMA0silInxsFkWrPV1iQUQLICRNtzLsmZ%2FfT0mvaJaUquDX0ZFtWLwn%2Fvh1AWUl%2FX5Z9O7tRbp%2FKkBhY2VXTe8ZxziAum9XODiY8KREVwbbgTnWQBSMZ56bRb0dIWCAGRk7hf%2FRn7uQ%2Bi0fHBejxox8yQ5QH%2BiguyzSw9QAZpjPltkjCtnqdFJWGPhJn8v%2BqcIL1oQLQmR8DcUnbxWLbkhR8XoViEcLsbj1cMjZqbWE1Jq%2Bj44O60vTYW3hrARjTUOW%2Fw%2BL5ZCmy1WWv9OUvARK%2FYzCkHqbH%2BRdP8F6AbqrfzUS5T%2FkAdc5LAJ6mrI1o320BwKJ%2Fm1qAEjASB4ZO3FzYrzeYXKHMyMcwA%2BQyQy2Aa6rVDsayHGcTwa2zY6guinpf7hbWkY%2BERNdEIKvYjj5KN0G1kDqDjEMoh%2FEN3K%2FfXwrR4cPLnPM71Vj8ikrmiq2KvNtjpMh1R5UL2oiVFhgP9KUXygaw3fbhO0AvGNQ7pvqSp%2BIIi0XRm%2B72R5cdzMLVCGKtDJTjuwviSz2htezhXc0ORV%2Fuh%2BjgM4QO7Eg1CiGxLvYvfWqse%2FaidhxJaSbzDsPYcgdpHjO17lxrLWGh5RenLEC9VjrBl7IqKHTXA4GRkyBEpLm07t%2B%2B77Sz49sWp%2BfQfWTAec4CPOHI3GPwlCP77%2FQSGpY896V9cKHh5arOSXMQPKwo1aEbHXHJZntS4JVK%2F5HWePWXmmiQNC0a6bpFFnTDzC3d6qn2xGOTyLef4QYKzD0vGW1zkUbFRKqQwvK6u1gY6sQEVG9p%2BLmO%2BUN1WqKtLna3pRFBjUK5G7C14QhxXdXel7zKQqDjNn%2BJdXGJm%2BJlEeW81yFxEHTrCenxOg5xwgtkfyVWrox7vD5Iwihsk9pIZE%2B4DASUFbFtFaO6LYeFXGc%2FdVeSE08vucgvVZ0%2FkscFothvFfevzrAF1PErp1oliX%2FntLd3yNPLQQgr2dplIv6bPfMnMe76OvTM%2FAnMpUvteIq8pC53EKKDd2R%2BXhezcmxI%3D&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47UR5ILKSLD%2F20261011%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20261011T143044Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=56b2ff1041746c3443c5f9b109454e4b1d0c3f5d6965a60692d3668fbf92edde\" class=\"attachment-thumbnail size-thumbnail\" alt=\"\" srcset=\"https:\/\/glow-prod-nl.s3.eu-west-1.amazonaws.com\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2013\/02\/Slide173-150x112.png?X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&amp;X-Amz-Security-Token=IQoJb3JpZ2luX2VjEKb%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJHMEUCIB8wzBylTr%2FWrXeq44%2BT7KgBfbdpi8zKp3nO8vaotSJGAiEA9KlRQzdpiE%2BeU%2BAskK71CVDiyPGfadmaES5NCePn2B0quAUIbxAFGgwyNzM1NzAxOTU0MzMiDP7A8eg7UIdy0JluWSqVBZHdF1203GJ4EtUE2fgJgXuxonaoCgF8GqRMjoiBHYww9d2CzIgY9dJDjYfuqjl6bCWND7Dd6%2BEp3cFSajTgXcdy752YdGEct2Xi5njzI2TZt9tDMA0silInxsFkWrPV1iQUQLICRNtzLsmZ%2FfT0mvaJaUquDX0ZFtWLwn%2Fvh1AWUl%2FX5Z9O7tRbp%2FKkBhY2VXTe8ZxziAum9XODiY8KREVwbbgTnWQBSMZ56bRb0dIWCAGRk7hf%2FRn7uQ%2Bi0fHBejxox8yQ5QH%2BiguyzSw9QAZpjPltkjCtnqdFJWGPhJn8v%2BqcIL1oQLQmR8DcUnbxWLbkhR8XoViEcLsbj1cMjZqbWE1Jq%2Bj44O60vTYW3hrARjTUOW%2Fw%2BL5ZCmy1WWv9OUvARK%2FYzCkHqbH%2BRdP8F6AbqrfzUS5T%2FkAdc5LAJ6mrI1o320BwKJ%2Fm1qAEjASB4ZO3FzYrzeYXKHMyMcwA%2BQyQy2Aa6rVDsayHGcTwa2zY6guinpf7hbWkY%2BERNdEIKvYjj5KN0G1kDqDjEMoh%2FEN3K%2FfXwrR4cPLnPM71Vj8ikrmiq2KvNtjpMh1R5UL2oiVFhgP9KUXygaw3fbhO0AvGNQ7pvqSp%2BIIi0XRm%2B72R5cdzMLVCGKtDJTjuwviSz2htezhXc0ORV%2Fuh%2BjgM4QO7Eg1CiGxLvYvfWqse%2FaidhxJaSbzDsPYcgdpHjO17lxrLWGh5RenLEC9VjrBl7IqKHTXA4GRkyBEpLm07t%2B%2B77Sz49sWp%2BfQfWTAec4CPOHI3GPwlCP77%2FQSGpY896V9cKHh5arOSXMQPKwo1aEbHXHJZntS4JVK%2F5HWePWXmmiQNC0a6bpFFnTDzC3d6qn2xGOTyLef4QYKzD0vGW1zkUbFRKqQwvK6u1gY6sQEVG9p%2BLmO%2BUN1WqKtLna3pRFBjUK5G7C14QhxXdXel7zKQqDjNn%2BJdXGJm%2BJlEeW81yFxEHTrCenxOg5xwgtkfyVWrox7vD5Iwihsk9pIZE%2B4DASUFbFtFaO6LYeFXGc%2FdVeSE08vucgvVZ0%2FkscFothvFfevzrAF1PErp1oliX%2FntLd3yNPLQQgr2dplIv6bPfMnMe76OvTM%2FAnMpUvteIq8pC53EKKDd2R%2BXhezcmxI%3D&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47UR5ILKSLD%2F20261011%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20261011T143044Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=56b2ff1041746c3443c5f9b109454e4b1d0c3f5d6965a60692d3668fbf92edde 150w, https:\/\/glow-prod-nl.s3.eu-west-1.amazonaws.com\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2013\/02\/Slide173-300x225.png?X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&amp;X-Amz-Security-Token=IQoJb3JpZ2luX2VjEKb%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJHMEUCIB8wzBylTr%2FWrXeq44%2BT7KgBfbdpi8zKp3nO8vaotSJGAiEA9KlRQzdpiE%2BeU%2BAskK71CVDiyPGfadmaES5NCePn2B0quAUIbxAFGgwyNzM1NzAxOTU0MzMiDP7A8eg7UIdy0JluWSqVBZHdF1203GJ4EtUE2fgJgXuxonaoCgF8GqRMjoiBHYww9d2CzIgY9dJDjYfuqjl6bCWND7Dd6%2BEp3cFSajTgXcdy752YdGEct2Xi5njzI2TZt9tDMA0silInxsFkWrPV1iQUQLICRNtzLsmZ%2FfT0mvaJaUquDX0ZFtWLwn%2Fvh1AWUl%2FX5Z9O7tRbp%2FKkBhY2VXTe8ZxziAum9XODiY8KREVwbbgTnWQBSMZ56bRb0dIWCAGRk7hf%2FRn7uQ%2Bi0fHBejxox8yQ5QH%2BiguyzSw9QAZpjPltkjCtnqdFJWGPhJn8v%2BqcIL1oQLQmR8DcUnbxWLbkhR8XoViEcLsbj1cMjZqbWE1Jq%2Bj44O60vTYW3hrARjTUOW%2Fw%2BL5ZCmy1WWv9OUvARK%2FYzCkHqbH%2BRdP8F6AbqrfzUS5T%2FkAdc5LAJ6mrI1o320BwKJ%2Fm1qAEjASB4ZO3FzYrzeYXKHMyMcwA%2BQyQy2Aa6rVDsayHGcTwa2zY6guinpf7hbWkY%2BERNdEIKvYjj5KN0G1kDqDjEMoh%2FEN3K%2FfXwrR4cPLnPM71Vj8ikrmiq2KvNtjpMh1R5UL2oiVFhgP9KUXygaw3fbhO0AvGNQ7pvqSp%2BIIi0XRm%2B72R5cdzMLVCGKtDJTjuwviSz2htezhXc0ORV%2Fuh%2BjgM4QO7Eg1CiGxLvYvfWqse%2FaidhxJaSbzDsPYcgdpHjO17lxrLWGh5RenLEC9VjrBl7IqKHTXA4GRkyBEpLm07t%2B%2B77Sz49sWp%2BfQfWTAec4CPOHI3GPwlCP77%2FQSGpY896V9cKHh5arOSXMQPKwo1aEbHXHJZntS4JVK%2F5HWePWXmmiQNC0a6bpFFnTDzC3d6qn2xGOTyLef4QYKzD0vGW1zkUbFRKqQwvK6u1gY6sQEVG9p%2BLmO%2BUN1WqKtLna3pRFBjUK5G7C14QhxXdXel7zKQqDjNn%2BJdXGJm%2BJlEeW81yFxEHTrCenxOg5xwgtkfyVWrox7vD5Iwihsk9pIZE%2B4DASUFbFtFaO6LYeFXGc%2FdVeSE08vucgvVZ0%2FkscFothvFfevzrAF1PErp1oliX%2FntLd3yNPLQQgr2dplIv6bPfMnMe76OvTM%2FAnMpUvteIq8pC53EKKDd2R%2BXhezcmxI%3D&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47UR5ILKSLD%2F20261011%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20261011T143044Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=240dba26918d9f2e095cea34ebda080a89914362ec03d157cae10b3ae423ec69 300w, https:\/\/blogs.glowscotland.org.uk\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2013\/02\/Slide173.png 600w\" sizes=\"(max-width: 150px) 100vw, 150px\" data-attachment-id=\"157\" data-permalink=\"https:\/\/blogs.glowscotland.org.uk\/nl\/ColtnessHS-ComputingScience\/2013\/02\/07\/spreadsheet-formula\/slide17-4\/\" data-orig-file=\"https:\/\/blogs.glowscotland.org.uk\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2013\/02\/Slide173.png\" data-orig-size=\"600,450\" data-comments-opened=\"1\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;}\" data-image-title=\"Slide17\" data-image-description=\"\" data-image-caption=\"\" data-medium-file=\"https:\/\/glow-prod-nl.s3.eu-west-1.amazonaws.com\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2013\/02\/Slide173-300x225.png?X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&amp;X-Amz-Security-Token=IQoJb3JpZ2luX2VjEKb%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJHMEUCIB8wzBylTr%2FWrXeq44%2BT7KgBfbdpi8zKp3nO8vaotSJGAiEA9KlRQzdpiE%2BeU%2BAskK71CVDiyPGfadmaES5NCePn2B0quAUIbxAFGgwyNzM1NzAxOTU0MzMiDP7A8eg7UIdy0JluWSqVBZHdF1203GJ4EtUE2fgJgXuxonaoCgF8GqRMjoiBHYww9d2CzIgY9dJDjYfuqjl6bCWND7Dd6%2BEp3cFSajTgXcdy752YdGEct2Xi5njzI2TZt9tDMA0silInxsFkWrPV1iQUQLICRNtzLsmZ%2FfT0mvaJaUquDX0ZFtWLwn%2Fvh1AWUl%2FX5Z9O7tRbp%2FKkBhY2VXTe8ZxziAum9XODiY8KREVwbbgTnWQBSMZ56bRb0dIWCAGRk7hf%2FRn7uQ%2Bi0fHBejxox8yQ5QH%2BiguyzSw9QAZpjPltkjCtnqdFJWGPhJn8v%2BqcIL1oQLQmR8DcUnbxWLbkhR8XoViEcLsbj1cMjZqbWE1Jq%2Bj44O60vTYW3hrARjTUOW%2Fw%2BL5ZCmy1WWv9OUvARK%2FYzCkHqbH%2BRdP8F6AbqrfzUS5T%2FkAdc5LAJ6mrI1o320BwKJ%2Fm1qAEjASB4ZO3FzYrzeYXKHMyMcwA%2BQyQy2Aa6rVDsayHGcTwa2zY6guinpf7hbWkY%2BERNdEIKvYjj5KN0G1kDqDjEMoh%2FEN3K%2FfXwrR4cPLnPM71Vj8ikrmiq2KvNtjpMh1R5UL2oiVFhgP9KUXygaw3fbhO0AvGNQ7pvqSp%2BIIi0XRm%2B72R5cdzMLVCGKtDJTjuwviSz2htezhXc0ORV%2Fuh%2BjgM4QO7Eg1CiGxLvYvfWqse%2FaidhxJaSbzDsPYcgdpHjO17lxrLWGh5RenLEC9VjrBl7IqKHTXA4GRkyBEpLm07t%2B%2B77Sz49sWp%2BfQfWTAec4CPOHI3GPwlCP77%2FQSGpY896V9cKHh5arOSXMQPKwo1aEbHXHJZntS4JVK%2F5HWePWXmmiQNC0a6bpFFnTDzC3d6qn2xGOTyLef4QYKzD0vGW1zkUbFRKqQwvK6u1gY6sQEVG9p%2BLmO%2BUN1WqKtLna3pRFBjUK5G7C14QhxXdXel7zKQqDjNn%2BJdXGJm%2BJlEeW81yFxEHTrCenxOg5xwgtkfyVWrox7vD5Iwihsk9pIZE%2B4DASUFbFtFaO6LYeFXGc%2FdVeSE08vucgvVZ0%2FkscFothvFfevzrAF1PErp1oliX%2FntLd3yNPLQQgr2dplIv6bPfMnMe76OvTM%2FAnMpUvteIq8pC53EKKDd2R%2BXhezcmxI%3D&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47UR5ILKSLD%2F20261011%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20261011T143044Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=240dba26918d9f2e095cea34ebda080a89914362ec03d157cae10b3ae423ec69\" data-large-file=\"https:\/\/blogs.glowscotland.org.uk\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2013\/02\/Slide173.png\" \/><\/a>\n\t\t\t<\/div><\/figure><figure class='gallery-item'>\n\t\t\t<div class='gallery-icon landscape'>\n\t\t\t\t<a href='https:\/\/blogs.glowscotland.org.uk\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2013\/02\/Slide183.png'><img decoding=\"async\" width=\"150\" height=\"112\" src=\"https:\/\/glow-prod-nl.s3.eu-west-1.amazonaws.com\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2013\/02\/Slide183-150x112.png?X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&amp;X-Amz-Security-Token=IQoJb3JpZ2luX2VjEKb%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJHMEUCIB8wzBylTr%2FWrXeq44%2BT7KgBfbdpi8zKp3nO8vaotSJGAiEA9KlRQzdpiE%2BeU%2BAskK71CVDiyPGfadmaES5NCePn2B0quAUIbxAFGgwyNzM1NzAxOTU0MzMiDP7A8eg7UIdy0JluWSqVBZHdF1203GJ4EtUE2fgJgXuxonaoCgF8GqRMjoiBHYww9d2CzIgY9dJDjYfuqjl6bCWND7Dd6%2BEp3cFSajTgXcdy752YdGEct2Xi5njzI2TZt9tDMA0silInxsFkWrPV1iQUQLICRNtzLsmZ%2FfT0mvaJaUquDX0ZFtWLwn%2Fvh1AWUl%2FX5Z9O7tRbp%2FKkBhY2VXTe8ZxziAum9XODiY8KREVwbbgTnWQBSMZ56bRb0dIWCAGRk7hf%2FRn7uQ%2Bi0fHBejxox8yQ5QH%2BiguyzSw9QAZpjPltkjCtnqdFJWGPhJn8v%2BqcIL1oQLQmR8DcUnbxWLbkhR8XoViEcLsbj1cMjZqbWE1Jq%2Bj44O60vTYW3hrARjTUOW%2Fw%2BL5ZCmy1WWv9OUvARK%2FYzCkHqbH%2BRdP8F6AbqrfzUS5T%2FkAdc5LAJ6mrI1o320BwKJ%2Fm1qAEjASB4ZO3FzYrzeYXKHMyMcwA%2BQyQy2Aa6rVDsayHGcTwa2zY6guinpf7hbWkY%2BERNdEIKvYjj5KN0G1kDqDjEMoh%2FEN3K%2FfXwrR4cPLnPM71Vj8ikrmiq2KvNtjpMh1R5UL2oiVFhgP9KUXygaw3fbhO0AvGNQ7pvqSp%2BIIi0XRm%2B72R5cdzMLVCGKtDJTjuwviSz2htezhXc0ORV%2Fuh%2BjgM4QO7Eg1CiGxLvYvfWqse%2FaidhxJaSbzDsPYcgdpHjO17lxrLWGh5RenLEC9VjrBl7IqKHTXA4GRkyBEpLm07t%2B%2B77Sz49sWp%2BfQfWTAec4CPOHI3GPwlCP77%2FQSGpY896V9cKHh5arOSXMQPKwo1aEbHXHJZntS4JVK%2F5HWePWXmmiQNC0a6bpFFnTDzC3d6qn2xGOTyLef4QYKzD0vGW1zkUbFRKqQwvK6u1gY6sQEVG9p%2BLmO%2BUN1WqKtLna3pRFBjUK5G7C14QhxXdXel7zKQqDjNn%2BJdXGJm%2BJlEeW81yFxEHTrCenxOg5xwgtkfyVWrox7vD5Iwihsk9pIZE%2B4DASUFbFtFaO6LYeFXGc%2FdVeSE08vucgvVZ0%2FkscFothvFfevzrAF1PErp1oliX%2FntLd3yNPLQQgr2dplIv6bPfMnMe76OvTM%2FAnMpUvteIq8pC53EKKDd2R%2BXhezcmxI%3D&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47UR5ILKSLD%2F20261011%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20261011T143044Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=b95b91892cd6255b7252306f1debcb9ae912a2d5b25d2cabe0c64de7937bb39a\" class=\"attachment-thumbnail size-thumbnail\" alt=\"\" srcset=\"https:\/\/glow-prod-nl.s3.eu-west-1.amazonaws.com\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2013\/02\/Slide183-150x112.png?X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&amp;X-Amz-Security-Token=IQoJb3JpZ2luX2VjEKb%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJHMEUCIB8wzBylTr%2FWrXeq44%2BT7KgBfbdpi8zKp3nO8vaotSJGAiEA9KlRQzdpiE%2BeU%2BAskK71CVDiyPGfadmaES5NCePn2B0quAUIbxAFGgwyNzM1NzAxOTU0MzMiDP7A8eg7UIdy0JluWSqVBZHdF1203GJ4EtUE2fgJgXuxonaoCgF8GqRMjoiBHYww9d2CzIgY9dJDjYfuqjl6bCWND7Dd6%2BEp3cFSajTgXcdy752YdGEct2Xi5njzI2TZt9tDMA0silInxsFkWrPV1iQUQLICRNtzLsmZ%2FfT0mvaJaUquDX0ZFtWLwn%2Fvh1AWUl%2FX5Z9O7tRbp%2FKkBhY2VXTe8ZxziAum9XODiY8KREVwbbgTnWQBSMZ56bRb0dIWCAGRk7hf%2FRn7uQ%2Bi0fHBejxox8yQ5QH%2BiguyzSw9QAZpjPltkjCtnqdFJWGPhJn8v%2BqcIL1oQLQmR8DcUnbxWLbkhR8XoViEcLsbj1cMjZqbWE1Jq%2Bj44O60vTYW3hrARjTUOW%2Fw%2BL5ZCmy1WWv9OUvARK%2FYzCkHqbH%2BRdP8F6AbqrfzUS5T%2FkAdc5LAJ6mrI1o320BwKJ%2Fm1qAEjASB4ZO3FzYrzeYXKHMyMcwA%2BQyQy2Aa6rVDsayHGcTwa2zY6guinpf7hbWkY%2BERNdEIKvYjj5KN0G1kDqDjEMoh%2FEN3K%2FfXwrR4cPLnPM71Vj8ikrmiq2KvNtjpMh1R5UL2oiVFhgP9KUXygaw3fbhO0AvGNQ7pvqSp%2BIIi0XRm%2B72R5cdzMLVCGKtDJTjuwviSz2htezhXc0ORV%2Fuh%2BjgM4QO7Eg1CiGxLvYvfWqse%2FaidhxJaSbzDsPYcgdpHjO17lxrLWGh5RenLEC9VjrBl7IqKHTXA4GRkyBEpLm07t%2B%2B77Sz49sWp%2BfQfWTAec4CPOHI3GPwlCP77%2FQSGpY896V9cKHh5arOSXMQPKwo1aEbHXHJZntS4JVK%2F5HWePWXmmiQNC0a6bpFFnTDzC3d6qn2xGOTyLef4QYKzD0vGW1zkUbFRKqQwvK6u1gY6sQEVG9p%2BLmO%2BUN1WqKtLna3pRFBjUK5G7C14QhxXdXel7zKQqDjNn%2BJdXGJm%2BJlEeW81yFxEHTrCenxOg5xwgtkfyVWrox7vD5Iwihsk9pIZE%2B4DASUFbFtFaO6LYeFXGc%2FdVeSE08vucgvVZ0%2FkscFothvFfevzrAF1PErp1oliX%2FntLd3yNPLQQgr2dplIv6bPfMnMe76OvTM%2FAnMpUvteIq8pC53EKKDd2R%2BXhezcmxI%3D&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47UR5ILKSLD%2F20261011%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20261011T143044Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=b95b91892cd6255b7252306f1debcb9ae912a2d5b25d2cabe0c64de7937bb39a 150w, https:\/\/glow-prod-nl.s3.eu-west-1.amazonaws.com\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2013\/02\/Slide183-300x225.png?X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&amp;X-Amz-Security-Token=IQoJb3JpZ2luX2VjEKb%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJHMEUCIB8wzBylTr%2FWrXeq44%2BT7KgBfbdpi8zKp3nO8vaotSJGAiEA9KlRQzdpiE%2BeU%2BAskK71CVDiyPGfadmaES5NCePn2B0quAUIbxAFGgwyNzM1NzAxOTU0MzMiDP7A8eg7UIdy0JluWSqVBZHdF1203GJ4EtUE2fgJgXuxonaoCgF8GqRMjoiBHYww9d2CzIgY9dJDjYfuqjl6bCWND7Dd6%2BEp3cFSajTgXcdy752YdGEct2Xi5njzI2TZt9tDMA0silInxsFkWrPV1iQUQLICRNtzLsmZ%2FfT0mvaJaUquDX0ZFtWLwn%2Fvh1AWUl%2FX5Z9O7tRbp%2FKkBhY2VXTe8ZxziAum9XODiY8KREVwbbgTnWQBSMZ56bRb0dIWCAGRk7hf%2FRn7uQ%2Bi0fHBejxox8yQ5QH%2BiguyzSw9QAZpjPltkjCtnqdFJWGPhJn8v%2BqcIL1oQLQmR8DcUnbxWLbkhR8XoViEcLsbj1cMjZqbWE1Jq%2Bj44O60vTYW3hrARjTUOW%2Fw%2BL5ZCmy1WWv9OUvARK%2FYzCkHqbH%2BRdP8F6AbqrfzUS5T%2FkAdc5LAJ6mrI1o320BwKJ%2Fm1qAEjASB4ZO3FzYrzeYXKHMyMcwA%2BQyQy2Aa6rVDsayHGcTwa2zY6guinpf7hbWkY%2BERNdEIKvYjj5KN0G1kDqDjEMoh%2FEN3K%2FfXwrR4cPLnPM71Vj8ikrmiq2KvNtjpMh1R5UL2oiVFhgP9KUXygaw3fbhO0AvGNQ7pvqSp%2BIIi0XRm%2B72R5cdzMLVCGKtDJTjuwviSz2htezhXc0ORV%2Fuh%2BjgM4QO7Eg1CiGxLvYvfWqse%2FaidhxJaSbzDsPYcgdpHjO17lxrLWGh5RenLEC9VjrBl7IqKHTXA4GRkyBEpLm07t%2B%2B77Sz49sWp%2BfQfWTAec4CPOHI3GPwlCP77%2FQSGpY896V9cKHh5arOSXMQPKwo1aEbHXHJZntS4JVK%2F5HWePWXmmiQNC0a6bpFFnTDzC3d6qn2xGOTyLef4QYKzD0vGW1zkUbFRKqQwvK6u1gY6sQEVG9p%2BLmO%2BUN1WqKtLna3pRFBjUK5G7C14QhxXdXel7zKQqDjNn%2BJdXGJm%2BJlEeW81yFxEHTrCenxOg5xwgtkfyVWrox7vD5Iwihsk9pIZE%2B4DASUFbFtFaO6LYeFXGc%2FdVeSE08vucgvVZ0%2FkscFothvFfevzrAF1PErp1oliX%2FntLd3yNPLQQgr2dplIv6bPfMnMe76OvTM%2FAnMpUvteIq8pC53EKKDd2R%2BXhezcmxI%3D&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47UR5ILKSLD%2F20261011%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20261011T143044Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=03e8568867fd4cb4929933b06386606d1bcf53e34c0bd043e66f5fe474e5723a 300w, https:\/\/blogs.glowscotland.org.uk\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2013\/02\/Slide183.png 600w\" sizes=\"(max-width: 150px) 100vw, 150px\" data-attachment-id=\"158\" data-permalink=\"https:\/\/blogs.glowscotland.org.uk\/nl\/ColtnessHS-ComputingScience\/2013\/02\/07\/spreadsheet-formula\/slide18-4\/\" data-orig-file=\"https:\/\/blogs.glowscotland.org.uk\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2013\/02\/Slide183.png\" data-orig-size=\"600,450\" data-comments-opened=\"1\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;}\" data-image-title=\"Slide18\" data-image-description=\"\" data-image-caption=\"\" data-medium-file=\"https:\/\/glow-prod-nl.s3.eu-west-1.amazonaws.com\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2013\/02\/Slide183-300x225.png?X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&amp;X-Amz-Security-Token=IQoJb3JpZ2luX2VjEKb%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJHMEUCIB8wzBylTr%2FWrXeq44%2BT7KgBfbdpi8zKp3nO8vaotSJGAiEA9KlRQzdpiE%2BeU%2BAskK71CVDiyPGfadmaES5NCePn2B0quAUIbxAFGgwyNzM1NzAxOTU0MzMiDP7A8eg7UIdy0JluWSqVBZHdF1203GJ4EtUE2fgJgXuxonaoCgF8GqRMjoiBHYww9d2CzIgY9dJDjYfuqjl6bCWND7Dd6%2BEp3cFSajTgXcdy752YdGEct2Xi5njzI2TZt9tDMA0silInxsFkWrPV1iQUQLICRNtzLsmZ%2FfT0mvaJaUquDX0ZFtWLwn%2Fvh1AWUl%2FX5Z9O7tRbp%2FKkBhY2VXTe8ZxziAum9XODiY8KREVwbbgTnWQBSMZ56bRb0dIWCAGRk7hf%2FRn7uQ%2Bi0fHBejxox8yQ5QH%2BiguyzSw9QAZpjPltkjCtnqdFJWGPhJn8v%2BqcIL1oQLQmR8DcUnbxWLbkhR8XoViEcLsbj1cMjZqbWE1Jq%2Bj44O60vTYW3hrARjTUOW%2Fw%2BL5ZCmy1WWv9OUvARK%2FYzCkHqbH%2BRdP8F6AbqrfzUS5T%2FkAdc5LAJ6mrI1o320BwKJ%2Fm1qAEjASB4ZO3FzYrzeYXKHMyMcwA%2BQyQy2Aa6rVDsayHGcTwa2zY6guinpf7hbWkY%2BERNdEIKvYjj5KN0G1kDqDjEMoh%2FEN3K%2FfXwrR4cPLnPM71Vj8ikrmiq2KvNtjpMh1R5UL2oiVFhgP9KUXygaw3fbhO0AvGNQ7pvqSp%2BIIi0XRm%2B72R5cdzMLVCGKtDJTjuwviSz2htezhXc0ORV%2Fuh%2BjgM4QO7Eg1CiGxLvYvfWqse%2FaidhxJaSbzDsPYcgdpHjO17lxrLWGh5RenLEC9VjrBl7IqKHTXA4GRkyBEpLm07t%2B%2B77Sz49sWp%2BfQfWTAec4CPOHI3GPwlCP77%2FQSGpY896V9cKHh5arOSXMQPKwo1aEbHXHJZntS4JVK%2F5HWePWXmmiQNC0a6bpFFnTDzC3d6qn2xGOTyLef4QYKzD0vGW1zkUbFRKqQwvK6u1gY6sQEVG9p%2BLmO%2BUN1WqKtLna3pRFBjUK5G7C14QhxXdXel7zKQqDjNn%2BJdXGJm%2BJlEeW81yFxEHTrCenxOg5xwgtkfyVWrox7vD5Iwihsk9pIZE%2B4DASUFbFtFaO6LYeFXGc%2FdVeSE08vucgvVZ0%2FkscFothvFfevzrAF1PErp1oliX%2FntLd3yNPLQQgr2dplIv6bPfMnMe76OvTM%2FAnMpUvteIq8pC53EKKDd2R%2BXhezcmxI%3D&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47UR5ILKSLD%2F20261011%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20261011T143044Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=03e8568867fd4cb4929933b06386606d1bcf53e34c0bd043e66f5fe474e5723a\" data-large-file=\"https:\/\/blogs.glowscotland.org.uk\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2013\/02\/Slide183.png\" \/><\/a>\n\t\t\t<\/div><\/figure><figure class='gallery-item'>\n\t\t\t<div class='gallery-icon landscape'>\n\t\t\t\t<a href='https:\/\/blogs.glowscotland.org.uk\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2013\/02\/Slide193.png'><img decoding=\"async\" width=\"150\" height=\"112\" src=\"https:\/\/glow-prod-nl.s3.eu-west-1.amazonaws.com\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2013\/02\/Slide193-150x112.png?X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&amp;X-Amz-Security-Token=IQoJb3JpZ2luX2VjEKb%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJHMEUCIB8wzBylTr%2FWrXeq44%2BT7KgBfbdpi8zKp3nO8vaotSJGAiEA9KlRQzdpiE%2BeU%2BAskK71CVDiyPGfadmaES5NCePn2B0quAUIbxAFGgwyNzM1NzAxOTU0MzMiDP7A8eg7UIdy0JluWSqVBZHdF1203GJ4EtUE2fgJgXuxonaoCgF8GqRMjoiBHYww9d2CzIgY9dJDjYfuqjl6bCWND7Dd6%2BEp3cFSajTgXcdy752YdGEct2Xi5njzI2TZt9tDMA0silInxsFkWrPV1iQUQLICRNtzLsmZ%2FfT0mvaJaUquDX0ZFtWLwn%2Fvh1AWUl%2FX5Z9O7tRbp%2FKkBhY2VXTe8ZxziAum9XODiY8KREVwbbgTnWQBSMZ56bRb0dIWCAGRk7hf%2FRn7uQ%2Bi0fHBejxox8yQ5QH%2BiguyzSw9QAZpjPltkjCtnqdFJWGPhJn8v%2BqcIL1oQLQmR8DcUnbxWLbkhR8XoViEcLsbj1cMjZqbWE1Jq%2Bj44O60vTYW3hrARjTUOW%2Fw%2BL5ZCmy1WWv9OUvARK%2FYzCkHqbH%2BRdP8F6AbqrfzUS5T%2FkAdc5LAJ6mrI1o320BwKJ%2Fm1qAEjASB4ZO3FzYrzeYXKHMyMcwA%2BQyQy2Aa6rVDsayHGcTwa2zY6guinpf7hbWkY%2BERNdEIKvYjj5KN0G1kDqDjEMoh%2FEN3K%2FfXwrR4cPLnPM71Vj8ikrmiq2KvNtjpMh1R5UL2oiVFhgP9KUXygaw3fbhO0AvGNQ7pvqSp%2BIIi0XRm%2B72R5cdzMLVCGKtDJTjuwviSz2htezhXc0ORV%2Fuh%2BjgM4QO7Eg1CiGxLvYvfWqse%2FaidhxJaSbzDsPYcgdpHjO17lxrLWGh5RenLEC9VjrBl7IqKHTXA4GRkyBEpLm07t%2B%2B77Sz49sWp%2BfQfWTAec4CPOHI3GPwlCP77%2FQSGpY896V9cKHh5arOSXMQPKwo1aEbHXHJZntS4JVK%2F5HWePWXmmiQNC0a6bpFFnTDzC3d6qn2xGOTyLef4QYKzD0vGW1zkUbFRKqQwvK6u1gY6sQEVG9p%2BLmO%2BUN1WqKtLna3pRFBjUK5G7C14QhxXdXel7zKQqDjNn%2BJdXGJm%2BJlEeW81yFxEHTrCenxOg5xwgtkfyVWrox7vD5Iwihsk9pIZE%2B4DASUFbFtFaO6LYeFXGc%2FdVeSE08vucgvVZ0%2FkscFothvFfevzrAF1PErp1oliX%2FntLd3yNPLQQgr2dplIv6bPfMnMe76OvTM%2FAnMpUvteIq8pC53EKKDd2R%2BXhezcmxI%3D&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47UR5ILKSLD%2F20261011%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20261011T143044Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=d036cc4ec7e3b758a4b2852502c072f383ad76d254f37bc0265678a80c539920\" class=\"attachment-thumbnail size-thumbnail\" alt=\"\" srcset=\"https:\/\/glow-prod-nl.s3.eu-west-1.amazonaws.com\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2013\/02\/Slide193-150x112.png?X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&amp;X-Amz-Security-Token=IQoJb3JpZ2luX2VjEKb%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJHMEUCIB8wzBylTr%2FWrXeq44%2BT7KgBfbdpi8zKp3nO8vaotSJGAiEA9KlRQzdpiE%2BeU%2BAskK71CVDiyPGfadmaES5NCePn2B0quAUIbxAFGgwyNzM1NzAxOTU0MzMiDP7A8eg7UIdy0JluWSqVBZHdF1203GJ4EtUE2fgJgXuxonaoCgF8GqRMjoiBHYww9d2CzIgY9dJDjYfuqjl6bCWND7Dd6%2BEp3cFSajTgXcdy752YdGEct2Xi5njzI2TZt9tDMA0silInxsFkWrPV1iQUQLICRNtzLsmZ%2FfT0mvaJaUquDX0ZFtWLwn%2Fvh1AWUl%2FX5Z9O7tRbp%2FKkBhY2VXTe8ZxziAum9XODiY8KREVwbbgTnWQBSMZ56bRb0dIWCAGRk7hf%2FRn7uQ%2Bi0fHBejxox8yQ5QH%2BiguyzSw9QAZpjPltkjCtnqdFJWGPhJn8v%2BqcIL1oQLQmR8DcUnbxWLbkhR8XoViEcLsbj1cMjZqbWE1Jq%2Bj44O60vTYW3hrARjTUOW%2Fw%2BL5ZCmy1WWv9OUvARK%2FYzCkHqbH%2BRdP8F6AbqrfzUS5T%2FkAdc5LAJ6mrI1o320BwKJ%2Fm1qAEjASB4ZO3FzYrzeYXKHMyMcwA%2BQyQy2Aa6rVDsayHGcTwa2zY6guinpf7hbWkY%2BERNdEIKvYjj5KN0G1kDqDjEMoh%2FEN3K%2FfXwrR4cPLnPM71Vj8ikrmiq2KvNtjpMh1R5UL2oiVFhgP9KUXygaw3fbhO0AvGNQ7pvqSp%2BIIi0XRm%2B72R5cdzMLVCGKtDJTjuwviSz2htezhXc0ORV%2Fuh%2BjgM4QO7Eg1CiGxLvYvfWqse%2FaidhxJaSbzDsPYcgdpHjO17lxrLWGh5RenLEC9VjrBl7IqKHTXA4GRkyBEpLm07t%2B%2B77Sz49sWp%2BfQfWTAec4CPOHI3GPwlCP77%2FQSGpY896V9cKHh5arOSXMQPKwo1aEbHXHJZntS4JVK%2F5HWePWXmmiQNC0a6bpFFnTDzC3d6qn2xGOTyLef4QYKzD0vGW1zkUbFRKqQwvK6u1gY6sQEVG9p%2BLmO%2BUN1WqKtLna3pRFBjUK5G7C14QhxXdXel7zKQqDjNn%2BJdXGJm%2BJlEeW81yFxEHTrCenxOg5xwgtkfyVWrox7vD5Iwihsk9pIZE%2B4DASUFbFtFaO6LYeFXGc%2FdVeSE08vucgvVZ0%2FkscFothvFfevzrAF1PErp1oliX%2FntLd3yNPLQQgr2dplIv6bPfMnMe76OvTM%2FAnMpUvteIq8pC53EKKDd2R%2BXhezcmxI%3D&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47UR5ILKSLD%2F20261011%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20261011T143044Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=d036cc4ec7e3b758a4b2852502c072f383ad76d254f37bc0265678a80c539920 150w, https:\/\/glow-prod-nl.s3.eu-west-1.amazonaws.com\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2013\/02\/Slide193-300x225.png?X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&amp;X-Amz-Security-Token=IQoJb3JpZ2luX2VjEKb%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJHMEUCIB8wzBylTr%2FWrXeq44%2BT7KgBfbdpi8zKp3nO8vaotSJGAiEA9KlRQzdpiE%2BeU%2BAskK71CVDiyPGfadmaES5NCePn2B0quAUIbxAFGgwyNzM1NzAxOTU0MzMiDP7A8eg7UIdy0JluWSqVBZHdF1203GJ4EtUE2fgJgXuxonaoCgF8GqRMjoiBHYww9d2CzIgY9dJDjYfuqjl6bCWND7Dd6%2BEp3cFSajTgXcdy752YdGEct2Xi5njzI2TZt9tDMA0silInxsFkWrPV1iQUQLICRNtzLsmZ%2FfT0mvaJaUquDX0ZFtWLwn%2Fvh1AWUl%2FX5Z9O7tRbp%2FKkBhY2VXTe8ZxziAum9XODiY8KREVwbbgTnWQBSMZ56bRb0dIWCAGRk7hf%2FRn7uQ%2Bi0fHBejxox8yQ5QH%2BiguyzSw9QAZpjPltkjCtnqdFJWGPhJn8v%2BqcIL1oQLQmR8DcUnbxWLbkhR8XoViEcLsbj1cMjZqbWE1Jq%2Bj44O60vTYW3hrARjTUOW%2Fw%2BL5ZCmy1WWv9OUvARK%2FYzCkHqbH%2BRdP8F6AbqrfzUS5T%2FkAdc5LAJ6mrI1o320BwKJ%2Fm1qAEjASB4ZO3FzYrzeYXKHMyMcwA%2BQyQy2Aa6rVDsayHGcTwa2zY6guinpf7hbWkY%2BERNdEIKvYjj5KN0G1kDqDjEMoh%2FEN3K%2FfXwrR4cPLnPM71Vj8ikrmiq2KvNtjpMh1R5UL2oiVFhgP9KUXygaw3fbhO0AvGNQ7pvqSp%2BIIi0XRm%2B72R5cdzMLVCGKtDJTjuwviSz2htezhXc0ORV%2Fuh%2BjgM4QO7Eg1CiGxLvYvfWqse%2FaidhxJaSbzDsPYcgdpHjO17lxrLWGh5RenLEC9VjrBl7IqKHTXA4GRkyBEpLm07t%2B%2B77Sz49sWp%2BfQfWTAec4CPOHI3GPwlCP77%2FQSGpY896V9cKHh5arOSXMQPKwo1aEbHXHJZntS4JVK%2F5HWePWXmmiQNC0a6bpFFnTDzC3d6qn2xGOTyLef4QYKzD0vGW1zkUbFRKqQwvK6u1gY6sQEVG9p%2BLmO%2BUN1WqKtLna3pRFBjUK5G7C14QhxXdXel7zKQqDjNn%2BJdXGJm%2BJlEeW81yFxEHTrCenxOg5xwgtkfyVWrox7vD5Iwihsk9pIZE%2B4DASUFbFtFaO6LYeFXGc%2FdVeSE08vucgvVZ0%2FkscFothvFfevzrAF1PErp1oliX%2FntLd3yNPLQQgr2dplIv6bPfMnMe76OvTM%2FAnMpUvteIq8pC53EKKDd2R%2BXhezcmxI%3D&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47UR5ILKSLD%2F20261011%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20261011T143044Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=98e071d429867c5f1aae74352297ea736a63b52d9c8778deef6b6355a8dad772 300w, https:\/\/blogs.glowscotland.org.uk\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2013\/02\/Slide193.png 600w\" sizes=\"(max-width: 150px) 100vw, 150px\" data-attachment-id=\"159\" data-permalink=\"https:\/\/blogs.glowscotland.org.uk\/nl\/ColtnessHS-ComputingScience\/2013\/02\/07\/spreadsheet-formula\/slide19-4\/\" data-orig-file=\"https:\/\/blogs.glowscotland.org.uk\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2013\/02\/Slide193.png\" data-orig-size=\"600,450\" data-comments-opened=\"1\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;}\" data-image-title=\"Slide19\" data-image-description=\"\" data-image-caption=\"\" data-medium-file=\"https:\/\/glow-prod-nl.s3.eu-west-1.amazonaws.com\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2013\/02\/Slide193-300x225.png?X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&amp;X-Amz-Security-Token=IQoJb3JpZ2luX2VjEKb%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJHMEUCIB8wzBylTr%2FWrXeq44%2BT7KgBfbdpi8zKp3nO8vaotSJGAiEA9KlRQzdpiE%2BeU%2BAskK71CVDiyPGfadmaES5NCePn2B0quAUIbxAFGgwyNzM1NzAxOTU0MzMiDP7A8eg7UIdy0JluWSqVBZHdF1203GJ4EtUE2fgJgXuxonaoCgF8GqRMjoiBHYww9d2CzIgY9dJDjYfuqjl6bCWND7Dd6%2BEp3cFSajTgXcdy752YdGEct2Xi5njzI2TZt9tDMA0silInxsFkWrPV1iQUQLICRNtzLsmZ%2FfT0mvaJaUquDX0ZFtWLwn%2Fvh1AWUl%2FX5Z9O7tRbp%2FKkBhY2VXTe8ZxziAum9XODiY8KREVwbbgTnWQBSMZ56bRb0dIWCAGRk7hf%2FRn7uQ%2Bi0fHBejxox8yQ5QH%2BiguyzSw9QAZpjPltkjCtnqdFJWGPhJn8v%2BqcIL1oQLQmR8DcUnbxWLbkhR8XoViEcLsbj1cMjZqbWE1Jq%2Bj44O60vTYW3hrARjTUOW%2Fw%2BL5ZCmy1WWv9OUvARK%2FYzCkHqbH%2BRdP8F6AbqrfzUS5T%2FkAdc5LAJ6mrI1o320BwKJ%2Fm1qAEjASB4ZO3FzYrzeYXKHMyMcwA%2BQyQy2Aa6rVDsayHGcTwa2zY6guinpf7hbWkY%2BERNdEIKvYjj5KN0G1kDqDjEMoh%2FEN3K%2FfXwrR4cPLnPM71Vj8ikrmiq2KvNtjpMh1R5UL2oiVFhgP9KUXygaw3fbhO0AvGNQ7pvqSp%2BIIi0XRm%2B72R5cdzMLVCGKtDJTjuwviSz2htezhXc0ORV%2Fuh%2BjgM4QO7Eg1CiGxLvYvfWqse%2FaidhxJaSbzDsPYcgdpHjO17lxrLWGh5RenLEC9VjrBl7IqKHTXA4GRkyBEpLm07t%2B%2B77Sz49sWp%2BfQfWTAec4CPOHI3GPwlCP77%2FQSGpY896V9cKHh5arOSXMQPKwo1aEbHXHJZntS4JVK%2F5HWePWXmmiQNC0a6bpFFnTDzC3d6qn2xGOTyLef4QYKzD0vGW1zkUbFRKqQwvK6u1gY6sQEVG9p%2BLmO%2BUN1WqKtLna3pRFBjUK5G7C14QhxXdXel7zKQqDjNn%2BJdXGJm%2BJlEeW81yFxEHTrCenxOg5xwgtkfyVWrox7vD5Iwihsk9pIZE%2B4DASUFbFtFaO6LYeFXGc%2FdVeSE08vucgvVZ0%2FkscFothvFfevzrAF1PErp1oliX%2FntLd3yNPLQQgr2dplIv6bPfMnMe76OvTM%2FAnMpUvteIq8pC53EKKDd2R%2BXhezcmxI%3D&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47UR5ILKSLD%2F20261011%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20261011T143044Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=98e071d429867c5f1aae74352297ea736a63b52d9c8778deef6b6355a8dad772\" data-large-file=\"https:\/\/blogs.glowscotland.org.uk\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2013\/02\/Slide193.png\" \/><\/a>\n\t\t\t<\/div><\/figure><figure class='gallery-item'>\n\t\t\t<div class='gallery-icon landscape'>\n\t\t\t\t<a href='https:\/\/blogs.glowscotland.org.uk\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2013\/02\/Slide202.png'><img decoding=\"async\" width=\"150\" height=\"112\" src=\"https:\/\/glow-prod-nl.s3.eu-west-1.amazonaws.com\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2013\/02\/Slide202-150x112.png?X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&amp;X-Amz-Security-Token=IQoJb3JpZ2luX2VjEKb%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJHMEUCIB8wzBylTr%2FWrXeq44%2BT7KgBfbdpi8zKp3nO8vaotSJGAiEA9KlRQzdpiE%2BeU%2BAskK71CVDiyPGfadmaES5NCePn2B0quAUIbxAFGgwyNzM1NzAxOTU0MzMiDP7A8eg7UIdy0JluWSqVBZHdF1203GJ4EtUE2fgJgXuxonaoCgF8GqRMjoiBHYww9d2CzIgY9dJDjYfuqjl6bCWND7Dd6%2BEp3cFSajTgXcdy752YdGEct2Xi5njzI2TZt9tDMA0silInxsFkWrPV1iQUQLICRNtzLsmZ%2FfT0mvaJaUquDX0ZFtWLwn%2Fvh1AWUl%2FX5Z9O7tRbp%2FKkBhY2VXTe8ZxziAum9XODiY8KREVwbbgTnWQBSMZ56bRb0dIWCAGRk7hf%2FRn7uQ%2Bi0fHBejxox8yQ5QH%2BiguyzSw9QAZpjPltkjCtnqdFJWGPhJn8v%2BqcIL1oQLQmR8DcUnbxWLbkhR8XoViEcLsbj1cMjZqbWE1Jq%2Bj44O60vTYW3hrARjTUOW%2Fw%2BL5ZCmy1WWv9OUvARK%2FYzCkHqbH%2BRdP8F6AbqrfzUS5T%2FkAdc5LAJ6mrI1o320BwKJ%2Fm1qAEjASB4ZO3FzYrzeYXKHMyMcwA%2BQyQy2Aa6rVDsayHGcTwa2zY6guinpf7hbWkY%2BERNdEIKvYjj5KN0G1kDqDjEMoh%2FEN3K%2FfXwrR4cPLnPM71Vj8ikrmiq2KvNtjpMh1R5UL2oiVFhgP9KUXygaw3fbhO0AvGNQ7pvqSp%2BIIi0XRm%2B72R5cdzMLVCGKtDJTjuwviSz2htezhXc0ORV%2Fuh%2BjgM4QO7Eg1CiGxLvYvfWqse%2FaidhxJaSbzDsPYcgdpHjO17lxrLWGh5RenLEC9VjrBl7IqKHTXA4GRkyBEpLm07t%2B%2B77Sz49sWp%2BfQfWTAec4CPOHI3GPwlCP77%2FQSGpY896V9cKHh5arOSXMQPKwo1aEbHXHJZntS4JVK%2F5HWePWXmmiQNC0a6bpFFnTDzC3d6qn2xGOTyLef4QYKzD0vGW1zkUbFRKqQwvK6u1gY6sQEVG9p%2BLmO%2BUN1WqKtLna3pRFBjUK5G7C14QhxXdXel7zKQqDjNn%2BJdXGJm%2BJlEeW81yFxEHTrCenxOg5xwgtkfyVWrox7vD5Iwihsk9pIZE%2B4DASUFbFtFaO6LYeFXGc%2FdVeSE08vucgvVZ0%2FkscFothvFfevzrAF1PErp1oliX%2FntLd3yNPLQQgr2dplIv6bPfMnMe76OvTM%2FAnMpUvteIq8pC53EKKDd2R%2BXhezcmxI%3D&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47UR5ILKSLD%2F20261011%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20261011T143044Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=4597991717943a62b2606624ba7c354fc1198ec5bfe0d295f24053429f4fe2fe\" class=\"attachment-thumbnail size-thumbnail\" alt=\"\" srcset=\"https:\/\/glow-prod-nl.s3.eu-west-1.amazonaws.com\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2013\/02\/Slide202-150x112.png?X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&amp;X-Amz-Security-Token=IQoJb3JpZ2luX2VjEKb%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJHMEUCIB8wzBylTr%2FWrXeq44%2BT7KgBfbdpi8zKp3nO8vaotSJGAiEA9KlRQzdpiE%2BeU%2BAskK71CVDiyPGfadmaES5NCePn2B0quAUIbxAFGgwyNzM1NzAxOTU0MzMiDP7A8eg7UIdy0JluWSqVBZHdF1203GJ4EtUE2fgJgXuxonaoCgF8GqRMjoiBHYww9d2CzIgY9dJDjYfuqjl6bCWND7Dd6%2BEp3cFSajTgXcdy752YdGEct2Xi5njzI2TZt9tDMA0silInxsFkWrPV1iQUQLICRNtzLsmZ%2FfT0mvaJaUquDX0ZFtWLwn%2Fvh1AWUl%2FX5Z9O7tRbp%2FKkBhY2VXTe8ZxziAum9XODiY8KREVwbbgTnWQBSMZ56bRb0dIWCAGRk7hf%2FRn7uQ%2Bi0fHBejxox8yQ5QH%2BiguyzSw9QAZpjPltkjCtnqdFJWGPhJn8v%2BqcIL1oQLQmR8DcUnbxWLbkhR8XoViEcLsbj1cMjZqbWE1Jq%2Bj44O60vTYW3hrARjTUOW%2Fw%2BL5ZCmy1WWv9OUvARK%2FYzCkHqbH%2BRdP8F6AbqrfzUS5T%2FkAdc5LAJ6mrI1o320BwKJ%2Fm1qAEjASB4ZO3FzYrzeYXKHMyMcwA%2BQyQy2Aa6rVDsayHGcTwa2zY6guinpf7hbWkY%2BERNdEIKvYjj5KN0G1kDqDjEMoh%2FEN3K%2FfXwrR4cPLnPM71Vj8ikrmiq2KvNtjpMh1R5UL2oiVFhgP9KUXygaw3fbhO0AvGNQ7pvqSp%2BIIi0XRm%2B72R5cdzMLVCGKtDJTjuwviSz2htezhXc0ORV%2Fuh%2BjgM4QO7Eg1CiGxLvYvfWqse%2FaidhxJaSbzDsPYcgdpHjO17lxrLWGh5RenLEC9VjrBl7IqKHTXA4GRkyBEpLm07t%2B%2B77Sz49sWp%2BfQfWTAec4CPOHI3GPwlCP77%2FQSGpY896V9cKHh5arOSXMQPKwo1aEbHXHJZntS4JVK%2F5HWePWXmmiQNC0a6bpFFnTDzC3d6qn2xGOTyLef4QYKzD0vGW1zkUbFRKqQwvK6u1gY6sQEVG9p%2BLmO%2BUN1WqKtLna3pRFBjUK5G7C14QhxXdXel7zKQqDjNn%2BJdXGJm%2BJlEeW81yFxEHTrCenxOg5xwgtkfyVWrox7vD5Iwihsk9pIZE%2B4DASUFbFtFaO6LYeFXGc%2FdVeSE08vucgvVZ0%2FkscFothvFfevzrAF1PErp1oliX%2FntLd3yNPLQQgr2dplIv6bPfMnMe76OvTM%2FAnMpUvteIq8pC53EKKDd2R%2BXhezcmxI%3D&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47UR5ILKSLD%2F20261011%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20261011T143044Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=4597991717943a62b2606624ba7c354fc1198ec5bfe0d295f24053429f4fe2fe 150w, https:\/\/glow-prod-nl.s3.eu-west-1.amazonaws.com\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2013\/02\/Slide202-300x225.png?X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&amp;X-Amz-Security-Token=IQoJb3JpZ2luX2VjEKb%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJHMEUCIB8wzBylTr%2FWrXeq44%2BT7KgBfbdpi8zKp3nO8vaotSJGAiEA9KlRQzdpiE%2BeU%2BAskK71CVDiyPGfadmaES5NCePn2B0quAUIbxAFGgwyNzM1NzAxOTU0MzMiDP7A8eg7UIdy0JluWSqVBZHdF1203GJ4EtUE2fgJgXuxonaoCgF8GqRMjoiBHYww9d2CzIgY9dJDjYfuqjl6bCWND7Dd6%2BEp3cFSajTgXcdy752YdGEct2Xi5njzI2TZt9tDMA0silInxsFkWrPV1iQUQLICRNtzLsmZ%2FfT0mvaJaUquDX0ZFtWLwn%2Fvh1AWUl%2FX5Z9O7tRbp%2FKkBhY2VXTe8ZxziAum9XODiY8KREVwbbgTnWQBSMZ56bRb0dIWCAGRk7hf%2FRn7uQ%2Bi0fHBejxox8yQ5QH%2BiguyzSw9QAZpjPltkjCtnqdFJWGPhJn8v%2BqcIL1oQLQmR8DcUnbxWLbkhR8XoViEcLsbj1cMjZqbWE1Jq%2Bj44O60vTYW3hrARjTUOW%2Fw%2BL5ZCmy1WWv9OUvARK%2FYzCkHqbH%2BRdP8F6AbqrfzUS5T%2FkAdc5LAJ6mrI1o320BwKJ%2Fm1qAEjASB4ZO3FzYrzeYXKHMyMcwA%2BQyQy2Aa6rVDsayHGcTwa2zY6guinpf7hbWkY%2BERNdEIKvYjj5KN0G1kDqDjEMoh%2FEN3K%2FfXwrR4cPLnPM71Vj8ikrmiq2KvNtjpMh1R5UL2oiVFhgP9KUXygaw3fbhO0AvGNQ7pvqSp%2BIIi0XRm%2B72R5cdzMLVCGKtDJTjuwviSz2htezhXc0ORV%2Fuh%2BjgM4QO7Eg1CiGxLvYvfWqse%2FaidhxJaSbzDsPYcgdpHjO17lxrLWGh5RenLEC9VjrBl7IqKHTXA4GRkyBEpLm07t%2B%2B77Sz49sWp%2BfQfWTAec4CPOHI3GPwlCP77%2FQSGpY896V9cKHh5arOSXMQPKwo1aEbHXHJZntS4JVK%2F5HWePWXmmiQNC0a6bpFFnTDzC3d6qn2xGOTyLef4QYKzD0vGW1zkUbFRKqQwvK6u1gY6sQEVG9p%2BLmO%2BUN1WqKtLna3pRFBjUK5G7C14QhxXdXel7zKQqDjNn%2BJdXGJm%2BJlEeW81yFxEHTrCenxOg5xwgtkfyVWrox7vD5Iwihsk9pIZE%2B4DASUFbFtFaO6LYeFXGc%2FdVeSE08vucgvVZ0%2FkscFothvFfevzrAF1PErp1oliX%2FntLd3yNPLQQgr2dplIv6bPfMnMe76OvTM%2FAnMpUvteIq8pC53EKKDd2R%2BXhezcmxI%3D&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47UR5ILKSLD%2F20261011%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20261011T143044Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=ee0dc3f4df5f1deea54c3d8e00266e9cfd1639776d66256c4cc4f5c248c3129c 300w, https:\/\/blogs.glowscotland.org.uk\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2013\/02\/Slide202.png 600w\" sizes=\"(max-width: 150px) 100vw, 150px\" data-attachment-id=\"160\" data-permalink=\"https:\/\/blogs.glowscotland.org.uk\/nl\/ColtnessHS-ComputingScience\/2013\/02\/07\/spreadsheet-formula\/slide20-3\/\" data-orig-file=\"https:\/\/blogs.glowscotland.org.uk\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2013\/02\/Slide202.png\" data-orig-size=\"600,450\" data-comments-opened=\"1\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;}\" data-image-title=\"Slide20\" data-image-description=\"\" data-image-caption=\"\" data-medium-file=\"https:\/\/glow-prod-nl.s3.eu-west-1.amazonaws.com\/nl\/public\/ColtnessHS-ComputingScience\/uploads\/sites\/12638\/2013\/02\/Slide202-300x225.png?X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&amp;X-Amz-Security-Token=IQoJb3JpZ2luX2VjEKb%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJHMEUCIB8wzBylTr%2FWrXeq44%2BT7KgBfbdpi8zKp3nO8vaotSJGAiEA9KlRQzdpiE%2BeU%2BAskK71CVDiyPGfadmaES5NCePn2B0quAUIbxAFGgwyNzM1NzAxOTU0MzMiDP7A8eg7UIdy0JluWSqVBZHdF1203GJ4EtUE2fgJgXuxonaoCgF8GqRMjoiBHYww9d2CzIgY9dJDjYfuqjl6bCWND7Dd6%2BEp3cFSajTgXcdy752YdGEct2Xi5njzI2TZt9tDMA0silInxsFkWrPV1iQUQLICRNtzLsmZ%2FfT0mvaJaUquDX0ZFtWLwn%2Fvh1AWUl%2FX5Z9O7tRbp%2FKkBhY2VXTe8ZxziAum9XODiY8KREVwbbgTnWQBSMZ56bRb0dIWCAGRk7hf%2FRn7uQ%2Bi0fHBejxox8yQ5QH%2BiguyzSw9QAZpjPltkjCtnqdFJWGPhJn8v%2BqcIL1oQLQmR8DcUnbxWLbkhR8XoViEcLsbj1cMjZqbWE1Jq%2Bj44O60vTYW3hrARjTUOW%2Fw%2BL5ZCmy1WWv9OUvARK%2FYzCkHqbH%2BRdP8F6AbqrfzUS5T%2FkAdc5LAJ6mrI1o320BwKJ%2Fm1qAEjASB4ZO3FzYrzeYXKHMyMcwA%2BQyQy2Aa6rVDsayHGcTwa2zY6guinpf7hbWkY%2BERNdEIKvYjj5KN0G1kDqDjEMoh%2FEN3K%2FfXwrR4cPLnPM71Vj8ikrmiq2KvNtjpMh1R5UL2oiVFhgP9KUXygaw3fbhO0AvGNQ7pvqSp%2BIIi0XRm%2B72R5cdzMLVCGKtDJTjuwviSz2htezhXc0ORV%2Fuh%2BjgM4QO7Eg1CiGxLvYvfWqse%2FaidhxJaSbzDsPYcgdpHjO17lxrLWGh5RenLEC9VjrBl7IqKHTXA4GRkyBEpLm07t%2B%2B77Sz49sWp%2BfQfWTAec4CPOHI3GPwlCP77%2FQSGpY896V9cKHh5arOSXMQPKwo1aEbHXHJZntS4JVK%2F5HWePWXmmiQNC0a6bpFFnTDzC3d6qn2xGOTyLef4QYKzD0vGW1zkUbFRKqQwvK6u1gY6sQEVG9p%2BLmO%2BUN1WqKtLna3pRFBjUK5G7C14QhxXdXel7zKQqDjNn%2BJdXGJm%2BJlEeW81yFxEHTrCenxOg5xwgtkfyVWrox7vD5Iwihsk9pIZE%2B4DASUFbFtFaO6LYeFXGc%2FdVeSE08vucgvVZ0%2FkscFothvFfevzrAF1PErp1oliX%2FntLd3yNPLQQgr2dplIv6bPfMnMe76OvTM%2FAnMpUvteIq8pC53EKKDd2R%2BXhezcmxI%3D&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47UR5ILKSLD%2F20261011%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20261011T143044Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=ee0dc3f4df5f1deea54c3d8e00266e9cfd1639776d66256c4cc4f5c248c3129c\" 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}]}}