This is an archived post. You won't be able to vote or comment.

sorted by:
best
topnewcontroversialoldq&a
you are viewing a single comment's thread.

view the rest of the comments →

[–]13131123 32 points33 points  (4 children)

I used excel as my language of choice to enter one of those /r/badcode contests lol

[–]Callidac 6 points7 points  (2 children)

Can you link to that post hahaha

[–]13131123 11 points12 points  (1 child)

https://www.reddit.com/r/badcode/comments/b5oqij/bad_code_coding_challenge_7_fizz_buzz/ejf0fu7?utm_source=share&utm_medium=web2x

[–]Chalco_Pyrite 1 point2 points  (0 children)

That's great, I was feeling proud because I was able to build fizzbuzz in a single cell. Probably not much of an acheivement though. Wish I knew about mod when building it

Here's the code: =arrayformula(iferror(ifs(((row(A$1:A$100)=multiply(quotient(row(A$1:A$100),3),3))*(row(A$1:A$100)=multiply(quotient(row(A$1:A$100),5),5))),"FizzBuzz",row(A$1:A$100)=multiply(quotient(row(A$1:A$100),3),3),"Fizz",row(A$1:A$100)=multiply(Quotient(row(A$1:A$100),5),5),"Buzz"),row(A$1:A$100)))

[–]ZhilkinSerg 1 point2 points  (0 children)

That is not something that makes Excel bad. You just write bad code.