Excel的函数

显示全部楼层 · 2008-7-19 23:06:30

如果我想通过在Excel的A1中输入1或2或3，使B1分别输出早，午，晚。那么要用什么函数？

千问 · 2008-7-19 23:06:30

哈哈，smallcolour，我来偷你的分了，在B1输入smallcolour大师的公式“=choose(a1,"早","午","晚")”向下拖拽就可以，也可以输入“=choose(a1,"早","午","晚","你好")”如果在A1输入4，B1就会显示“你好”。向smallcolour大师学习中。

千问 · 2008-7-19 23:06:30

=IF(A1=1,"早",IF(A1=2,"午",IF(A1=3,"晚","")))如果要用1楼的=choose()函数，则要改一下更完善：=IF(ISERROR(CHOOSE(A1,"早","午","晚"))=TRUE,"",CHOOSE(A1,"早","午","晚"))则a1中非1、2、3值就不会出现“#VALUE!”

千问 · 2008-7-19 23:06:30

=choose(a1,"早","午","晚")

千问 · 2008-7-19 23:06:30

若结果总是一个字，试试下面公式。=MID("早午晚",A1,1)