F1=IF($A1="","",IF($A1+COLUMN($A1)+5=COLUMN(),COLUMN()-COLUMN($A1)-5,""))当A1=两位数字,假如 当A1的数字是 17 我只想在F---O区域显示个位7 .这个公式需要怎么改动?
来源:学生作业帮助网 编辑:作业帮 时间:2024/07/30 23:18:29
![F1=IF($A1=](/uploads/image/z/10265725-37-5.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%E5%BD%93A1%3D%E4%B8%A4%E4%BD%8D%E6%95%B0%E5%AD%97%2C%E5%81%87%E5%A6%82+%E5%BD%93A1%E7%9A%84%E6%95%B0%E5%AD%97%E6%98%AF+17+%E6%88%91%E5%8F%AA%E6%83%B3%E5%9C%A8F---O%E5%8C%BA%E5%9F%9F%E6%98%BE%E7%A4%BA%E4%B8%AA%E4%BD%8D7+.%E8%BF%99%E4%B8%AA%E5%85%AC%E5%BC%8F%E9%9C%80%E8%A6%81%E6%80%8E%E4%B9%88%E6%94%B9%E5%8A%A8%3F)
x)s3tPq4UR"G'64u`]$y]S>Mͧ{'
ycɓϦnxv˚2g@DX`hcUϚ7?MWWiϮ?]OvbbL i뚧{_ixYCߓϦ|ڵ&H> [@{ox~@eVdďh 6V