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

独奏 · 发表于 2014-2-23 11:22

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

ypf183413821 · 发表于 2014-2-23 12:43

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

huangcaiguang · 发表于 2014-2-23 12:46

本帖最后由 huangcaiguang 于 2014-2-23 14:06 编辑

A1:A5区域数组=MID(REPT("★★★★★☆☆☆☆☆",3),{5;9;13;17;21},6)
或=MID(REPT("★☆☆☆☆☆★★★★",3),{1;5;9;13;17},6)
=MID(REPT("★☆☆☆☆☆★★★★",3),row()*4-3,6)

zac0226 · 发表于 2014-2-23 13:17

=REPT(CHOOSE(MOD(ROW(A2),2)+1,"★","☆"),ROW(A1))&REPT(CHOOSE(MOD(ROW(A2),2)+1,"☆","★"),6-ROW(A1)) 长的有点不好意思了。

刀羊 · 发表于 2014-2-23 17:56

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

hsl215 · 发表于 2014-2-23 23:18

本帖最后由 hsl215 于 2014-2-23 23:49 编辑

先提交一个答案先，尽管字符还很长，
=REPT(CHOOSE(MOD(ROW(),2)+1,"☆","★"),ROW())&REPT(CHOOSE(MOD(ROW(),2)+1,"★","☆"),6-ROW())
=REPT(IF(ISODD(ROW()),"★","☆"),ROW())&REPT(IF(ISODD(ROW()),"☆","★"),6-ROW())
=REPLACE(REPT(IF(ISODD(ROW()),"☆","★"),6),1,ROW(),REPT(IF(ISODD(ROW()),"★","☆"),ROW()))

hongqiqqq · 发表于 2014-2-24 10:40

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

复制代码

9lee · 发表于 2014-2-24 13:13

A1单元格：

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

复制代码

xilin5212006 · 发表于 2014-2-24 14:46

=IF(MOD(ROW(A1),2)=0,REPLACE(REPT("★",6),1,ROW(A1),REPT("☆",ROW(A1))),REPLACE(REPT("☆",6),1,ROW(A1),REPT("★",ROW(A1)))),
下拉完成。

ly258 · 发表于 2014-2-24 16:27

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

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

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