Excel challenge – FizzBuzz

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! 🙂

More blog posts

Tired of Googling?
Get the best Excel tips every week. Subscribe to our newsletter.

About the author