Question

请教excel高手，用函数if显示有问题，请看一下，帮忙纠正错误，谢谢！

=IF(OR(B2=4,B2=9),金,"")&IF(OR(B2=5,B2=0),土,"")&IF(OR(B2=1,B2=6),水,"")&IF(OR(B2=2,B2=7),火,"")&IF(OR(B2=3,B2=8),木,"")

Answer 1

=IF(OR(B2=4,B2=9),"金",IF(OR(B2=5,B2=0),"土",IF(OR(B2=1,B2=6),"水",IF(OR(B2=2,B2=7),"火",IF(OR(B2=3,B2=8),"木","")))))
试试这个看能不能用。希望对你有用！

追问

我刚试了一下，还是不行，只能显示#name

Answer 2

=IF(OR(B2=4,B2=9),"金","")& IF(OR(B2=5,B2=0),"土","")& IF(OR(B2=1,B2=6),"水","")& IF(OR(B2=2,B2=7),"火","")& IF(OR(B2=3,B2=8),"木","")