#元宵节# 【几个有趣的Excel公式。。。。】

每当你纠结的时候,那就让RANDBETWEEN()函数快速替你了断吧!比如:元宵节吃什么,让Excel替你了断吧:=Choose(RandBetween(1,2),"饺子","汤圆") ,狂按F9,看计算结果变换。。。[憨笑]

咱!会Excel 的人,就是不一样!=CHOOSE(RANDBETWEEN(1,6),"做饭","洗衣","擦地","学习","锻炼","呆着")[奸笑]

简单的自动取名公式:连续按F9,可以实现多种名称组合:= CHOOSE(RANDBETWEEN(1,4),"张","王","李","赵") & CHOOSE(RANDBETWEEN(1,4),"翠","秀","红","雅") & CHOOSE(RANDBETWEEN(1,4),"玲","芝","艳","琴") 。。。去重即可。

这才叫有个性!---讲财务的老师在 Excel 2007 中输入下面公式:=CHOOSE(RANDBETWEEN(1,2),"上课","不宜上课"),按了几下F9,然后说了声“今天不宜上课!”就华丽地走了。。。

情人节,没有情人,只好自己玩“石头剪子布”:在A1和B1单元格分别输入公式:=CHOOSE(RANDBETWEEN(1,3),"石头","剪子","布") ,然后连续按F9,看两个单元“比赛”。。。”[可怜]