What do the logical operators AND, OR, XOR and NOT do?
AND (both conditions on either side of the AND operation MUST be satisfied for the IF function to work)
OR (either condition on each side of the OR operation MUST be satisfied for the IF function to work)
NOT (used when something needs to be displayed UNLESS a value is a certain amount/type/name etc.)
XOR (used when exclusively ONE of the conditions has to be met – not both! This is where XOR and OR differ.)
CD
Related Computing A Level answers
All answers ▸What is the range of denary numbers that can be represented using 8-bit two’s complement binary integers?
Why are bit patterns often displayed in hexadecimal notation instead of binary notation?
Define resolution in regards to images and how it differs from colour depth
How do you convert from binary to decimal?