函初【201401】练习题八----已开贴

yqnh · 发表于 2014-2-24 19:52

=REPT(IF(MOD(ROW(),2),"★","☆"),ROW())&REPT(IF(MOD(ROW(),2),"☆","★"),6-ROW())

复制代码

参与学习

E小影 · 发表于 2014-2-24 22:46

本帖最后由 E小影于 2014-2-26 09:50 编辑

=IF(MOD(ROW(A1),2),REPT("★",ROW(A1))&REPT("☆",6-ROW(A1)),REPT("☆",ROW(A1))&REPT("★",6-ROW(A1)))
简化下：=REPT(IF(MOD(ROW(),2),"★","☆"),ROW())&REPT(IF(MOD(ROW(),2),"☆","★"),6-ROW())

cleverzhzhf · 发表于 2014-2-25 09:46

多单元格数组，这个有点偷懒的做法：

=REPLACE("☆☆☆☆☆☆",{1;3;1;5;1},{1;4;3;2;5},REPT("★",{1;4;3;2;5}))

复制代码

正规的解法：

=LEFT(REPLACE(IF(MOD(ROW(),2),"★★★★★","☆☆☆☆☆"),ROW()+1,9,REPT(IF(MOD(ROW(),2),"☆","★"),9)),6)

复制代码

石磊. · 发表于 2014-2-25 17:27

=IF(ISODD(ROW()),REPT("★",ROW())&REPT("☆",6-ROW()),REPT("☆",ROW())&REPT("★",6-ROW()))

复制代码

lufton · 发表于 2014-2-26 16:55

=IF(MOD(ROW(A1),2)=0,REPLACE(IF(MOD(ROW(A1),2),REPT("★",ROW(A1)),REPT("☆",ROW(A1)))&REPT("☆",6-ROW(A1)),ROW(A1)+1,6-ROW(A1),REPT("★",6-ROW(A1))),IF(MOD(ROW(A1),2),REPT("★",ROW(A1)),REPT("☆",ROW(A1)))&REPT("☆",6-ROW(A1)))

紫金锤 · 发表于 2014-2-28 21:05

=REPT(IF(MOD(ROW(),2),"★","☆"),ROW())&REPT(IF(MOD(ROW(),2),"☆","★"),6-ROW())

复制代码

云子 · 发表于 2014-2-28 22:27

=IF(MOD(ROW(),2)=1,REPT("★",ROW(A1))&REPT("☆",6-ROW(A1)),REPT("☆",ROW(A1))&REPT("★",6-ROW(A1)))

复制代码

Saint_Zuo · 发表于 2014-3-6 17:47

a1中输入：=REPLACE(IF(ISODD(ROW()),REPT("☆",6),REPT("★",6)),1,ROW(),IF(ISODD(ROW()),REPT("★",ROW()),REPT("☆",ROW())))然后下拉复制

air05 · 发表于 2014-3-6 20:47

在C1单元格输入
=IF(MOD(ROW(),2)=1,REPT("★",ROW(A1))&REPT("☆",6-ROW(A1)),REPT("☆",ROW(A1))&REPT("★",6-ROW(A1)))
后下拉公式即可

开心妙妙 · 发表于 2014-3-8 12:58

IF(MOD(ROW(),2)=1,REPT("★",ROW())&REPT("☆",6-ROW()),REPT("☆",ROW())&REPT("★",6-ROW()))

复制代码

		自动登录	找回密码
密码			注册

[习题] 函初【201401】练习题八----已开贴

点评