[已解决]求解公式

雨夜1987

如图

最佳答案

月排行榜 / 总排行榜

蓝粆

2013-12-27 11:52

=LOOKUP(A1,{1,"九";2,"八";3,"七";4,"六";5,"五"})

跳转到最佳答案楼层

十五的月亮

=VLOOKUP(A1,{1,"九";2,"八";3,"七";4,"六";5,"五";6,"四";7,"三";8,"二";9,"一"},2,)

十五的月亮

=VLOOKUP(A1,{1,"九";2,"八";3,"七";4,"六";5,"五"},2,)

蓝粆

=LOOKUP(A1,{1,"九";2,"八";3,"七";4,"六";5,"五"})

爱疯

b1=10-a1
设置b1单元格为中文大写多简单哈

baksy

=LOOKUP(1,0/(A1={1,2,3,4,5}),{"九","八","七","六","五"})

蝶·舞

1. =mid("九八七六五",a1,1)

复制代码

1. =text(10-a1,"[dbnum1]")

复制代码

zhyoucheng

蝶·舞 发表于 2013-12-27 12:05

我也来一个

1. =CHOOSE(A1,"九","八","七","六","五")

复制代码

tgydslr

1. =NUMBERSTRING(10-A1,3)

复制代码

蓝粆

蝶·舞 发表于 2013-12-27 12:05

技巧性好强...针对性也强。