请问下面公式中“--”(两个横线)代表什么意思呢?=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/07/04 21:26:14
![请问下面公式中“--”(两个横线)代表什么意思呢?=LOOKUP(--TEXT(D4,](/uploads/image/z/10160081-17-1.jpg?t=%E8%AF%B7%E9%97%AE%E4%B8%8B%E9%9D%A2%E5%85%AC%E5%BC%8F%E4%B8%AD%E2%80%9C--%E2%80%9D%28%E4%B8%A4%E4%B8%AA%E6%A8%AA%E7%BA%BF%EF%BC%89%E4%BB%A3%E8%A1%A8%E4%BB%80%E4%B9%88%E6%84%8F%E6%80%9D%E5%91%A2%3F%3DLOOKUP%28--TEXT%28D4%2C%22m.dd%22%29%2C%7B1.01%2C1.21%2C2.19%2C3.21%2C4.21%2C5.21%2C6.22%2C7.23%2C8.23%2C9.23%2C10.23%2C11.22%2C12.22%7D%2C%7B%22%E9%AD%94%E7%BE%AF%E5%BA%A7%22%2C%22%E6%B0%B4%E7%93%B6%E5%BA%A7%22%2C%22%E5%8F%8C%E9%B1%BC%E5%BA%A7%22%2C%22%E7%89%A1%E7%BE%8A%E5%BA%A7%22%2C%22%E9%87%91%E7%89%9B%E5%BA%A7%22%2C%22%E5%8F%8C%E5%AD%90%E5%BA%A7%22%2C%22%E5%B7%A8%E8%9F%B9%E5%BA%A7%22%2C%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},{"魔羯座","水瓶座","双鱼座","牡羊座","金牛座","双子座","巨蟹座","狮子座","处女座","天秤座","天蝎座","射手座","魔羯座"})
请问下面公式中“--”(两个横线)代表什么意思呢?=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},{"魔羯座","水瓶座","双鱼座","牡羊座","金牛座","双子座","巨蟹座","狮子座","处女座","天秤座","天蝎座","射手座","魔羯座"})