ExcelでFizzBuzz (SEQUENCE関数でLoop処理)

ExcelでFizzBuzz

適当なセルに

=LET(x,SEQUENCE(100),IFS(MOD(x,15)=0,"Fiz Buz",MOD(x,3)=0,"Fiz",MOD(x,5)=0,"Buz",TRUE,x))