问题已解决
想问一下老师把上面表格能A列已知显示成B列的数值需要怎么写公式
![](https://member.chinaacc.com/homes/resources/images/home/avatar/2.jpg)
![](/wenda/_nuxt/img/iconWarn.60bd4fe.jpg)
![](https://pic1.acc5.cn/016/95/36/89_avatar_middle.jpg?t=1714192129)
亲,表格没发过来呢
2024 04/30 13:45
![](http://member.chinaacc.com/homes/resources/images/home/avatar/2.jpg)
84784972 ![](/wenda/_nuxt/img/reply1.d92ea43.png)
![](/wenda/_nuxt/img/reply1.d92ea43.png)
2024 04/30 13:48
老师能看到表格吗
![](http://member.chinaacc.com/homes/resources/images/home/avatar/2.jpg)
84784972 ![](/wenda/_nuxt/img/reply1.d92ea43.png)
![](/wenda/_nuxt/img/reply1.d92ea43.png)
2024 04/30 15:55
老师在么,能回答问题了吗
![](https://pic1.acc5.cn/016/95/36/89_avatar_middle.jpg?t=1714192129)
朝朝老师 ![](/wenda/_nuxt/img/reply2.28c7604.png)
![](/wenda/_nuxt/img/reply2.28c7604.png)
2024 04/30 16:21
稍等,我操作下看看哈
![](https://pic1.acc5.cn/016/95/36/89_avatar_middle.jpg?t=1714192129)
朝朝老师 ![](/wenda/_nuxt/img/reply2.28c7604.png)
![](/wenda/_nuxt/img/reply2.28c7604.png)
2024 04/30 16:26
亲,公式请参考图片哈
![](http://member.chinaacc.com/homes/resources/images/home/avatar/2.jpg)
84784972 ![](/wenda/_nuxt/img/reply1.d92ea43.png)
![](/wenda/_nuxt/img/reply1.d92ea43.png)
2024 04/30 16:29
不是的老师,B列是运行的结果,已知条件只有A列,我把把B列显示出来是为了让您好看的
![](http://member.chinaacc.com/homes/resources/images/home/avatar/2.jpg)
84784972 ![](/wenda/_nuxt/img/reply1.d92ea43.png)
![](/wenda/_nuxt/img/reply1.d92ea43.png)
2024 04/30 16:34
谢谢老师,我看错了是对的
![](https://pic1.acc5.cn/016/95/36/89_avatar_middle.jpg?t=1714192129)
朝朝老师 ![](/wenda/_nuxt/img/reply2.28c7604.png)
![](/wenda/_nuxt/img/reply2.28c7604.png)
2024 04/30 16:53
不客气亲,方便的话给个好评吧,谢谢啦