F1=IF($A1="","",IF($A1+COLUMN($A1)+5=COLUMN(),COLUMN()-COLUMN($A1)-5,"")) 求可以的套用公式公式描述:设定F.O 代表数字0-9 当A1=0 1 2.9 自动显示数字到 F-O的相应区域 上面这条公式完美的实现了 现在的新问题
来源:学生作业帮助网 编辑:作业帮 时间:2024/08/10 07:57:06
![F1=IF($A1=](/uploads/image/z/8839539-27-9.jpg?t=F1%3DIF%28%24A1%3D%22%22%2C%22%22%2CIF%28%24A1%2BCOLUMN%28%24A1%29%2B5%3DCOLUMN%28%29%2CCOLUMN%28%29-COLUMN%28%24A1%29-5%2C%22%22%29%29+%E6%B1%82%E5%8F%AF%E4%BB%A5%E7%9A%84%E5%A5%97%E7%94%A8%E5%85%AC%E5%BC%8F%E5%85%AC%E5%BC%8F%E6%8F%8F%E8%BF%B0%EF%BC%9A%E8%AE%BE%E5%AE%9AF.O+%E4%BB%A3%E8%A1%A8%E6%95%B0%E5%AD%970-9+%E5%BD%93A1%3D0+1+2.9+%E8%87%AA%E5%8A%A8%E6%98%BE%E7%A4%BA%E6%95%B0%E5%AD%97%E5%88%B0+F-O%E7%9A%84%E7%9B%B8%E5%BA%94%E5%8C%BA%E5%9F%9F+%E4%B8%8A%E9%9D%A2%E8%BF%99%E6%9D%A1%E5%85%AC%E5%BC%8F%E5%AE%8C%E7%BE%8E%E7%9A%84%E5%AE%9E%E7%8E%B0%E4%BA%86+%E7%8E%B0%E5%9C%A8%E7%9A%84%E6%96%B0%E9%97%AE%E9%A2%98)
xQoPǿd&{X$t D'~ C/@J;R1Rj0K)ȾLӾ%&>D_LH=sMy%(^NllHgOv&^%Kr{r B9à}C+hxRd7%\ Fck+C bl