Excel challenge – Binary to text

Your cryptic uncle has sent you a text message in binary and now you need to convert it back to a readable format. First, you need to convert to a decimal value. To convert from binary to decimal we use the following formula: decimal = d0×20 + d1×21 + d2×22 + … The decimal number is equal to the sum of […]

Excel challenge – FizzBuzz

The rules are simple: Count up from zero. If the current number is a multiple of 3, say “Fizz” instead of the number If it’s a multiple of 5, say “Buzz” If it’s a multiple of both 3 and 5 say, “Fizzbuzz” Write a formula for column C that plays the game of Fizzbuzz on […]