If nobody has done it yet in Excel (not VBA, simple Excel formulas):
- fill series cells A1:A100 with numbers 1 through 100
- fill down cells B1:B100 with formula
=IF(MOD(A1,15)=0,"FizzBuzz",IF(MOD(A1,5)=0,"Buzz",IF(MOD(A1,3)=0,"Fizz",A1)))
If nobody has done it yet in Excel (not VBA, simple Excel formulas):
=IF(MOD(A1,15)=0,"FizzBuzz",IF(MOD(A1,5)=0,"Buzz",IF(MOD(A1,3)=0,"Fizz",A1)))