{"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=IQoJb3JpZ2luX2VjEGoaCWV1LXdlc3QtMSJGMEQCICS0FFn1%2B%2Fzvc7haLFRWQY44hD33IrDbbqIPuqyiTWScAiAEZBvSDWqNAeWXKuO9guabncRs83F5SvMXcG6bcm5VvCq4BQgzEAUaDDI3MzU3MDE5NTQzMyIMMJgboLCWdy4H%2FLuyKpUF1wLQy38l0OcytnzlBo37I8x1ta%2BMS2BzJiwypJS%2Be8z%2B%2Fb5LRA2vx%2BJ%2FEGhhRG5%2BGQVtdHk3b6IV1ZXjjF3z4slkNMzBmzG3pSW61A4TNQ1SY233JRF6MQMeaFtAv%2BiOkgLdCP4%2BP4%2F0Hq9to6hmIxAChG8ZSTYznV%2FkbwcaOhQUy0a8ps4h6KHRL7ux9MPpVNnKra7ODWwxw1AC%2BcfCxEtVZXtDZosNbYIACgXpNrsod6drpSnOMOF87uP6ParabNalKppC3Bwh0zixyFIJ%2BBIuGwFmRfd51k7pAhv0O59v31jFJQ6yVM6ons51t45Yiv7jlEGcguhcG3dO6A4vXQ8pe%2Fcqa6wHIFLCHqN2ZJzsbRpQKfaDNqrmX4i8x7ZSO2h3ptV9%2FwOGEp5qKPAVast2Azp36rkW%2BNvL61Fri4JNm9sZWlKYlNRDordBdZ%2FD27Gm9c4H6slCak6rR6N3dx5KrmXNUDeM56AuCNipkC56n1wrXMh8dGoa7CRR5koFSP0kD9B%2ByrZ4SGudepamQS3yB1qOsvX9Xl1WJmBLNH42ueFh2rICihvVdP3kjM2UB22iqhBrSt5gJg%2FIrT0vTAP0cUPlAkFkVBPbOpVX%2BZLjQGF%2B3KmmlIbjXdKKLQ%2Fi18RevtAp6xuXIhP%2FOxjmuf4nsE2PyHJIz2RY%2B%2B%2BED%2Fprkj4euzcXr%2BhO6QfM0W3rqmAi30lLCtUxlVl%2FEGYCKMytwhWP4zCiZkNbh%2Ble%2F53YWoit9iqpo7%2FMsppdRFMyks31Vr5s8SzpHbyOW%2FWIuRudHSbuqHVZHtZFrkwO%2BbgRWHotPGeULSCf3JSQ3hr%2BoaXr01jmg0MCDC%2BOYooA%2BKz8ak5JiIeUwnNbqGDYWtdH3pjBUzDdye7RBjqyARkKxrNRJnHsdSWsDePcoNQ8ZBR4qy07PJD%2FP0p5yRdgU8bfIU%2FpabEV%2FyFMN6hBRUWQQFfq2BwfjOxNYk%2BOU2Q2BRxbILbznTNP8QPMuPHKFlp7PcJb%2Bo0%2FnH5gKaIhy7Lzo80bv7KctgwHEipnSS8z5XkWrsHc%2BX0FhKYnmQWTIFSGpUzjOrttWOX8Ea6BVgjsiktyr9VzU%2BJvMoTLbPQbQpXesvmm%2F69b38bfTvo2GsU%3D&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47UU2XXR6N6%2F20260624%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260624T101342Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=0637c7aa3857a18c29cd6138c7ca2abacf08fd198d2455405201cb2d09c234f3\" 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=IQoJb3JpZ2luX2VjEGoaCWV1LXdlc3QtMSJGMEQCICS0FFn1%2B%2Fzvc7haLFRWQY44hD33IrDbbqIPuqyiTWScAiAEZBvSDWqNAeWXKuO9guabncRs83F5SvMXcG6bcm5VvCq4BQgzEAUaDDI3MzU3MDE5NTQzMyIMMJgboLCWdy4H%2FLuyKpUF1wLQy38l0OcytnzlBo37I8x1ta%2BMS2BzJiwypJS%2Be8z%2B%2Fb5LRA2vx%2BJ%2FEGhhRG5%2BGQVtdHk3b6IV1ZXjjF3z4slkNMzBmzG3pSW61A4TNQ1SY233JRF6MQMeaFtAv%2BiOkgLdCP4%2BP4%2F0Hq9to6hmIxAChG8ZSTYznV%2FkbwcaOhQUy0a8ps4h6KHRL7ux9MPpVNnKra7ODWwxw1AC%2BcfCxEtVZXtDZosNbYIACgXpNrsod6drpSnOMOF87uP6ParabNalKppC3Bwh0zixyFIJ%2BBIuGwFmRfd51k7pAhv0O59v31jFJQ6yVM6ons51t45Yiv7jlEGcguhcG3dO6A4vXQ8pe%2Fcqa6wHIFLCHqN2ZJzsbRpQKfaDNqrmX4i8x7ZSO2h3ptV9%2FwOGEp5qKPAVast2Azp36rkW%2BNvL61Fri4JNm9sZWlKYlNRDordBdZ%2FD27Gm9c4H6slCak6rR6N3dx5KrmXNUDeM56AuCNipkC56n1wrXMh8dGoa7CRR5koFSP0kD9B%2ByrZ4SGudepamQS3yB1qOsvX9Xl1WJmBLNH42ueFh2rICihvVdP3kjM2UB22iqhBrSt5gJg%2FIrT0vTAP0cUPlAkFkVBPbOpVX%2BZLjQGF%2B3KmmlIbjXdKKLQ%2Fi18RevtAp6xuXIhP%2FOxjmuf4nsE2PyHJIz2RY%2B%2B%2BED%2Fprkj4euzcXr%2BhO6QfM0W3rqmAi30lLCtUxlVl%2FEGYCKMytwhWP4zCiZkNbh%2Ble%2F53YWoit9iqpo7%2FMsppdRFMyks31Vr5s8SzpHbyOW%2FWIuRudHSbuqHVZHtZFrkwO%2BbgRWHotPGeULSCf3JSQ3hr%2BoaXr01jmg0MCDC%2BOYooA%2BKz8ak5JiIeUwnNbqGDYWtdH3pjBUzDdye7RBjqyARkKxrNRJnHsdSWsDePcoNQ8ZBR4qy07PJD%2FP0p5yRdgU8bfIU%2FpabEV%2FyFMN6hBRUWQQFfq2BwfjOxNYk%2BOU2Q2BRxbILbznTNP8QPMuPHKFlp7PcJb%2Bo0%2FnH5gKaIhy7Lzo80bv7KctgwHEipnSS8z5XkWrsHc%2BX0FhKYnmQWTIFSGpUzjOrttWOX8Ea6BVgjsiktyr9VzU%2BJvMoTLbPQbQpXesvmm%2F69b38bfTvo2GsU%3D&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47UU2XXR6N6%2F20260624%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260624T101342Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=0637c7aa3857a18c29cd6138c7ca2abacf08fd198d2455405201cb2d09c234f3 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=IQoJb3JpZ2luX2VjEGoaCWV1LXdlc3QtMSJGMEQCICS0FFn1%2B%2Fzvc7haLFRWQY44hD33IrDbbqIPuqyiTWScAiAEZBvSDWqNAeWXKuO9guabncRs83F5SvMXcG6bcm5VvCq4BQgzEAUaDDI3MzU3MDE5NTQzMyIMMJgboLCWdy4H%2FLuyKpUF1wLQy38l0OcytnzlBo37I8x1ta%2BMS2BzJiwypJS%2Be8z%2B%2Fb5LRA2vx%2BJ%2FEGhhRG5%2BGQVtdHk3b6IV1ZXjjF3z4slkNMzBmzG3pSW61A4TNQ1SY233JRF6MQMeaFtAv%2BiOkgLdCP4%2BP4%2F0Hq9to6hmIxAChG8ZSTYznV%2FkbwcaOhQUy0a8ps4h6KHRL7ux9MPpVNnKra7ODWwxw1AC%2BcfCxEtVZXtDZosNbYIACgXpNrsod6drpSnOMOF87uP6ParabNalKppC3Bwh0zixyFIJ%2BBIuGwFmRfd51k7pAhv0O59v31jFJQ6yVM6ons51t45Yiv7jlEGcguhcG3dO6A4vXQ8pe%2Fcqa6wHIFLCHqN2ZJzsbRpQKfaDNqrmX4i8x7ZSO2h3ptV9%2FwOGEp5qKPAVast2Azp36rkW%2BNvL61Fri4JNm9sZWlKYlNRDordBdZ%2FD27Gm9c4H6slCak6rR6N3dx5KrmXNUDeM56AuCNipkC56n1wrXMh8dGoa7CRR5koFSP0kD9B%2ByrZ4SGudepamQS3yB1qOsvX9Xl1WJmBLNH42ueFh2rICihvVdP3kjM2UB22iqhBrSt5gJg%2FIrT0vTAP0cUPlAkFkVBPbOpVX%2BZLjQGF%2B3KmmlIbjXdKKLQ%2Fi18RevtAp6xuXIhP%2FOxjmuf4nsE2PyHJIz2RY%2B%2B%2BED%2Fprkj4euzcXr%2BhO6QfM0W3rqmAi30lLCtUxlVl%2FEGYCKMytwhWP4zCiZkNbh%2Ble%2F53YWoit9iqpo7%2FMsppdRFMyks31Vr5s8SzpHbyOW%2FWIuRudHSbuqHVZHtZFrkwO%2BbgRWHotPGeULSCf3JSQ3hr%2BoaXr01jmg0MCDC%2BOYooA%2BKz8ak5JiIeUwnNbqGDYWtdH3pjBUzDdye7RBjqyARkKxrNRJnHsdSWsDePcoNQ8ZBR4qy07PJD%2FP0p5yRdgU8bfIU%2FpabEV%2FyFMN6hBRUWQQFfq2BwfjOxNYk%2BOU2Q2BRxbILbznTNP8QPMuPHKFlp7PcJb%2Bo0%2FnH5gKaIhy7Lzo80bv7KctgwHEipnSS8z5XkWrsHc%2BX0FhKYnmQWTIFSGpUzjOrttWOX8Ea6BVgjsiktyr9VzU%2BJvMoTLbPQbQpXesvmm%2F69b38bfTvo2GsU%3D&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47UU2XXR6N6%2F20260624%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260624T101342Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=e75dade7a010b3aa27782cf55bb05ade68a86fdac0510de3153a00620303c7cd 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=IQoJb3JpZ2luX2VjEGoaCWV1LXdlc3QtMSJGMEQCICS0FFn1%2B%2Fzvc7haLFRWQY44hD33IrDbbqIPuqyiTWScAiAEZBvSDWqNAeWXKuO9guabncRs83F5SvMXcG6bcm5VvCq4BQgzEAUaDDI3MzU3MDE5NTQzMyIMMJgboLCWdy4H%2FLuyKpUF1wLQy38l0OcytnzlBo37I8x1ta%2BMS2BzJiwypJS%2Be8z%2B%2Fb5LRA2vx%2BJ%2FEGhhRG5%2BGQVtdHk3b6IV1ZXjjF3z4slkNMzBmzG3pSW61A4TNQ1SY233JRF6MQMeaFtAv%2BiOkgLdCP4%2BP4%2F0Hq9to6hmIxAChG8ZSTYznV%2FkbwcaOhQUy0a8ps4h6KHRL7ux9MPpVNnKra7ODWwxw1AC%2BcfCxEtVZXtDZosNbYIACgXpNrsod6drpSnOMOF87uP6ParabNalKppC3Bwh0zixyFIJ%2BBIuGwFmRfd51k7pAhv0O59v31jFJQ6yVM6ons51t45Yiv7jlEGcguhcG3dO6A4vXQ8pe%2Fcqa6wHIFLCHqN2ZJzsbRpQKfaDNqrmX4i8x7ZSO2h3ptV9%2FwOGEp5qKPAVast2Azp36rkW%2BNvL61Fri4JNm9sZWlKYlNRDordBdZ%2FD27Gm9c4H6slCak6rR6N3dx5KrmXNUDeM56AuCNipkC56n1wrXMh8dGoa7CRR5koFSP0kD9B%2ByrZ4SGudepamQS3yB1qOsvX9Xl1WJmBLNH42ueFh2rICihvVdP3kjM2UB22iqhBrSt5gJg%2FIrT0vTAP0cUPlAkFkVBPbOpVX%2BZLjQGF%2B3KmmlIbjXdKKLQ%2Fi18RevtAp6xuXIhP%2FOxjmuf4nsE2PyHJIz2RY%2B%2B%2BED%2Fprkj4euzcXr%2BhO6QfM0W3rqmAi30lLCtUxlVl%2FEGYCKMytwhWP4zCiZkNbh%2Ble%2F53YWoit9iqpo7%2FMsppdRFMyks31Vr5s8SzpHbyOW%2FWIuRudHSbuqHVZHtZFrkwO%2BbgRWHotPGeULSCf3JSQ3hr%2BoaXr01jmg0MCDC%2BOYooA%2BKz8ak5JiIeUwnNbqGDYWtdH3pjBUzDdye7RBjqyARkKxrNRJnHsdSWsDePcoNQ8ZBR4qy07PJD%2FP0p5yRdgU8bfIU%2FpabEV%2FyFMN6hBRUWQQFfq2BwfjOxNYk%2BOU2Q2BRxbILbznTNP8QPMuPHKFlp7PcJb%2Bo0%2FnH5gKaIhy7Lzo80bv7KctgwHEipnSS8z5XkWrsHc%2BX0FhKYnmQWTIFSGpUzjOrttWOX8Ea6BVgjsiktyr9VzU%2BJvMoTLbPQbQpXesvmm%2F69b38bfTvo2GsU%3D&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47UU2XXR6N6%2F20260624%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260624T101342Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=e75dade7a010b3aa27782cf55bb05ade68a86fdac0510de3153a00620303c7cd\" 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=IQoJb3JpZ2luX2VjEGoaCWV1LXdlc3QtMSJGMEQCICS0FFn1%2B%2Fzvc7haLFRWQY44hD33IrDbbqIPuqyiTWScAiAEZBvSDWqNAeWXKuO9guabncRs83F5SvMXcG6bcm5VvCq4BQgzEAUaDDI3MzU3MDE5NTQzMyIMMJgboLCWdy4H%2FLuyKpUF1wLQy38l0OcytnzlBo37I8x1ta%2BMS2BzJiwypJS%2Be8z%2B%2Fb5LRA2vx%2BJ%2FEGhhRG5%2BGQVtdHk3b6IV1ZXjjF3z4slkNMzBmzG3pSW61A4TNQ1SY233JRF6MQMeaFtAv%2BiOkgLdCP4%2BP4%2F0Hq9to6hmIxAChG8ZSTYznV%2FkbwcaOhQUy0a8ps4h6KHRL7ux9MPpVNnKra7ODWwxw1AC%2BcfCxEtVZXtDZosNbYIACgXpNrsod6drpSnOMOF87uP6ParabNalKppC3Bwh0zixyFIJ%2BBIuGwFmRfd51k7pAhv0O59v31jFJQ6yVM6ons51t45Yiv7jlEGcguhcG3dO6A4vXQ8pe%2Fcqa6wHIFLCHqN2ZJzsbRpQKfaDNqrmX4i8x7ZSO2h3ptV9%2FwOGEp5qKPAVast2Azp36rkW%2BNvL61Fri4JNm9sZWlKYlNRDordBdZ%2FD27Gm9c4H6slCak6rR6N3dx5KrmXNUDeM56AuCNipkC56n1wrXMh8dGoa7CRR5koFSP0kD9B%2ByrZ4SGudepamQS3yB1qOsvX9Xl1WJmBLNH42ueFh2rICihvVdP3kjM2UB22iqhBrSt5gJg%2FIrT0vTAP0cUPlAkFkVBPbOpVX%2BZLjQGF%2B3KmmlIbjXdKKLQ%2Fi18RevtAp6xuXIhP%2FOxjmuf4nsE2PyHJIz2RY%2B%2B%2BED%2Fprkj4euzcXr%2BhO6QfM0W3rqmAi30lLCtUxlVl%2FEGYCKMytwhWP4zCiZkNbh%2Ble%2F53YWoit9iqpo7%2FMsppdRFMyks31Vr5s8SzpHbyOW%2FWIuRudHSbuqHVZHtZFrkwO%2BbgRWHotPGeULSCf3JSQ3hr%2BoaXr01jmg0MCDC%2BOYooA%2BKz8ak5JiIeUwnNbqGDYWtdH3pjBUzDdye7RBjqyARkKxrNRJnHsdSWsDePcoNQ8ZBR4qy07PJD%2FP0p5yRdgU8bfIU%2FpabEV%2FyFMN6hBRUWQQFfq2BwfjOxNYk%2BOU2Q2BRxbILbznTNP8QPMuPHKFlp7PcJb%2Bo0%2FnH5gKaIhy7Lzo80bv7KctgwHEipnSS8z5XkWrsHc%2BX0FhKYnmQWTIFSGpUzjOrttWOX8Ea6BVgjsiktyr9VzU%2BJvMoTLbPQbQpXesvmm%2F69b38bfTvo2GsU%3D&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47UU2XXR6N6%2F20260624%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260624T101342Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=0e56fc180e74ca29614c2afe645df1bd1252ee52e8b2b5fa5a122ffbe2b021f1\" 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=IQoJb3JpZ2luX2VjEGoaCWV1LXdlc3QtMSJGMEQCICS0FFn1%2B%2Fzvc7haLFRWQY44hD33IrDbbqIPuqyiTWScAiAEZBvSDWqNAeWXKuO9guabncRs83F5SvMXcG6bcm5VvCq4BQgzEAUaDDI3MzU3MDE5NTQzMyIMMJgboLCWdy4H%2FLuyKpUF1wLQy38l0OcytnzlBo37I8x1ta%2BMS2BzJiwypJS%2Be8z%2B%2Fb5LRA2vx%2BJ%2FEGhhRG5%2BGQVtdHk3b6IV1ZXjjF3z4slkNMzBmzG3pSW61A4TNQ1SY233JRF6MQMeaFtAv%2BiOkgLdCP4%2BP4%2F0Hq9to6hmIxAChG8ZSTYznV%2FkbwcaOhQUy0a8ps4h6KHRL7ux9MPpVNnKra7ODWwxw1AC%2BcfCxEtVZXtDZosNbYIACgXpNrsod6drpSnOMOF87uP6ParabNalKppC3Bwh0zixyFIJ%2BBIuGwFmRfd51k7pAhv0O59v31jFJQ6yVM6ons51t45Yiv7jlEGcguhcG3dO6A4vXQ8pe%2Fcqa6wHIFLCHqN2ZJzsbRpQKfaDNqrmX4i8x7ZSO2h3ptV9%2FwOGEp5qKPAVast2Azp36rkW%2BNvL61Fri4JNm9sZWlKYlNRDordBdZ%2FD27Gm9c4H6slCak6rR6N3dx5KrmXNUDeM56AuCNipkC56n1wrXMh8dGoa7CRR5koFSP0kD9B%2ByrZ4SGudepamQS3yB1qOsvX9Xl1WJmBLNH42ueFh2rICihvVdP3kjM2UB22iqhBrSt5gJg%2FIrT0vTAP0cUPlAkFkVBPbOpVX%2BZLjQGF%2B3KmmlIbjXdKKLQ%2Fi18RevtAp6xuXIhP%2FOxjmuf4nsE2PyHJIz2RY%2B%2B%2BED%2Fprkj4euzcXr%2BhO6QfM0W3rqmAi30lLCtUxlVl%2FEGYCKMytwhWP4zCiZkNbh%2Ble%2F53YWoit9iqpo7%2FMsppdRFMyks31Vr5s8SzpHbyOW%2FWIuRudHSbuqHVZHtZFrkwO%2BbgRWHotPGeULSCf3JSQ3hr%2BoaXr01jmg0MCDC%2BOYooA%2BKz8ak5JiIeUwnNbqGDYWtdH3pjBUzDdye7RBjqyARkKxrNRJnHsdSWsDePcoNQ8ZBR4qy07PJD%2FP0p5yRdgU8bfIU%2FpabEV%2FyFMN6hBRUWQQFfq2BwfjOxNYk%2BOU2Q2BRxbILbznTNP8QPMuPHKFlp7PcJb%2Bo0%2FnH5gKaIhy7Lzo80bv7KctgwHEipnSS8z5XkWrsHc%2BX0FhKYnmQWTIFSGpUzjOrttWOX8Ea6BVgjsiktyr9VzU%2BJvMoTLbPQbQpXesvmm%2F69b38bfTvo2GsU%3D&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47UU2XXR6N6%2F20260624%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260624T101342Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=0e56fc180e74ca29614c2afe645df1bd1252ee52e8b2b5fa5a122ffbe2b021f1 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=IQoJb3JpZ2luX2VjEGoaCWV1LXdlc3QtMSJGMEQCICS0FFn1%2B%2Fzvc7haLFRWQY44hD33IrDbbqIPuqyiTWScAiAEZBvSDWqNAeWXKuO9guabncRs83F5SvMXcG6bcm5VvCq4BQgzEAUaDDI3MzU3MDE5NTQzMyIMMJgboLCWdy4H%2FLuyKpUF1wLQy38l0OcytnzlBo37I8x1ta%2BMS2BzJiwypJS%2Be8z%2B%2Fb5LRA2vx%2BJ%2FEGhhRG5%2BGQVtdHk3b6IV1ZXjjF3z4slkNMzBmzG3pSW61A4TNQ1SY233JRF6MQMeaFtAv%2BiOkgLdCP4%2BP4%2F0Hq9to6hmIxAChG8ZSTYznV%2FkbwcaOhQUy0a8ps4h6KHRL7ux9MPpVNnKra7ODWwxw1AC%2BcfCxEtVZXtDZosNbYIACgXpNrsod6drpSnOMOF87uP6ParabNalKppC3Bwh0zixyFIJ%2BBIuGwFmRfd51k7pAhv0O59v31jFJQ6yVM6ons51t45Yiv7jlEGcguhcG3dO6A4vXQ8pe%2Fcqa6wHIFLCHqN2ZJzsbRpQKfaDNqrmX4i8x7ZSO2h3ptV9%2FwOGEp5qKPAVast2Azp36rkW%2BNvL61Fri4JNm9sZWlKYlNRDordBdZ%2FD27Gm9c4H6slCak6rR6N3dx5KrmXNUDeM56AuCNipkC56n1wrXMh8dGoa7CRR5koFSP0kD9B%2ByrZ4SGudepamQS3yB1qOsvX9Xl1WJmBLNH42ueFh2rICihvVdP3kjM2UB22iqhBrSt5gJg%2FIrT0vTAP0cUPlAkFkVBPbOpVX%2BZLjQGF%2B3KmmlIbjXdKKLQ%2Fi18RevtAp6xuXIhP%2FOxjmuf4nsE2PyHJIz2RY%2B%2B%2BED%2Fprkj4euzcXr%2BhO6QfM0W3rqmAi30lLCtUxlVl%2FEGYCKMytwhWP4zCiZkNbh%2Ble%2F53YWoit9iqpo7%2FMsppdRFMyks31Vr5s8SzpHbyOW%2FWIuRudHSbuqHVZHtZFrkwO%2BbgRWHotPGeULSCf3JSQ3hr%2BoaXr01jmg0MCDC%2BOYooA%2BKz8ak5JiIeUwnNbqGDYWtdH3pjBUzDdye7RBjqyARkKxrNRJnHsdSWsDePcoNQ8ZBR4qy07PJD%2FP0p5yRdgU8bfIU%2FpabEV%2FyFMN6hBRUWQQFfq2BwfjOxNYk%2BOU2Q2BRxbILbznTNP8QPMuPHKFlp7PcJb%2Bo0%2FnH5gKaIhy7Lzo80bv7KctgwHEipnSS8z5XkWrsHc%2BX0FhKYnmQWTIFSGpUzjOrttWOX8Ea6BVgjsiktyr9VzU%2BJvMoTLbPQbQpXesvmm%2F69b38bfTvo2GsU%3D&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47UU2XXR6N6%2F20260624%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260624T101342Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=5a4948628f20cc393a150b624f8b28eb7e7fd5998d970e6ebebb453e414c8a24 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=IQoJb3JpZ2luX2VjEGoaCWV1LXdlc3QtMSJGMEQCICS0FFn1%2B%2Fzvc7haLFRWQY44hD33IrDbbqIPuqyiTWScAiAEZBvSDWqNAeWXKuO9guabncRs83F5SvMXcG6bcm5VvCq4BQgzEAUaDDI3MzU3MDE5NTQzMyIMMJgboLCWdy4H%2FLuyKpUF1wLQy38l0OcytnzlBo37I8x1ta%2BMS2BzJiwypJS%2Be8z%2B%2Fb5LRA2vx%2BJ%2FEGhhRG5%2BGQVtdHk3b6IV1ZXjjF3z4slkNMzBmzG3pSW61A4TNQ1SY233JRF6MQMeaFtAv%2BiOkgLdCP4%2BP4%2F0Hq9to6hmIxAChG8ZSTYznV%2FkbwcaOhQUy0a8ps4h6KHRL7ux9MPpVNnKra7ODWwxw1AC%2BcfCxEtVZXtDZosNbYIACgXpNrsod6drpSnOMOF87uP6ParabNalKppC3Bwh0zixyFIJ%2BBIuGwFmRfd51k7pAhv0O59v31jFJQ6yVM6ons51t45Yiv7jlEGcguhcG3dO6A4vXQ8pe%2Fcqa6wHIFLCHqN2ZJzsbRpQKfaDNqrmX4i8x7ZSO2h3ptV9%2FwOGEp5qKPAVast2Azp36rkW%2BNvL61Fri4JNm9sZWlKYlNRDordBdZ%2FD27Gm9c4H6slCak6rR6N3dx5KrmXNUDeM56AuCNipkC56n1wrXMh8dGoa7CRR5koFSP0kD9B%2ByrZ4SGudepamQS3yB1qOsvX9Xl1WJmBLNH42ueFh2rICihvVdP3kjM2UB22iqhBrSt5gJg%2FIrT0vTAP0cUPlAkFkVBPbOpVX%2BZLjQGF%2B3KmmlIbjXdKKLQ%2Fi18RevtAp6xuXIhP%2FOxjmuf4nsE2PyHJIz2RY%2B%2B%2BED%2Fprkj4euzcXr%2BhO6QfM0W3rqmAi30lLCtUxlVl%2FEGYCKMytwhWP4zCiZkNbh%2Ble%2F53YWoit9iqpo7%2FMsppdRFMyks31Vr5s8SzpHbyOW%2FWIuRudHSbuqHVZHtZFrkwO%2BbgRWHotPGeULSCf3JSQ3hr%2BoaXr01jmg0MCDC%2BOYooA%2BKz8ak5JiIeUwnNbqGDYWtdH3pjBUzDdye7RBjqyARkKxrNRJnHsdSWsDePcoNQ8ZBR4qy07PJD%2FP0p5yRdgU8bfIU%2FpabEV%2FyFMN6hBRUWQQFfq2BwfjOxNYk%2BOU2Q2BRxbILbznTNP8QPMuPHKFlp7PcJb%2Bo0%2FnH5gKaIhy7Lzo80bv7KctgwHEipnSS8z5XkWrsHc%2BX0FhKYnmQWTIFSGpUzjOrttWOX8Ea6BVgjsiktyr9VzU%2BJvMoTLbPQbQpXesvmm%2F69b38bfTvo2GsU%3D&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47UU2XXR6N6%2F20260624%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260624T101342Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=5a4948628f20cc393a150b624f8b28eb7e7fd5998d970e6ebebb453e414c8a24\" 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=IQoJb3JpZ2luX2VjEGoaCWV1LXdlc3QtMSJGMEQCICS0FFn1%2B%2Fzvc7haLFRWQY44hD33IrDbbqIPuqyiTWScAiAEZBvSDWqNAeWXKuO9guabncRs83F5SvMXcG6bcm5VvCq4BQgzEAUaDDI3MzU3MDE5NTQzMyIMMJgboLCWdy4H%2FLuyKpUF1wLQy38l0OcytnzlBo37I8x1ta%2BMS2BzJiwypJS%2Be8z%2B%2Fb5LRA2vx%2BJ%2FEGhhRG5%2BGQVtdHk3b6IV1ZXjjF3z4slkNMzBmzG3pSW61A4TNQ1SY233JRF6MQMeaFtAv%2BiOkgLdCP4%2BP4%2F0Hq9to6hmIxAChG8ZSTYznV%2FkbwcaOhQUy0a8ps4h6KHRL7ux9MPpVNnKra7ODWwxw1AC%2BcfCxEtVZXtDZosNbYIACgXpNrsod6drpSnOMOF87uP6ParabNalKppC3Bwh0zixyFIJ%2BBIuGwFmRfd51k7pAhv0O59v31jFJQ6yVM6ons51t45Yiv7jlEGcguhcG3dO6A4vXQ8pe%2Fcqa6wHIFLCHqN2ZJzsbRpQKfaDNqrmX4i8x7ZSO2h3ptV9%2FwOGEp5qKPAVast2Azp36rkW%2BNvL61Fri4JNm9sZWlKYlNRDordBdZ%2FD27Gm9c4H6slCak6rR6N3dx5KrmXNUDeM56AuCNipkC56n1wrXMh8dGoa7CRR5koFSP0kD9B%2ByrZ4SGudepamQS3yB1qOsvX9Xl1WJmBLNH42ueFh2rICihvVdP3kjM2UB22iqhBrSt5gJg%2FIrT0vTAP0cUPlAkFkVBPbOpVX%2BZLjQGF%2B3KmmlIbjXdKKLQ%2Fi18RevtAp6xuXIhP%2FOxjmuf4nsE2PyHJIz2RY%2B%2B%2BED%2Fprkj4euzcXr%2BhO6QfM0W3rqmAi30lLCtUxlVl%2FEGYCKMytwhWP4zCiZkNbh%2Ble%2F53YWoit9iqpo7%2FMsppdRFMyks31Vr5s8SzpHbyOW%2FWIuRudHSbuqHVZHtZFrkwO%2BbgRWHotPGeULSCf3JSQ3hr%2BoaXr01jmg0MCDC%2BOYooA%2BKz8ak5JiIeUwnNbqGDYWtdH3pjBUzDdye7RBjqyARkKxrNRJnHsdSWsDePcoNQ8ZBR4qy07PJD%2FP0p5yRdgU8bfIU%2FpabEV%2FyFMN6hBRUWQQFfq2BwfjOxNYk%2BOU2Q2BRxbILbznTNP8QPMuPHKFlp7PcJb%2Bo0%2FnH5gKaIhy7Lzo80bv7KctgwHEipnSS8z5XkWrsHc%2BX0FhKYnmQWTIFSGpUzjOrttWOX8Ea6BVgjsiktyr9VzU%2BJvMoTLbPQbQpXesvmm%2F69b38bfTvo2GsU%3D&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47UU2XXR6N6%2F20260624%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260624T101342Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=5f6e363600599f21f8c9f0452179d6cedf02cc1047fa46d9f4f7fcf961956114\" 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=IQoJb3JpZ2luX2VjEGoaCWV1LXdlc3QtMSJGMEQCICS0FFn1%2B%2Fzvc7haLFRWQY44hD33IrDbbqIPuqyiTWScAiAEZBvSDWqNAeWXKuO9guabncRs83F5SvMXcG6bcm5VvCq4BQgzEAUaDDI3MzU3MDE5NTQzMyIMMJgboLCWdy4H%2FLuyKpUF1wLQy38l0OcytnzlBo37I8x1ta%2BMS2BzJiwypJS%2Be8z%2B%2Fb5LRA2vx%2BJ%2FEGhhRG5%2BGQVtdHk3b6IV1ZXjjF3z4slkNMzBmzG3pSW61A4TNQ1SY233JRF6MQMeaFtAv%2BiOkgLdCP4%2BP4%2F0Hq9to6hmIxAChG8ZSTYznV%2FkbwcaOhQUy0a8ps4h6KHRL7ux9MPpVNnKra7ODWwxw1AC%2BcfCxEtVZXtDZosNbYIACgXpNrsod6drpSnOMOF87uP6ParabNalKppC3Bwh0zixyFIJ%2BBIuGwFmRfd51k7pAhv0O59v31jFJQ6yVM6ons51t45Yiv7jlEGcguhcG3dO6A4vXQ8pe%2Fcqa6wHIFLCHqN2ZJzsbRpQKfaDNqrmX4i8x7ZSO2h3ptV9%2FwOGEp5qKPAVast2Azp36rkW%2BNvL61Fri4JNm9sZWlKYlNRDordBdZ%2FD27Gm9c4H6slCak6rR6N3dx5KrmXNUDeM56AuCNipkC56n1wrXMh8dGoa7CRR5koFSP0kD9B%2ByrZ4SGudepamQS3yB1qOsvX9Xl1WJmBLNH42ueFh2rICihvVdP3kjM2UB22iqhBrSt5gJg%2FIrT0vTAP0cUPlAkFkVBPbOpVX%2BZLjQGF%2B3KmmlIbjXdKKLQ%2Fi18RevtAp6xuXIhP%2FOxjmuf4nsE2PyHJIz2RY%2B%2B%2BED%2Fprkj4euzcXr%2BhO6QfM0W3rqmAi30lLCtUxlVl%2FEGYCKMytwhWP4zCiZkNbh%2Ble%2F53YWoit9iqpo7%2FMsppdRFMyks31Vr5s8SzpHbyOW%2FWIuRudHSbuqHVZHtZFrkwO%2BbgRWHotPGeULSCf3JSQ3hr%2BoaXr01jmg0MCDC%2BOYooA%2BKz8ak5JiIeUwnNbqGDYWtdH3pjBUzDdye7RBjqyARkKxrNRJnHsdSWsDePcoNQ8ZBR4qy07PJD%2FP0p5yRdgU8bfIU%2FpabEV%2FyFMN6hBRUWQQFfq2BwfjOxNYk%2BOU2Q2BRxbILbznTNP8QPMuPHKFlp7PcJb%2Bo0%2FnH5gKaIhy7Lzo80bv7KctgwHEipnSS8z5XkWrsHc%2BX0FhKYnmQWTIFSGpUzjOrttWOX8Ea6BVgjsiktyr9VzU%2BJvMoTLbPQbQpXesvmm%2F69b38bfTvo2GsU%3D&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47UU2XXR6N6%2F20260624%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260624T101342Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=5f6e363600599f21f8c9f0452179d6cedf02cc1047fa46d9f4f7fcf961956114 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=IQoJb3JpZ2luX2VjEGoaCWV1LXdlc3QtMSJGMEQCICS0FFn1%2B%2Fzvc7haLFRWQY44hD33IrDbbqIPuqyiTWScAiAEZBvSDWqNAeWXKuO9guabncRs83F5SvMXcG6bcm5VvCq4BQgzEAUaDDI3MzU3MDE5NTQzMyIMMJgboLCWdy4H%2FLuyKpUF1wLQy38l0OcytnzlBo37I8x1ta%2BMS2BzJiwypJS%2Be8z%2B%2Fb5LRA2vx%2BJ%2FEGhhRG5%2BGQVtdHk3b6IV1ZXjjF3z4slkNMzBmzG3pSW61A4TNQ1SY233JRF6MQMeaFtAv%2BiOkgLdCP4%2BP4%2F0Hq9to6hmIxAChG8ZSTYznV%2FkbwcaOhQUy0a8ps4h6KHRL7ux9MPpVNnKra7ODWwxw1AC%2BcfCxEtVZXtDZosNbYIACgXpNrsod6drpSnOMOF87uP6ParabNalKppC3Bwh0zixyFIJ%2BBIuGwFmRfd51k7pAhv0O59v31jFJQ6yVM6ons51t45Yiv7jlEGcguhcG3dO6A4vXQ8pe%2Fcqa6wHIFLCHqN2ZJzsbRpQKfaDNqrmX4i8x7ZSO2h3ptV9%2FwOGEp5qKPAVast2Azp36rkW%2BNvL61Fri4JNm9sZWlKYlNRDordBdZ%2FD27Gm9c4H6slCak6rR6N3dx5KrmXNUDeM56AuCNipkC56n1wrXMh8dGoa7CRR5koFSP0kD9B%2ByrZ4SGudepamQS3yB1qOsvX9Xl1WJmBLNH42ueFh2rICihvVdP3kjM2UB22iqhBrSt5gJg%2FIrT0vTAP0cUPlAkFkVBPbOpVX%2BZLjQGF%2B3KmmlIbjXdKKLQ%2Fi18RevtAp6xuXIhP%2FOxjmuf4nsE2PyHJIz2RY%2B%2B%2BED%2Fprkj4euzcXr%2BhO6QfM0W3rqmAi30lLCtUxlVl%2FEGYCKMytwhWP4zCiZkNbh%2Ble%2F53YWoit9iqpo7%2FMsppdRFMyks31Vr5s8SzpHbyOW%2FWIuRudHSbuqHVZHtZFrkwO%2BbgRWHotPGeULSCf3JSQ3hr%2BoaXr01jmg0MCDC%2BOYooA%2BKz8ak5JiIeUwnNbqGDYWtdH3pjBUzDdye7RBjqyARkKxrNRJnHsdSWsDePcoNQ8ZBR4qy07PJD%2FP0p5yRdgU8bfIU%2FpabEV%2FyFMN6hBRUWQQFfq2BwfjOxNYk%2BOU2Q2BRxbILbznTNP8QPMuPHKFlp7PcJb%2Bo0%2FnH5gKaIhy7Lzo80bv7KctgwHEipnSS8z5XkWrsHc%2BX0FhKYnmQWTIFSGpUzjOrttWOX8Ea6BVgjsiktyr9VzU%2BJvMoTLbPQbQpXesvmm%2F69b38bfTvo2GsU%3D&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47UU2XXR6N6%2F20260624%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260624T101342Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=1f27c17c4ab1f0c443961c34c278458065a4d72ddbbf9fc843e6659289c0b0ac 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=IQoJb3JpZ2luX2VjEGoaCWV1LXdlc3QtMSJGMEQCICS0FFn1%2B%2Fzvc7haLFRWQY44hD33IrDbbqIPuqyiTWScAiAEZBvSDWqNAeWXKuO9guabncRs83F5SvMXcG6bcm5VvCq4BQgzEAUaDDI3MzU3MDE5NTQzMyIMMJgboLCWdy4H%2FLuyKpUF1wLQy38l0OcytnzlBo37I8x1ta%2BMS2BzJiwypJS%2Be8z%2B%2Fb5LRA2vx%2BJ%2FEGhhRG5%2BGQVtdHk3b6IV1ZXjjF3z4slkNMzBmzG3pSW61A4TNQ1SY233JRF6MQMeaFtAv%2BiOkgLdCP4%2BP4%2F0Hq9to6hmIxAChG8ZSTYznV%2FkbwcaOhQUy0a8ps4h6KHRL7ux9MPpVNnKra7ODWwxw1AC%2BcfCxEtVZXtDZosNbYIACgXpNrsod6drpSnOMOF87uP6ParabNalKppC3Bwh0zixyFIJ%2BBIuGwFmRfd51k7pAhv0O59v31jFJQ6yVM6ons51t45Yiv7jlEGcguhcG3dO6A4vXQ8pe%2Fcqa6wHIFLCHqN2ZJzsbRpQKfaDNqrmX4i8x7ZSO2h3ptV9%2FwOGEp5qKPAVast2Azp36rkW%2BNvL61Fri4JNm9sZWlKYlNRDordBdZ%2FD27Gm9c4H6slCak6rR6N3dx5KrmXNUDeM56AuCNipkC56n1wrXMh8dGoa7CRR5koFSP0kD9B%2ByrZ4SGudepamQS3yB1qOsvX9Xl1WJmBLNH42ueFh2rICihvVdP3kjM2UB22iqhBrSt5gJg%2FIrT0vTAP0cUPlAkFkVBPbOpVX%2BZLjQGF%2B3KmmlIbjXdKKLQ%2Fi18RevtAp6xuXIhP%2FOxjmuf4nsE2PyHJIz2RY%2B%2B%2BED%2Fprkj4euzcXr%2BhO6QfM0W3rqmAi30lLCtUxlVl%2FEGYCKMytwhWP4zCiZkNbh%2Ble%2F53YWoit9iqpo7%2FMsppdRFMyks31Vr5s8SzpHbyOW%2FWIuRudHSbuqHVZHtZFrkwO%2BbgRWHotPGeULSCf3JSQ3hr%2BoaXr01jmg0MCDC%2BOYooA%2BKz8ak5JiIeUwnNbqGDYWtdH3pjBUzDdye7RBjqyARkKxrNRJnHsdSWsDePcoNQ8ZBR4qy07PJD%2FP0p5yRdgU8bfIU%2FpabEV%2FyFMN6hBRUWQQFfq2BwfjOxNYk%2BOU2Q2BRxbILbznTNP8QPMuPHKFlp7PcJb%2Bo0%2FnH5gKaIhy7Lzo80bv7KctgwHEipnSS8z5XkWrsHc%2BX0FhKYnmQWTIFSGpUzjOrttWOX8Ea6BVgjsiktyr9VzU%2BJvMoTLbPQbQpXesvmm%2F69b38bfTvo2GsU%3D&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47UU2XXR6N6%2F20260624%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260624T101342Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=1f27c17c4ab1f0c443961c34c278458065a4d72ddbbf9fc843e6659289c0b0ac\" 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=IQoJb3JpZ2luX2VjEGoaCWV1LXdlc3QtMSJGMEQCICS0FFn1%2B%2Fzvc7haLFRWQY44hD33IrDbbqIPuqyiTWScAiAEZBvSDWqNAeWXKuO9guabncRs83F5SvMXcG6bcm5VvCq4BQgzEAUaDDI3MzU3MDE5NTQzMyIMMJgboLCWdy4H%2FLuyKpUF1wLQy38l0OcytnzlBo37I8x1ta%2BMS2BzJiwypJS%2Be8z%2B%2Fb5LRA2vx%2BJ%2FEGhhRG5%2BGQVtdHk3b6IV1ZXjjF3z4slkNMzBmzG3pSW61A4TNQ1SY233JRF6MQMeaFtAv%2BiOkgLdCP4%2BP4%2F0Hq9to6hmIxAChG8ZSTYznV%2FkbwcaOhQUy0a8ps4h6KHRL7ux9MPpVNnKra7ODWwxw1AC%2BcfCxEtVZXtDZosNbYIACgXpNrsod6drpSnOMOF87uP6ParabNalKppC3Bwh0zixyFIJ%2BBIuGwFmRfd51k7pAhv0O59v31jFJQ6yVM6ons51t45Yiv7jlEGcguhcG3dO6A4vXQ8pe%2Fcqa6wHIFLCHqN2ZJzsbRpQKfaDNqrmX4i8x7ZSO2h3ptV9%2FwOGEp5qKPAVast2Azp36rkW%2BNvL61Fri4JNm9sZWlKYlNRDordBdZ%2FD27Gm9c4H6slCak6rR6N3dx5KrmXNUDeM56AuCNipkC56n1wrXMh8dGoa7CRR5koFSP0kD9B%2ByrZ4SGudepamQS3yB1qOsvX9Xl1WJmBLNH42ueFh2rICihvVdP3kjM2UB22iqhBrSt5gJg%2FIrT0vTAP0cUPlAkFkVBPbOpVX%2BZLjQGF%2B3KmmlIbjXdKKLQ%2Fi18RevtAp6xuXIhP%2FOxjmuf4nsE2PyHJIz2RY%2B%2B%2BED%2Fprkj4euzcXr%2BhO6QfM0W3rqmAi30lLCtUxlVl%2FEGYCKMytwhWP4zCiZkNbh%2Ble%2F53YWoit9iqpo7%2FMsppdRFMyks31Vr5s8SzpHbyOW%2FWIuRudHSbuqHVZHtZFrkwO%2BbgRWHotPGeULSCf3JSQ3hr%2BoaXr01jmg0MCDC%2BOYooA%2BKz8ak5JiIeUwnNbqGDYWtdH3pjBUzDdye7RBjqyARkKxrNRJnHsdSWsDePcoNQ8ZBR4qy07PJD%2FP0p5yRdgU8bfIU%2FpabEV%2FyFMN6hBRUWQQFfq2BwfjOxNYk%2BOU2Q2BRxbILbznTNP8QPMuPHKFlp7PcJb%2Bo0%2FnH5gKaIhy7Lzo80bv7KctgwHEipnSS8z5XkWrsHc%2BX0FhKYnmQWTIFSGpUzjOrttWOX8Ea6BVgjsiktyr9VzU%2BJvMoTLbPQbQpXesvmm%2F69b38bfTvo2GsU%3D&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47UU2XXR6N6%2F20260624%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260624T101342Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=b270f53b61bb4974a8b964d63da561e78f1a1a8e6266bc9d64e262177d37cf92\" 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=IQoJb3JpZ2luX2VjEGoaCWV1LXdlc3QtMSJGMEQCICS0FFn1%2B%2Fzvc7haLFRWQY44hD33IrDbbqIPuqyiTWScAiAEZBvSDWqNAeWXKuO9guabncRs83F5SvMXcG6bcm5VvCq4BQgzEAUaDDI3MzU3MDE5NTQzMyIMMJgboLCWdy4H%2FLuyKpUF1wLQy38l0OcytnzlBo37I8x1ta%2BMS2BzJiwypJS%2Be8z%2B%2Fb5LRA2vx%2BJ%2FEGhhRG5%2BGQVtdHk3b6IV1ZXjjF3z4slkNMzBmzG3pSW61A4TNQ1SY233JRF6MQMeaFtAv%2BiOkgLdCP4%2BP4%2F0Hq9to6hmIxAChG8ZSTYznV%2FkbwcaOhQUy0a8ps4h6KHRL7ux9MPpVNnKra7ODWwxw1AC%2BcfCxEtVZXtDZosNbYIACgXpNrsod6drpSnOMOF87uP6ParabNalKppC3Bwh0zixyFIJ%2BBIuGwFmRfd51k7pAhv0O59v31jFJQ6yVM6ons51t45Yiv7jlEGcguhcG3dO6A4vXQ8pe%2Fcqa6wHIFLCHqN2ZJzsbRpQKfaDNqrmX4i8x7ZSO2h3ptV9%2FwOGEp5qKPAVast2Azp36rkW%2BNvL61Fri4JNm9sZWlKYlNRDordBdZ%2FD27Gm9c4H6slCak6rR6N3dx5KrmXNUDeM56AuCNipkC56n1wrXMh8dGoa7CRR5koFSP0kD9B%2ByrZ4SGudepamQS3yB1qOsvX9Xl1WJmBLNH42ueFh2rICihvVdP3kjM2UB22iqhBrSt5gJg%2FIrT0vTAP0cUPlAkFkVBPbOpVX%2BZLjQGF%2B3KmmlIbjXdKKLQ%2Fi18RevtAp6xuXIhP%2FOxjmuf4nsE2PyHJIz2RY%2B%2B%2BED%2Fprkj4euzcXr%2BhO6QfM0W3rqmAi30lLCtUxlVl%2FEGYCKMytwhWP4zCiZkNbh%2Ble%2F53YWoit9iqpo7%2FMsppdRFMyks31Vr5s8SzpHbyOW%2FWIuRudHSbuqHVZHtZFrkwO%2BbgRWHotPGeULSCf3JSQ3hr%2BoaXr01jmg0MCDC%2BOYooA%2BKz8ak5JiIeUwnNbqGDYWtdH3pjBUzDdye7RBjqyARkKxrNRJnHsdSWsDePcoNQ8ZBR4qy07PJD%2FP0p5yRdgU8bfIU%2FpabEV%2FyFMN6hBRUWQQFfq2BwfjOxNYk%2BOU2Q2BRxbILbznTNP8QPMuPHKFlp7PcJb%2Bo0%2FnH5gKaIhy7Lzo80bv7KctgwHEipnSS8z5XkWrsHc%2BX0FhKYnmQWTIFSGpUzjOrttWOX8Ea6BVgjsiktyr9VzU%2BJvMoTLbPQbQpXesvmm%2F69b38bfTvo2GsU%3D&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47UU2XXR6N6%2F20260624%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260624T101342Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=b270f53b61bb4974a8b964d63da561e78f1a1a8e6266bc9d64e262177d37cf92 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=IQoJb3JpZ2luX2VjEGoaCWV1LXdlc3QtMSJGMEQCICS0FFn1%2B%2Fzvc7haLFRWQY44hD33IrDbbqIPuqyiTWScAiAEZBvSDWqNAeWXKuO9guabncRs83F5SvMXcG6bcm5VvCq4BQgzEAUaDDI3MzU3MDE5NTQzMyIMMJgboLCWdy4H%2FLuyKpUF1wLQy38l0OcytnzlBo37I8x1ta%2BMS2BzJiwypJS%2Be8z%2B%2Fb5LRA2vx%2BJ%2FEGhhRG5%2BGQVtdHk3b6IV1ZXjjF3z4slkNMzBmzG3pSW61A4TNQ1SY233JRF6MQMeaFtAv%2BiOkgLdCP4%2BP4%2F0Hq9to6hmIxAChG8ZSTYznV%2FkbwcaOhQUy0a8ps4h6KHRL7ux9MPpVNnKra7ODWwxw1AC%2BcfCxEtVZXtDZosNbYIACgXpNrsod6drpSnOMOF87uP6ParabNalKppC3Bwh0zixyFIJ%2BBIuGwFmRfd51k7pAhv0O59v31jFJQ6yVM6ons51t45Yiv7jlEGcguhcG3dO6A4vXQ8pe%2Fcqa6wHIFLCHqN2ZJzsbRpQKfaDNqrmX4i8x7ZSO2h3ptV9%2FwOGEp5qKPAVast2Azp36rkW%2BNvL61Fri4JNm9sZWlKYlNRDordBdZ%2FD27Gm9c4H6slCak6rR6N3dx5KrmXNUDeM56AuCNipkC56n1wrXMh8dGoa7CRR5koFSP0kD9B%2ByrZ4SGudepamQS3yB1qOsvX9Xl1WJmBLNH42ueFh2rICihvVdP3kjM2UB22iqhBrSt5gJg%2FIrT0vTAP0cUPlAkFkVBPbOpVX%2BZLjQGF%2B3KmmlIbjXdKKLQ%2Fi18RevtAp6xuXIhP%2FOxjmuf4nsE2PyHJIz2RY%2B%2B%2BED%2Fprkj4euzcXr%2BhO6QfM0W3rqmAi30lLCtUxlVl%2FEGYCKMytwhWP4zCiZkNbh%2Ble%2F53YWoit9iqpo7%2FMsppdRFMyks31Vr5s8SzpHbyOW%2FWIuRudHSbuqHVZHtZFrkwO%2BbgRWHotPGeULSCf3JSQ3hr%2BoaXr01jmg0MCDC%2BOYooA%2BKz8ak5JiIeUwnNbqGDYWtdH3pjBUzDdye7RBjqyARkKxrNRJnHsdSWsDePcoNQ8ZBR4qy07PJD%2FP0p5yRdgU8bfIU%2FpabEV%2FyFMN6hBRUWQQFfq2BwfjOxNYk%2BOU2Q2BRxbILbznTNP8QPMuPHKFlp7PcJb%2Bo0%2FnH5gKaIhy7Lzo80bv7KctgwHEipnSS8z5XkWrsHc%2BX0FhKYnmQWTIFSGpUzjOrttWOX8Ea6BVgjsiktyr9VzU%2BJvMoTLbPQbQpXesvmm%2F69b38bfTvo2GsU%3D&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47UU2XXR6N6%2F20260624%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260624T101342Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=15af28b4a14fabe9dfb2e02130d179f653a5fc12b7622d4cb1f588825ea4e734 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=IQoJb3JpZ2luX2VjEGoaCWV1LXdlc3QtMSJGMEQCICS0FFn1%2B%2Fzvc7haLFRWQY44hD33IrDbbqIPuqyiTWScAiAEZBvSDWqNAeWXKuO9guabncRs83F5SvMXcG6bcm5VvCq4BQgzEAUaDDI3MzU3MDE5NTQzMyIMMJgboLCWdy4H%2FLuyKpUF1wLQy38l0OcytnzlBo37I8x1ta%2BMS2BzJiwypJS%2Be8z%2B%2Fb5LRA2vx%2BJ%2FEGhhRG5%2BGQVtdHk3b6IV1ZXjjF3z4slkNMzBmzG3pSW61A4TNQ1SY233JRF6MQMeaFtAv%2BiOkgLdCP4%2BP4%2F0Hq9to6hmIxAChG8ZSTYznV%2FkbwcaOhQUy0a8ps4h6KHRL7ux9MPpVNnKra7ODWwxw1AC%2BcfCxEtVZXtDZosNbYIACgXpNrsod6drpSnOMOF87uP6ParabNalKppC3Bwh0zixyFIJ%2BBIuGwFmRfd51k7pAhv0O59v31jFJQ6yVM6ons51t45Yiv7jlEGcguhcG3dO6A4vXQ8pe%2Fcqa6wHIFLCHqN2ZJzsbRpQKfaDNqrmX4i8x7ZSO2h3ptV9%2FwOGEp5qKPAVast2Azp36rkW%2BNvL61Fri4JNm9sZWlKYlNRDordBdZ%2FD27Gm9c4H6slCak6rR6N3dx5KrmXNUDeM56AuCNipkC56n1wrXMh8dGoa7CRR5koFSP0kD9B%2ByrZ4SGudepamQS3yB1qOsvX9Xl1WJmBLNH42ueFh2rICihvVdP3kjM2UB22iqhBrSt5gJg%2FIrT0vTAP0cUPlAkFkVBPbOpVX%2BZLjQGF%2B3KmmlIbjXdKKLQ%2Fi18RevtAp6xuXIhP%2FOxjmuf4nsE2PyHJIz2RY%2B%2B%2BED%2Fprkj4euzcXr%2BhO6QfM0W3rqmAi30lLCtUxlVl%2FEGYCKMytwhWP4zCiZkNbh%2Ble%2F53YWoit9iqpo7%2FMsppdRFMyks31Vr5s8SzpHbyOW%2FWIuRudHSbuqHVZHtZFrkwO%2BbgRWHotPGeULSCf3JSQ3hr%2BoaXr01jmg0MCDC%2BOYooA%2BKz8ak5JiIeUwnNbqGDYWtdH3pjBUzDdye7RBjqyARkKxrNRJnHsdSWsDePcoNQ8ZBR4qy07PJD%2FP0p5yRdgU8bfIU%2FpabEV%2FyFMN6hBRUWQQFfq2BwfjOxNYk%2BOU2Q2BRxbILbznTNP8QPMuPHKFlp7PcJb%2Bo0%2FnH5gKaIhy7Lzo80bv7KctgwHEipnSS8z5XkWrsHc%2BX0FhKYnmQWTIFSGpUzjOrttWOX8Ea6BVgjsiktyr9VzU%2BJvMoTLbPQbQpXesvmm%2F69b38bfTvo2GsU%3D&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47UU2XXR6N6%2F20260624%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260624T101342Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=15af28b4a14fabe9dfb2e02130d179f653a5fc12b7622d4cb1f588825ea4e734\" 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=IQoJb3JpZ2luX2VjEGoaCWV1LXdlc3QtMSJGMEQCICS0FFn1%2B%2Fzvc7haLFRWQY44hD33IrDbbqIPuqyiTWScAiAEZBvSDWqNAeWXKuO9guabncRs83F5SvMXcG6bcm5VvCq4BQgzEAUaDDI3MzU3MDE5NTQzMyIMMJgboLCWdy4H%2FLuyKpUF1wLQy38l0OcytnzlBo37I8x1ta%2BMS2BzJiwypJS%2Be8z%2B%2Fb5LRA2vx%2BJ%2FEGhhRG5%2BGQVtdHk3b6IV1ZXjjF3z4slkNMzBmzG3pSW61A4TNQ1SY233JRF6MQMeaFtAv%2BiOkgLdCP4%2BP4%2F0Hq9to6hmIxAChG8ZSTYznV%2FkbwcaOhQUy0a8ps4h6KHRL7ux9MPpVNnKra7ODWwxw1AC%2BcfCxEtVZXtDZosNbYIACgXpNrsod6drpSnOMOF87uP6ParabNalKppC3Bwh0zixyFIJ%2BBIuGwFmRfd51k7pAhv0O59v31jFJQ6yVM6ons51t45Yiv7jlEGcguhcG3dO6A4vXQ8pe%2Fcqa6wHIFLCHqN2ZJzsbRpQKfaDNqrmX4i8x7ZSO2h3ptV9%2FwOGEp5qKPAVast2Azp36rkW%2BNvL61Fri4JNm9sZWlKYlNRDordBdZ%2FD27Gm9c4H6slCak6rR6N3dx5KrmXNUDeM56AuCNipkC56n1wrXMh8dGoa7CRR5koFSP0kD9B%2ByrZ4SGudepamQS3yB1qOsvX9Xl1WJmBLNH42ueFh2rICihvVdP3kjM2UB22iqhBrSt5gJg%2FIrT0vTAP0cUPlAkFkVBPbOpVX%2BZLjQGF%2B3KmmlIbjXdKKLQ%2Fi18RevtAp6xuXIhP%2FOxjmuf4nsE2PyHJIz2RY%2B%2B%2BED%2Fprkj4euzcXr%2BhO6QfM0W3rqmAi30lLCtUxlVl%2FEGYCKMytwhWP4zCiZkNbh%2Ble%2F53YWoit9iqpo7%2FMsppdRFMyks31Vr5s8SzpHbyOW%2FWIuRudHSbuqHVZHtZFrkwO%2BbgRWHotPGeULSCf3JSQ3hr%2BoaXr01jmg0MCDC%2BOYooA%2BKz8ak5JiIeUwnNbqGDYWtdH3pjBUzDdye7RBjqyARkKxrNRJnHsdSWsDePcoNQ8ZBR4qy07PJD%2FP0p5yRdgU8bfIU%2FpabEV%2FyFMN6hBRUWQQFfq2BwfjOxNYk%2BOU2Q2BRxbILbznTNP8QPMuPHKFlp7PcJb%2Bo0%2FnH5gKaIhy7Lzo80bv7KctgwHEipnSS8z5XkWrsHc%2BX0FhKYnmQWTIFSGpUzjOrttWOX8Ea6BVgjsiktyr9VzU%2BJvMoTLbPQbQpXesvmm%2F69b38bfTvo2GsU%3D&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47UU2XXR6N6%2F20260624%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260624T101342Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=f76137381cf2364f19b906341939dc9703ab9591e93c07858d023c29045461c5\" 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=IQoJb3JpZ2luX2VjEGoaCWV1LXdlc3QtMSJGMEQCICS0FFn1%2B%2Fzvc7haLFRWQY44hD33IrDbbqIPuqyiTWScAiAEZBvSDWqNAeWXKuO9guabncRs83F5SvMXcG6bcm5VvCq4BQgzEAUaDDI3MzU3MDE5NTQzMyIMMJgboLCWdy4H%2FLuyKpUF1wLQy38l0OcytnzlBo37I8x1ta%2BMS2BzJiwypJS%2Be8z%2B%2Fb5LRA2vx%2BJ%2FEGhhRG5%2BGQVtdHk3b6IV1ZXjjF3z4slkNMzBmzG3pSW61A4TNQ1SY233JRF6MQMeaFtAv%2BiOkgLdCP4%2BP4%2F0Hq9to6hmIxAChG8ZSTYznV%2FkbwcaOhQUy0a8ps4h6KHRL7ux9MPpVNnKra7ODWwxw1AC%2BcfCxEtVZXtDZosNbYIACgXpNrsod6drpSnOMOF87uP6ParabNalKppC3Bwh0zixyFIJ%2BBIuGwFmRfd51k7pAhv0O59v31jFJQ6yVM6ons51t45Yiv7jlEGcguhcG3dO6A4vXQ8pe%2Fcqa6wHIFLCHqN2ZJzsbRpQKfaDNqrmX4i8x7ZSO2h3ptV9%2FwOGEp5qKPAVast2Azp36rkW%2BNvL61Fri4JNm9sZWlKYlNRDordBdZ%2FD27Gm9c4H6slCak6rR6N3dx5KrmXNUDeM56AuCNipkC56n1wrXMh8dGoa7CRR5koFSP0kD9B%2ByrZ4SGudepamQS3yB1qOsvX9Xl1WJmBLNH42ueFh2rICihvVdP3kjM2UB22iqhBrSt5gJg%2FIrT0vTAP0cUPlAkFkVBPbOpVX%2BZLjQGF%2B3KmmlIbjXdKKLQ%2Fi18RevtAp6xuXIhP%2FOxjmuf4nsE2PyHJIz2RY%2B%2B%2BED%2Fprkj4euzcXr%2BhO6QfM0W3rqmAi30lLCtUxlVl%2FEGYCKMytwhWP4zCiZkNbh%2Ble%2F53YWoit9iqpo7%2FMsppdRFMyks31Vr5s8SzpHbyOW%2FWIuRudHSbuqHVZHtZFrkwO%2BbgRWHotPGeULSCf3JSQ3hr%2BoaXr01jmg0MCDC%2BOYooA%2BKz8ak5JiIeUwnNbqGDYWtdH3pjBUzDdye7RBjqyARkKxrNRJnHsdSWsDePcoNQ8ZBR4qy07PJD%2FP0p5yRdgU8bfIU%2FpabEV%2FyFMN6hBRUWQQFfq2BwfjOxNYk%2BOU2Q2BRxbILbznTNP8QPMuPHKFlp7PcJb%2Bo0%2FnH5gKaIhy7Lzo80bv7KctgwHEipnSS8z5XkWrsHc%2BX0FhKYnmQWTIFSGpUzjOrttWOX8Ea6BVgjsiktyr9VzU%2BJvMoTLbPQbQpXesvmm%2F69b38bfTvo2GsU%3D&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47UU2XXR6N6%2F20260624%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260624T101342Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=f76137381cf2364f19b906341939dc9703ab9591e93c07858d023c29045461c5 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=IQoJb3JpZ2luX2VjEGoaCWV1LXdlc3QtMSJGMEQCICS0FFn1%2B%2Fzvc7haLFRWQY44hD33IrDbbqIPuqyiTWScAiAEZBvSDWqNAeWXKuO9guabncRs83F5SvMXcG6bcm5VvCq4BQgzEAUaDDI3MzU3MDE5NTQzMyIMMJgboLCWdy4H%2FLuyKpUF1wLQy38l0OcytnzlBo37I8x1ta%2BMS2BzJiwypJS%2Be8z%2B%2Fb5LRA2vx%2BJ%2FEGhhRG5%2BGQVtdHk3b6IV1ZXjjF3z4slkNMzBmzG3pSW61A4TNQ1SY233JRF6MQMeaFtAv%2BiOkgLdCP4%2BP4%2F0Hq9to6hmIxAChG8ZSTYznV%2FkbwcaOhQUy0a8ps4h6KHRL7ux9MPpVNnKra7ODWwxw1AC%2BcfCxEtVZXtDZosNbYIACgXpNrsod6drpSnOMOF87uP6ParabNalKppC3Bwh0zixyFIJ%2BBIuGwFmRfd51k7pAhv0O59v31jFJQ6yVM6ons51t45Yiv7jlEGcguhcG3dO6A4vXQ8pe%2Fcqa6wHIFLCHqN2ZJzsbRpQKfaDNqrmX4i8x7ZSO2h3ptV9%2FwOGEp5qKPAVast2Azp36rkW%2BNvL61Fri4JNm9sZWlKYlNRDordBdZ%2FD27Gm9c4H6slCak6rR6N3dx5KrmXNUDeM56AuCNipkC56n1wrXMh8dGoa7CRR5koFSP0kD9B%2ByrZ4SGudepamQS3yB1qOsvX9Xl1WJmBLNH42ueFh2rICihvVdP3kjM2UB22iqhBrSt5gJg%2FIrT0vTAP0cUPlAkFkVBPbOpVX%2BZLjQGF%2B3KmmlIbjXdKKLQ%2Fi18RevtAp6xuXIhP%2FOxjmuf4nsE2PyHJIz2RY%2B%2B%2BED%2Fprkj4euzcXr%2BhO6QfM0W3rqmAi30lLCtUxlVl%2FEGYCKMytwhWP4zCiZkNbh%2Ble%2F53YWoit9iqpo7%2FMsppdRFMyks31Vr5s8SzpHbyOW%2FWIuRudHSbuqHVZHtZFrkwO%2BbgRWHotPGeULSCf3JSQ3hr%2BoaXr01jmg0MCDC%2BOYooA%2BKz8ak5JiIeUwnNbqGDYWtdH3pjBUzDdye7RBjqyARkKxrNRJnHsdSWsDePcoNQ8ZBR4qy07PJD%2FP0p5yRdgU8bfIU%2FpabEV%2FyFMN6hBRUWQQFfq2BwfjOxNYk%2BOU2Q2BRxbILbznTNP8QPMuPHKFlp7PcJb%2Bo0%2FnH5gKaIhy7Lzo80bv7KctgwHEipnSS8z5XkWrsHc%2BX0FhKYnmQWTIFSGpUzjOrttWOX8Ea6BVgjsiktyr9VzU%2BJvMoTLbPQbQpXesvmm%2F69b38bfTvo2GsU%3D&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47UU2XXR6N6%2F20260624%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260624T101342Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=f1c9d96ab8e69721ad160d246af3ce9d7894bb56e6f2e53e735a3fb9ed8e0a25 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=IQoJb3JpZ2luX2VjEGoaCWV1LXdlc3QtMSJGMEQCICS0FFn1%2B%2Fzvc7haLFRWQY44hD33IrDbbqIPuqyiTWScAiAEZBvSDWqNAeWXKuO9guabncRs83F5SvMXcG6bcm5VvCq4BQgzEAUaDDI3MzU3MDE5NTQzMyIMMJgboLCWdy4H%2FLuyKpUF1wLQy38l0OcytnzlBo37I8x1ta%2BMS2BzJiwypJS%2Be8z%2B%2Fb5LRA2vx%2BJ%2FEGhhRG5%2BGQVtdHk3b6IV1ZXjjF3z4slkNMzBmzG3pSW61A4TNQ1SY233JRF6MQMeaFtAv%2BiOkgLdCP4%2BP4%2F0Hq9to6hmIxAChG8ZSTYznV%2FkbwcaOhQUy0a8ps4h6KHRL7ux9MPpVNnKra7ODWwxw1AC%2BcfCxEtVZXtDZosNbYIACgXpNrsod6drpSnOMOF87uP6ParabNalKppC3Bwh0zixyFIJ%2BBIuGwFmRfd51k7pAhv0O59v31jFJQ6yVM6ons51t45Yiv7jlEGcguhcG3dO6A4vXQ8pe%2Fcqa6wHIFLCHqN2ZJzsbRpQKfaDNqrmX4i8x7ZSO2h3ptV9%2FwOGEp5qKPAVast2Azp36rkW%2BNvL61Fri4JNm9sZWlKYlNRDordBdZ%2FD27Gm9c4H6slCak6rR6N3dx5KrmXNUDeM56AuCNipkC56n1wrXMh8dGoa7CRR5koFSP0kD9B%2ByrZ4SGudepamQS3yB1qOsvX9Xl1WJmBLNH42ueFh2rICihvVdP3kjM2UB22iqhBrSt5gJg%2FIrT0vTAP0cUPlAkFkVBPbOpVX%2BZLjQGF%2B3KmmlIbjXdKKLQ%2Fi18RevtAp6xuXIhP%2FOxjmuf4nsE2PyHJIz2RY%2B%2B%2BED%2Fprkj4euzcXr%2BhO6QfM0W3rqmAi30lLCtUxlVl%2FEGYCKMytwhWP4zCiZkNbh%2Ble%2F53YWoit9iqpo7%2FMsppdRFMyks31Vr5s8SzpHbyOW%2FWIuRudHSbuqHVZHtZFrkwO%2BbgRWHotPGeULSCf3JSQ3hr%2BoaXr01jmg0MCDC%2BOYooA%2BKz8ak5JiIeUwnNbqGDYWtdH3pjBUzDdye7RBjqyARkKxrNRJnHsdSWsDePcoNQ8ZBR4qy07PJD%2FP0p5yRdgU8bfIU%2FpabEV%2FyFMN6hBRUWQQFfq2BwfjOxNYk%2BOU2Q2BRxbILbznTNP8QPMuPHKFlp7PcJb%2Bo0%2FnH5gKaIhy7Lzo80bv7KctgwHEipnSS8z5XkWrsHc%2BX0FhKYnmQWTIFSGpUzjOrttWOX8Ea6BVgjsiktyr9VzU%2BJvMoTLbPQbQpXesvmm%2F69b38bfTvo2GsU%3D&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47UU2XXR6N6%2F20260624%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260624T101342Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=f1c9d96ab8e69721ad160d246af3ce9d7894bb56e6f2e53e735a3fb9ed8e0a25\" 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=IQoJb3JpZ2luX2VjEGoaCWV1LXdlc3QtMSJGMEQCICS0FFn1%2B%2Fzvc7haLFRWQY44hD33IrDbbqIPuqyiTWScAiAEZBvSDWqNAeWXKuO9guabncRs83F5SvMXcG6bcm5VvCq4BQgzEAUaDDI3MzU3MDE5NTQzMyIMMJgboLCWdy4H%2FLuyKpUF1wLQy38l0OcytnzlBo37I8x1ta%2BMS2BzJiwypJS%2Be8z%2B%2Fb5LRA2vx%2BJ%2FEGhhRG5%2BGQVtdHk3b6IV1ZXjjF3z4slkNMzBmzG3pSW61A4TNQ1SY233JRF6MQMeaFtAv%2BiOkgLdCP4%2BP4%2F0Hq9to6hmIxAChG8ZSTYznV%2FkbwcaOhQUy0a8ps4h6KHRL7ux9MPpVNnKra7ODWwxw1AC%2BcfCxEtVZXtDZosNbYIACgXpNrsod6drpSnOMOF87uP6ParabNalKppC3Bwh0zixyFIJ%2BBIuGwFmRfd51k7pAhv0O59v31jFJQ6yVM6ons51t45Yiv7jlEGcguhcG3dO6A4vXQ8pe%2Fcqa6wHIFLCHqN2ZJzsbRpQKfaDNqrmX4i8x7ZSO2h3ptV9%2FwOGEp5qKPAVast2Azp36rkW%2BNvL61Fri4JNm9sZWlKYlNRDordBdZ%2FD27Gm9c4H6slCak6rR6N3dx5KrmXNUDeM56AuCNipkC56n1wrXMh8dGoa7CRR5koFSP0kD9B%2ByrZ4SGudepamQS3yB1qOsvX9Xl1WJmBLNH42ueFh2rICihvVdP3kjM2UB22iqhBrSt5gJg%2FIrT0vTAP0cUPlAkFkVBPbOpVX%2BZLjQGF%2B3KmmlIbjXdKKLQ%2Fi18RevtAp6xuXIhP%2FOxjmuf4nsE2PyHJIz2RY%2B%2B%2BED%2Fprkj4euzcXr%2BhO6QfM0W3rqmAi30lLCtUxlVl%2FEGYCKMytwhWP4zCiZkNbh%2Ble%2F53YWoit9iqpo7%2FMsppdRFMyks31Vr5s8SzpHbyOW%2FWIuRudHSbuqHVZHtZFrkwO%2BbgRWHotPGeULSCf3JSQ3hr%2BoaXr01jmg0MCDC%2BOYooA%2BKz8ak5JiIeUwnNbqGDYWtdH3pjBUzDdye7RBjqyARkKxrNRJnHsdSWsDePcoNQ8ZBR4qy07PJD%2FP0p5yRdgU8bfIU%2FpabEV%2FyFMN6hBRUWQQFfq2BwfjOxNYk%2BOU2Q2BRxbILbznTNP8QPMuPHKFlp7PcJb%2Bo0%2FnH5gKaIhy7Lzo80bv7KctgwHEipnSS8z5XkWrsHc%2BX0FhKYnmQWTIFSGpUzjOrttWOX8Ea6BVgjsiktyr9VzU%2BJvMoTLbPQbQpXesvmm%2F69b38bfTvo2GsU%3D&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47UU2XXR6N6%2F20260624%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260624T101342Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=37296c3c55fcfe8d7a6bb7366b5c56f788834828be0dba88bd985a75b3f54ca4\" 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=IQoJb3JpZ2luX2VjEGoaCWV1LXdlc3QtMSJGMEQCICS0FFn1%2B%2Fzvc7haLFRWQY44hD33IrDbbqIPuqyiTWScAiAEZBvSDWqNAeWXKuO9guabncRs83F5SvMXcG6bcm5VvCq4BQgzEAUaDDI3MzU3MDE5NTQzMyIMMJgboLCWdy4H%2FLuyKpUF1wLQy38l0OcytnzlBo37I8x1ta%2BMS2BzJiwypJS%2Be8z%2B%2Fb5LRA2vx%2BJ%2FEGhhRG5%2BGQVtdHk3b6IV1ZXjjF3z4slkNMzBmzG3pSW61A4TNQ1SY233JRF6MQMeaFtAv%2BiOkgLdCP4%2BP4%2F0Hq9to6hmIxAChG8ZSTYznV%2FkbwcaOhQUy0a8ps4h6KHRL7ux9MPpVNnKra7ODWwxw1AC%2BcfCxEtVZXtDZosNbYIACgXpNrsod6drpSnOMOF87uP6ParabNalKppC3Bwh0zixyFIJ%2BBIuGwFmRfd51k7pAhv0O59v31jFJQ6yVM6ons51t45Yiv7jlEGcguhcG3dO6A4vXQ8pe%2Fcqa6wHIFLCHqN2ZJzsbRpQKfaDNqrmX4i8x7ZSO2h3ptV9%2FwOGEp5qKPAVast2Azp36rkW%2BNvL61Fri4JNm9sZWlKYlNRDordBdZ%2FD27Gm9c4H6slCak6rR6N3dx5KrmXNUDeM56AuCNipkC56n1wrXMh8dGoa7CRR5koFSP0kD9B%2ByrZ4SGudepamQS3yB1qOsvX9Xl1WJmBLNH42ueFh2rICihvVdP3kjM2UB22iqhBrSt5gJg%2FIrT0vTAP0cUPlAkFkVBPbOpVX%2BZLjQGF%2B3KmmlIbjXdKKLQ%2Fi18RevtAp6xuXIhP%2FOxjmuf4nsE2PyHJIz2RY%2B%2B%2BED%2Fprkj4euzcXr%2BhO6QfM0W3rqmAi30lLCtUxlVl%2FEGYCKMytwhWP4zCiZkNbh%2Ble%2F53YWoit9iqpo7%2FMsppdRFMyks31Vr5s8SzpHbyOW%2FWIuRudHSbuqHVZHtZFrkwO%2BbgRWHotPGeULSCf3JSQ3hr%2BoaXr01jmg0MCDC%2BOYooA%2BKz8ak5JiIeUwnNbqGDYWtdH3pjBUzDdye7RBjqyARkKxrNRJnHsdSWsDePcoNQ8ZBR4qy07PJD%2FP0p5yRdgU8bfIU%2FpabEV%2FyFMN6hBRUWQQFfq2BwfjOxNYk%2BOU2Q2BRxbILbznTNP8QPMuPHKFlp7PcJb%2Bo0%2FnH5gKaIhy7Lzo80bv7KctgwHEipnSS8z5XkWrsHc%2BX0FhKYnmQWTIFSGpUzjOrttWOX8Ea6BVgjsiktyr9VzU%2BJvMoTLbPQbQpXesvmm%2F69b38bfTvo2GsU%3D&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47UU2XXR6N6%2F20260624%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260624T101342Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=37296c3c55fcfe8d7a6bb7366b5c56f788834828be0dba88bd985a75b3f54ca4 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=IQoJb3JpZ2luX2VjEGoaCWV1LXdlc3QtMSJGMEQCICS0FFn1%2B%2Fzvc7haLFRWQY44hD33IrDbbqIPuqyiTWScAiAEZBvSDWqNAeWXKuO9guabncRs83F5SvMXcG6bcm5VvCq4BQgzEAUaDDI3MzU3MDE5NTQzMyIMMJgboLCWdy4H%2FLuyKpUF1wLQy38l0OcytnzlBo37I8x1ta%2BMS2BzJiwypJS%2Be8z%2B%2Fb5LRA2vx%2BJ%2FEGhhRG5%2BGQVtdHk3b6IV1ZXjjF3z4slkNMzBmzG3pSW61A4TNQ1SY233JRF6MQMeaFtAv%2BiOkgLdCP4%2BP4%2F0Hq9to6hmIxAChG8ZSTYznV%2FkbwcaOhQUy0a8ps4h6KHRL7ux9MPpVNnKra7ODWwxw1AC%2BcfCxEtVZXtDZosNbYIACgXpNrsod6drpSnOMOF87uP6ParabNalKppC3Bwh0zixyFIJ%2BBIuGwFmRfd51k7pAhv0O59v31jFJQ6yVM6ons51t45Yiv7jlEGcguhcG3dO6A4vXQ8pe%2Fcqa6wHIFLCHqN2ZJzsbRpQKfaDNqrmX4i8x7ZSO2h3ptV9%2FwOGEp5qKPAVast2Azp36rkW%2BNvL61Fri4JNm9sZWlKYlNRDordBdZ%2FD27Gm9c4H6slCak6rR6N3dx5KrmXNUDeM56AuCNipkC56n1wrXMh8dGoa7CRR5koFSP0kD9B%2ByrZ4SGudepamQS3yB1qOsvX9Xl1WJmBLNH42ueFh2rICihvVdP3kjM2UB22iqhBrSt5gJg%2FIrT0vTAP0cUPlAkFkVBPbOpVX%2BZLjQGF%2B3KmmlIbjXdKKLQ%2Fi18RevtAp6xuXIhP%2FOxjmuf4nsE2PyHJIz2RY%2B%2B%2BED%2Fprkj4euzcXr%2BhO6QfM0W3rqmAi30lLCtUxlVl%2FEGYCKMytwhWP4zCiZkNbh%2Ble%2F53YWoit9iqpo7%2FMsppdRFMyks31Vr5s8SzpHbyOW%2FWIuRudHSbuqHVZHtZFrkwO%2BbgRWHotPGeULSCf3JSQ3hr%2BoaXr01jmg0MCDC%2BOYooA%2BKz8ak5JiIeUwnNbqGDYWtdH3pjBUzDdye7RBjqyARkKxrNRJnHsdSWsDePcoNQ8ZBR4qy07PJD%2FP0p5yRdgU8bfIU%2FpabEV%2FyFMN6hBRUWQQFfq2BwfjOxNYk%2BOU2Q2BRxbILbznTNP8QPMuPHKFlp7PcJb%2Bo0%2FnH5gKaIhy7Lzo80bv7KctgwHEipnSS8z5XkWrsHc%2BX0FhKYnmQWTIFSGpUzjOrttWOX8Ea6BVgjsiktyr9VzU%2BJvMoTLbPQbQpXesvmm%2F69b38bfTvo2GsU%3D&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47UU2XXR6N6%2F20260624%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260624T101342Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=3285c11957bff89e19fd7b5a4b17256bf43829806bd26b8aca601fc394af8650 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=IQoJb3JpZ2luX2VjEGoaCWV1LXdlc3QtMSJGMEQCICS0FFn1%2B%2Fzvc7haLFRWQY44hD33IrDbbqIPuqyiTWScAiAEZBvSDWqNAeWXKuO9guabncRs83F5SvMXcG6bcm5VvCq4BQgzEAUaDDI3MzU3MDE5NTQzMyIMMJgboLCWdy4H%2FLuyKpUF1wLQy38l0OcytnzlBo37I8x1ta%2BMS2BzJiwypJS%2Be8z%2B%2Fb5LRA2vx%2BJ%2FEGhhRG5%2BGQVtdHk3b6IV1ZXjjF3z4slkNMzBmzG3pSW61A4TNQ1SY233JRF6MQMeaFtAv%2BiOkgLdCP4%2BP4%2F0Hq9to6hmIxAChG8ZSTYznV%2FkbwcaOhQUy0a8ps4h6KHRL7ux9MPpVNnKra7ODWwxw1AC%2BcfCxEtVZXtDZosNbYIACgXpNrsod6drpSnOMOF87uP6ParabNalKppC3Bwh0zixyFIJ%2BBIuGwFmRfd51k7pAhv0O59v31jFJQ6yVM6ons51t45Yiv7jlEGcguhcG3dO6A4vXQ8pe%2Fcqa6wHIFLCHqN2ZJzsbRpQKfaDNqrmX4i8x7ZSO2h3ptV9%2FwOGEp5qKPAVast2Azp36rkW%2BNvL61Fri4JNm9sZWlKYlNRDordBdZ%2FD27Gm9c4H6slCak6rR6N3dx5KrmXNUDeM56AuCNipkC56n1wrXMh8dGoa7CRR5koFSP0kD9B%2ByrZ4SGudepamQS3yB1qOsvX9Xl1WJmBLNH42ueFh2rICihvVdP3kjM2UB22iqhBrSt5gJg%2FIrT0vTAP0cUPlAkFkVBPbOpVX%2BZLjQGF%2B3KmmlIbjXdKKLQ%2Fi18RevtAp6xuXIhP%2FOxjmuf4nsE2PyHJIz2RY%2B%2B%2BED%2Fprkj4euzcXr%2BhO6QfM0W3rqmAi30lLCtUxlVl%2FEGYCKMytwhWP4zCiZkNbh%2Ble%2F53YWoit9iqpo7%2FMsppdRFMyks31Vr5s8SzpHbyOW%2FWIuRudHSbuqHVZHtZFrkwO%2BbgRWHotPGeULSCf3JSQ3hr%2BoaXr01jmg0MCDC%2BOYooA%2BKz8ak5JiIeUwnNbqGDYWtdH3pjBUzDdye7RBjqyARkKxrNRJnHsdSWsDePcoNQ8ZBR4qy07PJD%2FP0p5yRdgU8bfIU%2FpabEV%2FyFMN6hBRUWQQFfq2BwfjOxNYk%2BOU2Q2BRxbILbznTNP8QPMuPHKFlp7PcJb%2Bo0%2FnH5gKaIhy7Lzo80bv7KctgwHEipnSS8z5XkWrsHc%2BX0FhKYnmQWTIFSGpUzjOrttWOX8Ea6BVgjsiktyr9VzU%2BJvMoTLbPQbQpXesvmm%2F69b38bfTvo2GsU%3D&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47UU2XXR6N6%2F20260624%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260624T101342Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=3285c11957bff89e19fd7b5a4b17256bf43829806bd26b8aca601fc394af8650\" 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=IQoJb3JpZ2luX2VjEGoaCWV1LXdlc3QtMSJGMEQCICS0FFn1%2B%2Fzvc7haLFRWQY44hD33IrDbbqIPuqyiTWScAiAEZBvSDWqNAeWXKuO9guabncRs83F5SvMXcG6bcm5VvCq4BQgzEAUaDDI3MzU3MDE5NTQzMyIMMJgboLCWdy4H%2FLuyKpUF1wLQy38l0OcytnzlBo37I8x1ta%2BMS2BzJiwypJS%2Be8z%2B%2Fb5LRA2vx%2BJ%2FEGhhRG5%2BGQVtdHk3b6IV1ZXjjF3z4slkNMzBmzG3pSW61A4TNQ1SY233JRF6MQMeaFtAv%2BiOkgLdCP4%2BP4%2F0Hq9to6hmIxAChG8ZSTYznV%2FkbwcaOhQUy0a8ps4h6KHRL7ux9MPpVNnKra7ODWwxw1AC%2BcfCxEtVZXtDZosNbYIACgXpNrsod6drpSnOMOF87uP6ParabNalKppC3Bwh0zixyFIJ%2BBIuGwFmRfd51k7pAhv0O59v31jFJQ6yVM6ons51t45Yiv7jlEGcguhcG3dO6A4vXQ8pe%2Fcqa6wHIFLCHqN2ZJzsbRpQKfaDNqrmX4i8x7ZSO2h3ptV9%2FwOGEp5qKPAVast2Azp36rkW%2BNvL61Fri4JNm9sZWlKYlNRDordBdZ%2FD27Gm9c4H6slCak6rR6N3dx5KrmXNUDeM56AuCNipkC56n1wrXMh8dGoa7CRR5koFSP0kD9B%2ByrZ4SGudepamQS3yB1qOsvX9Xl1WJmBLNH42ueFh2rICihvVdP3kjM2UB22iqhBrSt5gJg%2FIrT0vTAP0cUPlAkFkVBPbOpVX%2BZLjQGF%2B3KmmlIbjXdKKLQ%2Fi18RevtAp6xuXIhP%2FOxjmuf4nsE2PyHJIz2RY%2B%2B%2BED%2Fprkj4euzcXr%2BhO6QfM0W3rqmAi30lLCtUxlVl%2FEGYCKMytwhWP4zCiZkNbh%2Ble%2F53YWoit9iqpo7%2FMsppdRFMyks31Vr5s8SzpHbyOW%2FWIuRudHSbuqHVZHtZFrkwO%2BbgRWHotPGeULSCf3JSQ3hr%2BoaXr01jmg0MCDC%2BOYooA%2BKz8ak5JiIeUwnNbqGDYWtdH3pjBUzDdye7RBjqyARkKxrNRJnHsdSWsDePcoNQ8ZBR4qy07PJD%2FP0p5yRdgU8bfIU%2FpabEV%2FyFMN6hBRUWQQFfq2BwfjOxNYk%2BOU2Q2BRxbILbznTNP8QPMuPHKFlp7PcJb%2Bo0%2FnH5gKaIhy7Lzo80bv7KctgwHEipnSS8z5XkWrsHc%2BX0FhKYnmQWTIFSGpUzjOrttWOX8Ea6BVgjsiktyr9VzU%2BJvMoTLbPQbQpXesvmm%2F69b38bfTvo2GsU%3D&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47UU2XXR6N6%2F20260624%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260624T101342Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=b10f476f4c77dbc85714ed6fe827e21b3beefad0f8ab654ec96c79c85c87316c\" 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=IQoJb3JpZ2luX2VjEGoaCWV1LXdlc3QtMSJGMEQCICS0FFn1%2B%2Fzvc7haLFRWQY44hD33IrDbbqIPuqyiTWScAiAEZBvSDWqNAeWXKuO9guabncRs83F5SvMXcG6bcm5VvCq4BQgzEAUaDDI3MzU3MDE5NTQzMyIMMJgboLCWdy4H%2FLuyKpUF1wLQy38l0OcytnzlBo37I8x1ta%2BMS2BzJiwypJS%2Be8z%2B%2Fb5LRA2vx%2BJ%2FEGhhRG5%2BGQVtdHk3b6IV1ZXjjF3z4slkNMzBmzG3pSW61A4TNQ1SY233JRF6MQMeaFtAv%2BiOkgLdCP4%2BP4%2F0Hq9to6hmIxAChG8ZSTYznV%2FkbwcaOhQUy0a8ps4h6KHRL7ux9MPpVNnKra7ODWwxw1AC%2BcfCxEtVZXtDZosNbYIACgXpNrsod6drpSnOMOF87uP6ParabNalKppC3Bwh0zixyFIJ%2BBIuGwFmRfd51k7pAhv0O59v31jFJQ6yVM6ons51t45Yiv7jlEGcguhcG3dO6A4vXQ8pe%2Fcqa6wHIFLCHqN2ZJzsbRpQKfaDNqrmX4i8x7ZSO2h3ptV9%2FwOGEp5qKPAVast2Azp36rkW%2BNvL61Fri4JNm9sZWlKYlNRDordBdZ%2FD27Gm9c4H6slCak6rR6N3dx5KrmXNUDeM56AuCNipkC56n1wrXMh8dGoa7CRR5koFSP0kD9B%2ByrZ4SGudepamQS3yB1qOsvX9Xl1WJmBLNH42ueFh2rICihvVdP3kjM2UB22iqhBrSt5gJg%2FIrT0vTAP0cUPlAkFkVBPbOpVX%2BZLjQGF%2B3KmmlIbjXdKKLQ%2Fi18RevtAp6xuXIhP%2FOxjmuf4nsE2PyHJIz2RY%2B%2B%2BED%2Fprkj4euzcXr%2BhO6QfM0W3rqmAi30lLCtUxlVl%2FEGYCKMytwhWP4zCiZkNbh%2Ble%2F53YWoit9iqpo7%2FMsppdRFMyks31Vr5s8SzpHbyOW%2FWIuRudHSbuqHVZHtZFrkwO%2BbgRWHotPGeULSCf3JSQ3hr%2BoaXr01jmg0MCDC%2BOYooA%2BKz8ak5JiIeUwnNbqGDYWtdH3pjBUzDdye7RBjqyARkKxrNRJnHsdSWsDePcoNQ8ZBR4qy07PJD%2FP0p5yRdgU8bfIU%2FpabEV%2FyFMN6hBRUWQQFfq2BwfjOxNYk%2BOU2Q2BRxbILbznTNP8QPMuPHKFlp7PcJb%2Bo0%2FnH5gKaIhy7Lzo80bv7KctgwHEipnSS8z5XkWrsHc%2BX0FhKYnmQWTIFSGpUzjOrttWOX8Ea6BVgjsiktyr9VzU%2BJvMoTLbPQbQpXesvmm%2F69b38bfTvo2GsU%3D&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47UU2XXR6N6%2F20260624%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260624T101342Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=b10f476f4c77dbc85714ed6fe827e21b3beefad0f8ab654ec96c79c85c87316c 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=IQoJb3JpZ2luX2VjEGoaCWV1LXdlc3QtMSJGMEQCICS0FFn1%2B%2Fzvc7haLFRWQY44hD33IrDbbqIPuqyiTWScAiAEZBvSDWqNAeWXKuO9guabncRs83F5SvMXcG6bcm5VvCq4BQgzEAUaDDI3MzU3MDE5NTQzMyIMMJgboLCWdy4H%2FLuyKpUF1wLQy38l0OcytnzlBo37I8x1ta%2BMS2BzJiwypJS%2Be8z%2B%2Fb5LRA2vx%2BJ%2FEGhhRG5%2BGQVtdHk3b6IV1ZXjjF3z4slkNMzBmzG3pSW61A4TNQ1SY233JRF6MQMeaFtAv%2BiOkgLdCP4%2BP4%2F0Hq9to6hmIxAChG8ZSTYznV%2FkbwcaOhQUy0a8ps4h6KHRL7ux9MPpVNnKra7ODWwxw1AC%2BcfCxEtVZXtDZosNbYIACgXpNrsod6drpSnOMOF87uP6ParabNalKppC3Bwh0zixyFIJ%2BBIuGwFmRfd51k7pAhv0O59v31jFJQ6yVM6ons51t45Yiv7jlEGcguhcG3dO6A4vXQ8pe%2Fcqa6wHIFLCHqN2ZJzsbRpQKfaDNqrmX4i8x7ZSO2h3ptV9%2FwOGEp5qKPAVast2Azp36rkW%2BNvL61Fri4JNm9sZWlKYlNRDordBdZ%2FD27Gm9c4H6slCak6rR6N3dx5KrmXNUDeM56AuCNipkC56n1wrXMh8dGoa7CRR5koFSP0kD9B%2ByrZ4SGudepamQS3yB1qOsvX9Xl1WJmBLNH42ueFh2rICihvVdP3kjM2UB22iqhBrSt5gJg%2FIrT0vTAP0cUPlAkFkVBPbOpVX%2BZLjQGF%2B3KmmlIbjXdKKLQ%2Fi18RevtAp6xuXIhP%2FOxjmuf4nsE2PyHJIz2RY%2B%2B%2BED%2Fprkj4euzcXr%2BhO6QfM0W3rqmAi30lLCtUxlVl%2FEGYCKMytwhWP4zCiZkNbh%2Ble%2F53YWoit9iqpo7%2FMsppdRFMyks31Vr5s8SzpHbyOW%2FWIuRudHSbuqHVZHtZFrkwO%2BbgRWHotPGeULSCf3JSQ3hr%2BoaXr01jmg0MCDC%2BOYooA%2BKz8ak5JiIeUwnNbqGDYWtdH3pjBUzDdye7RBjqyARkKxrNRJnHsdSWsDePcoNQ8ZBR4qy07PJD%2FP0p5yRdgU8bfIU%2FpabEV%2FyFMN6hBRUWQQFfq2BwfjOxNYk%2BOU2Q2BRxbILbznTNP8QPMuPHKFlp7PcJb%2Bo0%2FnH5gKaIhy7Lzo80bv7KctgwHEipnSS8z5XkWrsHc%2BX0FhKYnmQWTIFSGpUzjOrttWOX8Ea6BVgjsiktyr9VzU%2BJvMoTLbPQbQpXesvmm%2F69b38bfTvo2GsU%3D&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47UU2XXR6N6%2F20260624%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260624T101342Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=c82c276a6ae66ac6e011f3728212642bc97928b41f2d85011d3c4cc15e43405f 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=IQoJb3JpZ2luX2VjEGoaCWV1LXdlc3QtMSJGMEQCICS0FFn1%2B%2Fzvc7haLFRWQY44hD33IrDbbqIPuqyiTWScAiAEZBvSDWqNAeWXKuO9guabncRs83F5SvMXcG6bcm5VvCq4BQgzEAUaDDI3MzU3MDE5NTQzMyIMMJgboLCWdy4H%2FLuyKpUF1wLQy38l0OcytnzlBo37I8x1ta%2BMS2BzJiwypJS%2Be8z%2B%2Fb5LRA2vx%2BJ%2FEGhhRG5%2BGQVtdHk3b6IV1ZXjjF3z4slkNMzBmzG3pSW61A4TNQ1SY233JRF6MQMeaFtAv%2BiOkgLdCP4%2BP4%2F0Hq9to6hmIxAChG8ZSTYznV%2FkbwcaOhQUy0a8ps4h6KHRL7ux9MPpVNnKra7ODWwxw1AC%2BcfCxEtVZXtDZosNbYIACgXpNrsod6drpSnOMOF87uP6ParabNalKppC3Bwh0zixyFIJ%2BBIuGwFmRfd51k7pAhv0O59v31jFJQ6yVM6ons51t45Yiv7jlEGcguhcG3dO6A4vXQ8pe%2Fcqa6wHIFLCHqN2ZJzsbRpQKfaDNqrmX4i8x7ZSO2h3ptV9%2FwOGEp5qKPAVast2Azp36rkW%2BNvL61Fri4JNm9sZWlKYlNRDordBdZ%2FD27Gm9c4H6slCak6rR6N3dx5KrmXNUDeM56AuCNipkC56n1wrXMh8dGoa7CRR5koFSP0kD9B%2ByrZ4SGudepamQS3yB1qOsvX9Xl1WJmBLNH42ueFh2rICihvVdP3kjM2UB22iqhBrSt5gJg%2FIrT0vTAP0cUPlAkFkVBPbOpVX%2BZLjQGF%2B3KmmlIbjXdKKLQ%2Fi18RevtAp6xuXIhP%2FOxjmuf4nsE2PyHJIz2RY%2B%2B%2BED%2Fprkj4euzcXr%2BhO6QfM0W3rqmAi30lLCtUxlVl%2FEGYCKMytwhWP4zCiZkNbh%2Ble%2F53YWoit9iqpo7%2FMsppdRFMyks31Vr5s8SzpHbyOW%2FWIuRudHSbuqHVZHtZFrkwO%2BbgRWHotPGeULSCf3JSQ3hr%2BoaXr01jmg0MCDC%2BOYooA%2BKz8ak5JiIeUwnNbqGDYWtdH3pjBUzDdye7RBjqyARkKxrNRJnHsdSWsDePcoNQ8ZBR4qy07PJD%2FP0p5yRdgU8bfIU%2FpabEV%2FyFMN6hBRUWQQFfq2BwfjOxNYk%2BOU2Q2BRxbILbznTNP8QPMuPHKFlp7PcJb%2Bo0%2FnH5gKaIhy7Lzo80bv7KctgwHEipnSS8z5XkWrsHc%2BX0FhKYnmQWTIFSGpUzjOrttWOX8Ea6BVgjsiktyr9VzU%2BJvMoTLbPQbQpXesvmm%2F69b38bfTvo2GsU%3D&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47UU2XXR6N6%2F20260624%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260624T101342Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=c82c276a6ae66ac6e011f3728212642bc97928b41f2d85011d3c4cc15e43405f\" 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=IQoJb3JpZ2luX2VjEGoaCWV1LXdlc3QtMSJGMEQCICS0FFn1%2B%2Fzvc7haLFRWQY44hD33IrDbbqIPuqyiTWScAiAEZBvSDWqNAeWXKuO9guabncRs83F5SvMXcG6bcm5VvCq4BQgzEAUaDDI3MzU3MDE5NTQzMyIMMJgboLCWdy4H%2FLuyKpUF1wLQy38l0OcytnzlBo37I8x1ta%2BMS2BzJiwypJS%2Be8z%2B%2Fb5LRA2vx%2BJ%2FEGhhRG5%2BGQVtdHk3b6IV1ZXjjF3z4slkNMzBmzG3pSW61A4TNQ1SY233JRF6MQMeaFtAv%2BiOkgLdCP4%2BP4%2F0Hq9to6hmIxAChG8ZSTYznV%2FkbwcaOhQUy0a8ps4h6KHRL7ux9MPpVNnKra7ODWwxw1AC%2BcfCxEtVZXtDZosNbYIACgXpNrsod6drpSnOMOF87uP6ParabNalKppC3Bwh0zixyFIJ%2BBIuGwFmRfd51k7pAhv0O59v31jFJQ6yVM6ons51t45Yiv7jlEGcguhcG3dO6A4vXQ8pe%2Fcqa6wHIFLCHqN2ZJzsbRpQKfaDNqrmX4i8x7ZSO2h3ptV9%2FwOGEp5qKPAVast2Azp36rkW%2BNvL61Fri4JNm9sZWlKYlNRDordBdZ%2FD27Gm9c4H6slCak6rR6N3dx5KrmXNUDeM56AuCNipkC56n1wrXMh8dGoa7CRR5koFSP0kD9B%2ByrZ4SGudepamQS3yB1qOsvX9Xl1WJmBLNH42ueFh2rICihvVdP3kjM2UB22iqhBrSt5gJg%2FIrT0vTAP0cUPlAkFkVBPbOpVX%2BZLjQGF%2B3KmmlIbjXdKKLQ%2Fi18RevtAp6xuXIhP%2FOxjmuf4nsE2PyHJIz2RY%2B%2B%2BED%2Fprkj4euzcXr%2BhO6QfM0W3rqmAi30lLCtUxlVl%2FEGYCKMytwhWP4zCiZkNbh%2Ble%2F53YWoit9iqpo7%2FMsppdRFMyks31Vr5s8SzpHbyOW%2FWIuRudHSbuqHVZHtZFrkwO%2BbgRWHotPGeULSCf3JSQ3hr%2BoaXr01jmg0MCDC%2BOYooA%2BKz8ak5JiIeUwnNbqGDYWtdH3pjBUzDdye7RBjqyARkKxrNRJnHsdSWsDePcoNQ8ZBR4qy07PJD%2FP0p5yRdgU8bfIU%2FpabEV%2FyFMN6hBRUWQQFfq2BwfjOxNYk%2BOU2Q2BRxbILbznTNP8QPMuPHKFlp7PcJb%2Bo0%2FnH5gKaIhy7Lzo80bv7KctgwHEipnSS8z5XkWrsHc%2BX0FhKYnmQWTIFSGpUzjOrttWOX8Ea6BVgjsiktyr9VzU%2BJvMoTLbPQbQpXesvmm%2F69b38bfTvo2GsU%3D&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47UU2XXR6N6%2F20260624%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260624T101342Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=cf4a5d38debb80eef12c8d4470b032e85a6a93f7078bbe4fed00cddad157bfa2\" 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=IQoJb3JpZ2luX2VjEGoaCWV1LXdlc3QtMSJGMEQCICS0FFn1%2B%2Fzvc7haLFRWQY44hD33IrDbbqIPuqyiTWScAiAEZBvSDWqNAeWXKuO9guabncRs83F5SvMXcG6bcm5VvCq4BQgzEAUaDDI3MzU3MDE5NTQzMyIMMJgboLCWdy4H%2FLuyKpUF1wLQy38l0OcytnzlBo37I8x1ta%2BMS2BzJiwypJS%2Be8z%2B%2Fb5LRA2vx%2BJ%2FEGhhRG5%2BGQVtdHk3b6IV1ZXjjF3z4slkNMzBmzG3pSW61A4TNQ1SY233JRF6MQMeaFtAv%2BiOkgLdCP4%2BP4%2F0Hq9to6hmIxAChG8ZSTYznV%2FkbwcaOhQUy0a8ps4h6KHRL7ux9MPpVNnKra7ODWwxw1AC%2BcfCxEtVZXtDZosNbYIACgXpNrsod6drpSnOMOF87uP6ParabNalKppC3Bwh0zixyFIJ%2BBIuGwFmRfd51k7pAhv0O59v31jFJQ6yVM6ons51t45Yiv7jlEGcguhcG3dO6A4vXQ8pe%2Fcqa6wHIFLCHqN2ZJzsbRpQKfaDNqrmX4i8x7ZSO2h3ptV9%2FwOGEp5qKPAVast2Azp36rkW%2BNvL61Fri4JNm9sZWlKYlNRDordBdZ%2FD27Gm9c4H6slCak6rR6N3dx5KrmXNUDeM56AuCNipkC56n1wrXMh8dGoa7CRR5koFSP0kD9B%2ByrZ4SGudepamQS3yB1qOsvX9Xl1WJmBLNH42ueFh2rICihvVdP3kjM2UB22iqhBrSt5gJg%2FIrT0vTAP0cUPlAkFkVBPbOpVX%2BZLjQGF%2B3KmmlIbjXdKKLQ%2Fi18RevtAp6xuXIhP%2FOxjmuf4nsE2PyHJIz2RY%2B%2B%2BED%2Fprkj4euzcXr%2BhO6QfM0W3rqmAi30lLCtUxlVl%2FEGYCKMytwhWP4zCiZkNbh%2Ble%2F53YWoit9iqpo7%2FMsppdRFMyks31Vr5s8SzpHbyOW%2FWIuRudHSbuqHVZHtZFrkwO%2BbgRWHotPGeULSCf3JSQ3hr%2BoaXr01jmg0MCDC%2BOYooA%2BKz8ak5JiIeUwnNbqGDYWtdH3pjBUzDdye7RBjqyARkKxrNRJnHsdSWsDePcoNQ8ZBR4qy07PJD%2FP0p5yRdgU8bfIU%2FpabEV%2FyFMN6hBRUWQQFfq2BwfjOxNYk%2BOU2Q2BRxbILbznTNP8QPMuPHKFlp7PcJb%2Bo0%2FnH5gKaIhy7Lzo80bv7KctgwHEipnSS8z5XkWrsHc%2BX0FhKYnmQWTIFSGpUzjOrttWOX8Ea6BVgjsiktyr9VzU%2BJvMoTLbPQbQpXesvmm%2F69b38bfTvo2GsU%3D&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47UU2XXR6N6%2F20260624%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260624T101342Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=cf4a5d38debb80eef12c8d4470b032e85a6a93f7078bbe4fed00cddad157bfa2 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=IQoJb3JpZ2luX2VjEGoaCWV1LXdlc3QtMSJGMEQCICS0FFn1%2B%2Fzvc7haLFRWQY44hD33IrDbbqIPuqyiTWScAiAEZBvSDWqNAeWXKuO9guabncRs83F5SvMXcG6bcm5VvCq4BQgzEAUaDDI3MzU3MDE5NTQzMyIMMJgboLCWdy4H%2FLuyKpUF1wLQy38l0OcytnzlBo37I8x1ta%2BMS2BzJiwypJS%2Be8z%2B%2Fb5LRA2vx%2BJ%2FEGhhRG5%2BGQVtdHk3b6IV1ZXjjF3z4slkNMzBmzG3pSW61A4TNQ1SY233JRF6MQMeaFtAv%2BiOkgLdCP4%2BP4%2F0Hq9to6hmIxAChG8ZSTYznV%2FkbwcaOhQUy0a8ps4h6KHRL7ux9MPpVNnKra7ODWwxw1AC%2BcfCxEtVZXtDZosNbYIACgXpNrsod6drpSnOMOF87uP6ParabNalKppC3Bwh0zixyFIJ%2BBIuGwFmRfd51k7pAhv0O59v31jFJQ6yVM6ons51t45Yiv7jlEGcguhcG3dO6A4vXQ8pe%2Fcqa6wHIFLCHqN2ZJzsbRpQKfaDNqrmX4i8x7ZSO2h3ptV9%2FwOGEp5qKPAVast2Azp36rkW%2BNvL61Fri4JNm9sZWlKYlNRDordBdZ%2FD27Gm9c4H6slCak6rR6N3dx5KrmXNUDeM56AuCNipkC56n1wrXMh8dGoa7CRR5koFSP0kD9B%2ByrZ4SGudepamQS3yB1qOsvX9Xl1WJmBLNH42ueFh2rICihvVdP3kjM2UB22iqhBrSt5gJg%2FIrT0vTAP0cUPlAkFkVBPbOpVX%2BZLjQGF%2B3KmmlIbjXdKKLQ%2Fi18RevtAp6xuXIhP%2FOxjmuf4nsE2PyHJIz2RY%2B%2B%2BED%2Fprkj4euzcXr%2BhO6QfM0W3rqmAi30lLCtUxlVl%2FEGYCKMytwhWP4zCiZkNbh%2Ble%2F53YWoit9iqpo7%2FMsppdRFMyks31Vr5s8SzpHbyOW%2FWIuRudHSbuqHVZHtZFrkwO%2BbgRWHotPGeULSCf3JSQ3hr%2BoaXr01jmg0MCDC%2BOYooA%2BKz8ak5JiIeUwnNbqGDYWtdH3pjBUzDdye7RBjqyARkKxrNRJnHsdSWsDePcoNQ8ZBR4qy07PJD%2FP0p5yRdgU8bfIU%2FpabEV%2FyFMN6hBRUWQQFfq2BwfjOxNYk%2BOU2Q2BRxbILbznTNP8QPMuPHKFlp7PcJb%2Bo0%2FnH5gKaIhy7Lzo80bv7KctgwHEipnSS8z5XkWrsHc%2BX0FhKYnmQWTIFSGpUzjOrttWOX8Ea6BVgjsiktyr9VzU%2BJvMoTLbPQbQpXesvmm%2F69b38bfTvo2GsU%3D&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47UU2XXR6N6%2F20260624%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260624T101342Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=2e3becaed7c12cbad16d31a00f9dd42fce1fbfcd4018c5a853eb4dc8f0e5867b 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=IQoJb3JpZ2luX2VjEGoaCWV1LXdlc3QtMSJGMEQCICS0FFn1%2B%2Fzvc7haLFRWQY44hD33IrDbbqIPuqyiTWScAiAEZBvSDWqNAeWXKuO9guabncRs83F5SvMXcG6bcm5VvCq4BQgzEAUaDDI3MzU3MDE5NTQzMyIMMJgboLCWdy4H%2FLuyKpUF1wLQy38l0OcytnzlBo37I8x1ta%2BMS2BzJiwypJS%2Be8z%2B%2Fb5LRA2vx%2BJ%2FEGhhRG5%2BGQVtdHk3b6IV1ZXjjF3z4slkNMzBmzG3pSW61A4TNQ1SY233JRF6MQMeaFtAv%2BiOkgLdCP4%2BP4%2F0Hq9to6hmIxAChG8ZSTYznV%2FkbwcaOhQUy0a8ps4h6KHRL7ux9MPpVNnKra7ODWwxw1AC%2BcfCxEtVZXtDZosNbYIACgXpNrsod6drpSnOMOF87uP6ParabNalKppC3Bwh0zixyFIJ%2BBIuGwFmRfd51k7pAhv0O59v31jFJQ6yVM6ons51t45Yiv7jlEGcguhcG3dO6A4vXQ8pe%2Fcqa6wHIFLCHqN2ZJzsbRpQKfaDNqrmX4i8x7ZSO2h3ptV9%2FwOGEp5qKPAVast2Azp36rkW%2BNvL61Fri4JNm9sZWlKYlNRDordBdZ%2FD27Gm9c4H6slCak6rR6N3dx5KrmXNUDeM56AuCNipkC56n1wrXMh8dGoa7CRR5koFSP0kD9B%2ByrZ4SGudepamQS3yB1qOsvX9Xl1WJmBLNH42ueFh2rICihvVdP3kjM2UB22iqhBrSt5gJg%2FIrT0vTAP0cUPlAkFkVBPbOpVX%2BZLjQGF%2B3KmmlIbjXdKKLQ%2Fi18RevtAp6xuXIhP%2FOxjmuf4nsE2PyHJIz2RY%2B%2B%2BED%2Fprkj4euzcXr%2BhO6QfM0W3rqmAi30lLCtUxlVl%2FEGYCKMytwhWP4zCiZkNbh%2Ble%2F53YWoit9iqpo7%2FMsppdRFMyks31Vr5s8SzpHbyOW%2FWIuRudHSbuqHVZHtZFrkwO%2BbgRWHotPGeULSCf3JSQ3hr%2BoaXr01jmg0MCDC%2BOYooA%2BKz8ak5JiIeUwnNbqGDYWtdH3pjBUzDdye7RBjqyARkKxrNRJnHsdSWsDePcoNQ8ZBR4qy07PJD%2FP0p5yRdgU8bfIU%2FpabEV%2FyFMN6hBRUWQQFfq2BwfjOxNYk%2BOU2Q2BRxbILbznTNP8QPMuPHKFlp7PcJb%2Bo0%2FnH5gKaIhy7Lzo80bv7KctgwHEipnSS8z5XkWrsHc%2BX0FhKYnmQWTIFSGpUzjOrttWOX8Ea6BVgjsiktyr9VzU%2BJvMoTLbPQbQpXesvmm%2F69b38bfTvo2GsU%3D&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47UU2XXR6N6%2F20260624%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260624T101342Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=2e3becaed7c12cbad16d31a00f9dd42fce1fbfcd4018c5a853eb4dc8f0e5867b\" 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=IQoJb3JpZ2luX2VjEGoaCWV1LXdlc3QtMSJGMEQCICS0FFn1%2B%2Fzvc7haLFRWQY44hD33IrDbbqIPuqyiTWScAiAEZBvSDWqNAeWXKuO9guabncRs83F5SvMXcG6bcm5VvCq4BQgzEAUaDDI3MzU3MDE5NTQzMyIMMJgboLCWdy4H%2FLuyKpUF1wLQy38l0OcytnzlBo37I8x1ta%2BMS2BzJiwypJS%2Be8z%2B%2Fb5LRA2vx%2BJ%2FEGhhRG5%2BGQVtdHk3b6IV1ZXjjF3z4slkNMzBmzG3pSW61A4TNQ1SY233JRF6MQMeaFtAv%2BiOkgLdCP4%2BP4%2F0Hq9to6hmIxAChG8ZSTYznV%2FkbwcaOhQUy0a8ps4h6KHRL7ux9MPpVNnKra7ODWwxw1AC%2BcfCxEtVZXtDZosNbYIACgXpNrsod6drpSnOMOF87uP6ParabNalKppC3Bwh0zixyFIJ%2BBIuGwFmRfd51k7pAhv0O59v31jFJQ6yVM6ons51t45Yiv7jlEGcguhcG3dO6A4vXQ8pe%2Fcqa6wHIFLCHqN2ZJzsbRpQKfaDNqrmX4i8x7ZSO2h3ptV9%2FwOGEp5qKPAVast2Azp36rkW%2BNvL61Fri4JNm9sZWlKYlNRDordBdZ%2FD27Gm9c4H6slCak6rR6N3dx5KrmXNUDeM56AuCNipkC56n1wrXMh8dGoa7CRR5koFSP0kD9B%2ByrZ4SGudepamQS3yB1qOsvX9Xl1WJmBLNH42ueFh2rICihvVdP3kjM2UB22iqhBrSt5gJg%2FIrT0vTAP0cUPlAkFkVBPbOpVX%2BZLjQGF%2B3KmmlIbjXdKKLQ%2Fi18RevtAp6xuXIhP%2FOxjmuf4nsE2PyHJIz2RY%2B%2B%2BED%2Fprkj4euzcXr%2BhO6QfM0W3rqmAi30lLCtUxlVl%2FEGYCKMytwhWP4zCiZkNbh%2Ble%2F53YWoit9iqpo7%2FMsppdRFMyks31Vr5s8SzpHbyOW%2FWIuRudHSbuqHVZHtZFrkwO%2BbgRWHotPGeULSCf3JSQ3hr%2BoaXr01jmg0MCDC%2BOYooA%2BKz8ak5JiIeUwnNbqGDYWtdH3pjBUzDdye7RBjqyARkKxrNRJnHsdSWsDePcoNQ8ZBR4qy07PJD%2FP0p5yRdgU8bfIU%2FpabEV%2FyFMN6hBRUWQQFfq2BwfjOxNYk%2BOU2Q2BRxbILbznTNP8QPMuPHKFlp7PcJb%2Bo0%2FnH5gKaIhy7Lzo80bv7KctgwHEipnSS8z5XkWrsHc%2BX0FhKYnmQWTIFSGpUzjOrttWOX8Ea6BVgjsiktyr9VzU%2BJvMoTLbPQbQpXesvmm%2F69b38bfTvo2GsU%3D&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47UU2XXR6N6%2F20260624%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260624T101342Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=6b7b61b810b00eb9318c822b4ec172cf595d3ce0527aa67327be0183e805c46c\" 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=IQoJb3JpZ2luX2VjEGoaCWV1LXdlc3QtMSJGMEQCICS0FFn1%2B%2Fzvc7haLFRWQY44hD33IrDbbqIPuqyiTWScAiAEZBvSDWqNAeWXKuO9guabncRs83F5SvMXcG6bcm5VvCq4BQgzEAUaDDI3MzU3MDE5NTQzMyIMMJgboLCWdy4H%2FLuyKpUF1wLQy38l0OcytnzlBo37I8x1ta%2BMS2BzJiwypJS%2Be8z%2B%2Fb5LRA2vx%2BJ%2FEGhhRG5%2BGQVtdHk3b6IV1ZXjjF3z4slkNMzBmzG3pSW61A4TNQ1SY233JRF6MQMeaFtAv%2BiOkgLdCP4%2BP4%2F0Hq9to6hmIxAChG8ZSTYznV%2FkbwcaOhQUy0a8ps4h6KHRL7ux9MPpVNnKra7ODWwxw1AC%2BcfCxEtVZXtDZosNbYIACgXpNrsod6drpSnOMOF87uP6ParabNalKppC3Bwh0zixyFIJ%2BBIuGwFmRfd51k7pAhv0O59v31jFJQ6yVM6ons51t45Yiv7jlEGcguhcG3dO6A4vXQ8pe%2Fcqa6wHIFLCHqN2ZJzsbRpQKfaDNqrmX4i8x7ZSO2h3ptV9%2FwOGEp5qKPAVast2Azp36rkW%2BNvL61Fri4JNm9sZWlKYlNRDordBdZ%2FD27Gm9c4H6slCak6rR6N3dx5KrmXNUDeM56AuCNipkC56n1wrXMh8dGoa7CRR5koFSP0kD9B%2ByrZ4SGudepamQS3yB1qOsvX9Xl1WJmBLNH42ueFh2rICihvVdP3kjM2UB22iqhBrSt5gJg%2FIrT0vTAP0cUPlAkFkVBPbOpVX%2BZLjQGF%2B3KmmlIbjXdKKLQ%2Fi18RevtAp6xuXIhP%2FOxjmuf4nsE2PyHJIz2RY%2B%2B%2BED%2Fprkj4euzcXr%2BhO6QfM0W3rqmAi30lLCtUxlVl%2FEGYCKMytwhWP4zCiZkNbh%2Ble%2F53YWoit9iqpo7%2FMsppdRFMyks31Vr5s8SzpHbyOW%2FWIuRudHSbuqHVZHtZFrkwO%2BbgRWHotPGeULSCf3JSQ3hr%2BoaXr01jmg0MCDC%2BOYooA%2BKz8ak5JiIeUwnNbqGDYWtdH3pjBUzDdye7RBjqyARkKxrNRJnHsdSWsDePcoNQ8ZBR4qy07PJD%2FP0p5yRdgU8bfIU%2FpabEV%2FyFMN6hBRUWQQFfq2BwfjOxNYk%2BOU2Q2BRxbILbznTNP8QPMuPHKFlp7PcJb%2Bo0%2FnH5gKaIhy7Lzo80bv7KctgwHEipnSS8z5XkWrsHc%2BX0FhKYnmQWTIFSGpUzjOrttWOX8Ea6BVgjsiktyr9VzU%2BJvMoTLbPQbQpXesvmm%2F69b38bfTvo2GsU%3D&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47UU2XXR6N6%2F20260624%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260624T101342Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=6b7b61b810b00eb9318c822b4ec172cf595d3ce0527aa67327be0183e805c46c 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=IQoJb3JpZ2luX2VjEGoaCWV1LXdlc3QtMSJGMEQCICS0FFn1%2B%2Fzvc7haLFRWQY44hD33IrDbbqIPuqyiTWScAiAEZBvSDWqNAeWXKuO9guabncRs83F5SvMXcG6bcm5VvCq4BQgzEAUaDDI3MzU3MDE5NTQzMyIMMJgboLCWdy4H%2FLuyKpUF1wLQy38l0OcytnzlBo37I8x1ta%2BMS2BzJiwypJS%2Be8z%2B%2Fb5LRA2vx%2BJ%2FEGhhRG5%2BGQVtdHk3b6IV1ZXjjF3z4slkNMzBmzG3pSW61A4TNQ1SY233JRF6MQMeaFtAv%2BiOkgLdCP4%2BP4%2F0Hq9to6hmIxAChG8ZSTYznV%2FkbwcaOhQUy0a8ps4h6KHRL7ux9MPpVNnKra7ODWwxw1AC%2BcfCxEtVZXtDZosNbYIACgXpNrsod6drpSnOMOF87uP6ParabNalKppC3Bwh0zixyFIJ%2BBIuGwFmRfd51k7pAhv0O59v31jFJQ6yVM6ons51t45Yiv7jlEGcguhcG3dO6A4vXQ8pe%2Fcqa6wHIFLCHqN2ZJzsbRpQKfaDNqrmX4i8x7ZSO2h3ptV9%2FwOGEp5qKPAVast2Azp36rkW%2BNvL61Fri4JNm9sZWlKYlNRDordBdZ%2FD27Gm9c4H6slCak6rR6N3dx5KrmXNUDeM56AuCNipkC56n1wrXMh8dGoa7CRR5koFSP0kD9B%2ByrZ4SGudepamQS3yB1qOsvX9Xl1WJmBLNH42ueFh2rICihvVdP3kjM2UB22iqhBrSt5gJg%2FIrT0vTAP0cUPlAkFkVBPbOpVX%2BZLjQGF%2B3KmmlIbjXdKKLQ%2Fi18RevtAp6xuXIhP%2FOxjmuf4nsE2PyHJIz2RY%2B%2B%2BED%2Fprkj4euzcXr%2BhO6QfM0W3rqmAi30lLCtUxlVl%2FEGYCKMytwhWP4zCiZkNbh%2Ble%2F53YWoit9iqpo7%2FMsppdRFMyks31Vr5s8SzpHbyOW%2FWIuRudHSbuqHVZHtZFrkwO%2BbgRWHotPGeULSCf3JSQ3hr%2BoaXr01jmg0MCDC%2BOYooA%2BKz8ak5JiIeUwnNbqGDYWtdH3pjBUzDdye7RBjqyARkKxrNRJnHsdSWsDePcoNQ8ZBR4qy07PJD%2FP0p5yRdgU8bfIU%2FpabEV%2FyFMN6hBRUWQQFfq2BwfjOxNYk%2BOU2Q2BRxbILbznTNP8QPMuPHKFlp7PcJb%2Bo0%2FnH5gKaIhy7Lzo80bv7KctgwHEipnSS8z5XkWrsHc%2BX0FhKYnmQWTIFSGpUzjOrttWOX8Ea6BVgjsiktyr9VzU%2BJvMoTLbPQbQpXesvmm%2F69b38bfTvo2GsU%3D&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47UU2XXR6N6%2F20260624%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260624T101342Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=9317ae80e3a49a276c800c284863d8b9c48ab9f3ca3f595557c1a1f8b30fafe4 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=IQoJb3JpZ2luX2VjEGoaCWV1LXdlc3QtMSJGMEQCICS0FFn1%2B%2Fzvc7haLFRWQY44hD33IrDbbqIPuqyiTWScAiAEZBvSDWqNAeWXKuO9guabncRs83F5SvMXcG6bcm5VvCq4BQgzEAUaDDI3MzU3MDE5NTQzMyIMMJgboLCWdy4H%2FLuyKpUF1wLQy38l0OcytnzlBo37I8x1ta%2BMS2BzJiwypJS%2Be8z%2B%2Fb5LRA2vx%2BJ%2FEGhhRG5%2BGQVtdHk3b6IV1ZXjjF3z4slkNMzBmzG3pSW61A4TNQ1SY233JRF6MQMeaFtAv%2BiOkgLdCP4%2BP4%2F0Hq9to6hmIxAChG8ZSTYznV%2FkbwcaOhQUy0a8ps4h6KHRL7ux9MPpVNnKra7ODWwxw1AC%2BcfCxEtVZXtDZosNbYIACgXpNrsod6drpSnOMOF87uP6ParabNalKppC3Bwh0zixyFIJ%2BBIuGwFmRfd51k7pAhv0O59v31jFJQ6yVM6ons51t45Yiv7jlEGcguhcG3dO6A4vXQ8pe%2Fcqa6wHIFLCHqN2ZJzsbRpQKfaDNqrmX4i8x7ZSO2h3ptV9%2FwOGEp5qKPAVast2Azp36rkW%2BNvL61Fri4JNm9sZWlKYlNRDordBdZ%2FD27Gm9c4H6slCak6rR6N3dx5KrmXNUDeM56AuCNipkC56n1wrXMh8dGoa7CRR5koFSP0kD9B%2ByrZ4SGudepamQS3yB1qOsvX9Xl1WJmBLNH42ueFh2rICihvVdP3kjM2UB22iqhBrSt5gJg%2FIrT0vTAP0cUPlAkFkVBPbOpVX%2BZLjQGF%2B3KmmlIbjXdKKLQ%2Fi18RevtAp6xuXIhP%2FOxjmuf4nsE2PyHJIz2RY%2B%2B%2BED%2Fprkj4euzcXr%2BhO6QfM0W3rqmAi30lLCtUxlVl%2FEGYCKMytwhWP4zCiZkNbh%2Ble%2F53YWoit9iqpo7%2FMsppdRFMyks31Vr5s8SzpHbyOW%2FWIuRudHSbuqHVZHtZFrkwO%2BbgRWHotPGeULSCf3JSQ3hr%2BoaXr01jmg0MCDC%2BOYooA%2BKz8ak5JiIeUwnNbqGDYWtdH3pjBUzDdye7RBjqyARkKxrNRJnHsdSWsDePcoNQ8ZBR4qy07PJD%2FP0p5yRdgU8bfIU%2FpabEV%2FyFMN6hBRUWQQFfq2BwfjOxNYk%2BOU2Q2BRxbILbznTNP8QPMuPHKFlp7PcJb%2Bo0%2FnH5gKaIhy7Lzo80bv7KctgwHEipnSS8z5XkWrsHc%2BX0FhKYnmQWTIFSGpUzjOrttWOX8Ea6BVgjsiktyr9VzU%2BJvMoTLbPQbQpXesvmm%2F69b38bfTvo2GsU%3D&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47UU2XXR6N6%2F20260624%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260624T101342Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=9317ae80e3a49a276c800c284863d8b9c48ab9f3ca3f595557c1a1f8b30fafe4\" 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}]}}