请问下面公式中“--”(两个横线)代表什么意思呢?=LOOKUP(--TEXT(D4,"m.dd"),{1.01,1.21,2.19,3.21,4.21,5.21,6.22,7.23,8.23,9.23,10.23,11.22,12.22},{"魔羯座","水瓶座","双鱼座","牡羊座","金牛座","双子座","巨蟹座","
来源:学生作业帮助网 编辑:六六作业网 时间:2024/12/19 01:22:56
请问下面公式中“--”(两个横线)代表什么意思呢?=LOOKUP(--TEXT(D4,"m.dd"),{1.01,1.21,2.19,3.21,4.21,5.21,6.22,7.23,8.23,9.23,10.23,11.22,12.22},{"魔羯座","水瓶座","双鱼座","牡羊座","金牛座","双子座","巨蟹座","
请问下面公式中“--”(两个横线)代表什么意思呢?
=LOOKUP(--TEXT(D4,"m.dd"),{1.01,1.21,2.19,3.21,4.21,5.21,6.22,7.23,8.23,9.23,10.23,11.22,12.22},{"魔羯座","水瓶座","双鱼座","牡羊座","金牛座","双子座","巨蟹座","狮子座","处女座","天秤座","天蝎座","射手座","魔羯座"})
请问下面公式中“--”(两个横线)代表什么意思呢?=LOOKUP(--TEXT(D4,"m.dd"),{1.01,1.21,2.19,3.21,4.21,5.21,6.22,7.23,8.23,9.23,10.23,11.22,12.22},{"魔羯座","水瓶座","双鱼座","牡羊座","金牛座","双子座","巨蟹座","
因在公式中,TEXT()函数返回的数字是“文本”格式的,所以要将其转为“数值”数据.--在这是将文本数字转为数值格式数字,等效于乘-1后再乘以-1,负负得正,原数正负不变,但经过这样就可将文本型数字转变为数值型数字了.这也与乘以1等效的,如:
=LOOKUP(1*TEXT(D4,"m.dd"),{1.01,1.21,2.19,3.21,4.21,5.21,6.22,7.23,8.23,9.23,10.23,11.22,12.22},{"魔羯座","水瓶座","双鱼座","牡羊座","金牛座","双子座","巨蟹座","狮子座","处女座","天秤座","天蝎座","射手座","魔羯座"})