EXCEL 请帮忙判断一个公示的正误！

来源：百度知道 编辑：UC知道 时间：2024/06/02 16:49:14
=IF(OR(B2={80,91,102}),B2+11,IF(OR(B2={113,125}),B2+12,IF(OR(B2={137,151}),B2+14,IF(OR(B2={165,181}),B2+16,IF(OR(B2={197,215}),B2+18,IF(OR(B2={233,253}),B2+20,IF(OR(B2={273,295}),B2+22,IF(OR(B2={317,341}),B2+24,IF(OR(B2={365,391,417}),B2+26,IF(OR(B2={443,471,499,527,555}),B2+28,IF(OR(B2={583,613,643,673}),B2+30,IF(OR(B2={703,735,767}),B2+32,IF(OR(B2={799,834,869}),B2+35,IF(OR(B2={904,944,984,1024}),B2+40,IF(OR(B2={1064,1109,1154,1199,1244,1289}),B2+45))))

你这样用if只能嵌套7层
得想其他办法了

如果一定要在一个单元格实现，不用辅助列的话，你可以用&来实现。给你写了一下，你试试

=IF(OR(B2={80,91,102}),B2+11,IF(OR(B2={113,125}),B2+12,IF(OR(B2={137,151}),B2+14,IF(OR(B2={165,181}),B2+16,IF(OR(B2={197,215}),B2+18,IF(OR(B2={233,253}),B2+20,IF(OR(B2={273,295}),B2+22,"")))))))&IF(OR(B2={317,341}),B2+24,IF(OR(B2={365,391,417}),B2+26,IF(OR(B2={443,471,499,527,555}),B2+28,IF(OR(B2={583,613,643,673}),B2+30,IF(OR(B2={703,735,767}),B2+32,IF(OR(B2={799,834,869}),B2+35,IF(OR(B2={904,944,984,1024}),B2+40,"")))))))&IF(OR(B2={1064,1109,1154,1199,1244,1289}),B2+45,"")

不知道你的公式什么意思，改为这样可以了，但是是文本格式的，
=IF(OR(B2={80,91,102}),B2+11,IF(OR(B2={113,125}),B2+12,IF(OR(B2={137,151}),B2+14,IF(OR(B2={165,181}),B2+16,IF(OR(B2={197,215}),B2+18,IF(OR(B2={233,253}),B2+20,IF(OR(B2={273,295}),B2+22,"")))))))&IF(OR(B2={317,341}),B2+24,IF(OR(B2={365,391,417}),B2+26,IF(OR(B2={443,471,499,527,555}),B2+28,IF(OR(B2={583,613,643,673}),B2+30,IF(OR(B2={703,735,767}