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 the number sequence in column B.

*A multiple is a number that may be divided by another a certain number of times without a remainder

Post your solution in the comments below! 🙂

Share on facebook
Share on linkedin
Share on email
  • jeffrey.johns@law.gu.se

    First attempt, with IF-statements:

    Out of curiosity without IF-statements (and by chance a fascinating discovery (for me) of the mathematical approach – google “Euler’s fizzbuzz”)

Leave a Reply