✓ Trusted by 500+ organizations since 2014
Back to blog
Quiz

Excel challenge – FizzBuzz

Emil
Skribent
April 6, 2021 1 min read

Excel challenge – FizzBuzz

Posted on by Emil
Let’s play a game of FizzBuzz in Excel!

Download Excel fileDownload


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

Built for Nordic business teams

See how Learnesy works for your team

12 years in market. Admin dashboard included. Courses in Swedish and Norwegian

500+ companies • 4.9 on Google
Book a demo Try free for 7 days

Try some lessons in this course for free

Fill in your e-mail address and telephone and we will give you 7 days free access to some lessons in this course.

No card required!
Skribent

Emil har jobbat på Learnesy som produktutvecklare i flera år och ligger bakom flera av Learnesys kurser. Han har en utbildning inom datavetenskap med ett stort intresse för det analytiska och teoretiska. Utöver Finska och Svenska snackar Emil även flytande Excelfunktioner!

More articles by Emil

More blog posts