我的excel公式总提示错误，说不能加等号什么的，求高手做解

Question

=if(L13=80,91,if(L13=91,102,if(L13=102,113,if(L13=113,151,if(L13=151,165,if(L13=165,181,if(L13=181,197,if(L13=197,215,if(L13=215,233,if(L13=233,253,if(L13=253,273,if(L13=273,295,if(L13=295,317,if(L13=317,341,if(L13=341,365,if(L13=365,391,if(L13=391,417,if(L13=417,443,if(L13=443,471,if(L13=471,499,if(L13=499,527,if(L13=527,555,if(L13=555,583,if(L13=583,613,if(L13=613,643,if(L13=643,673,if(L13=673,7

Answer 1

IF嵌套最多不能超过7层,所以,你的IF用得太多了...能不能优化一下公式呢
=IF(L13=80,91,IF(L13=91,102,IF(L13=102,113,IF(L13=113,151,IF(L13=151,165,IF(L13=165,181,IF(L13=181,197,0)))))))+IF(L13=197,215,IF(L13=215,233,IF(L13=233,253,IF(L13=253,273,IF(L13=273,295,IF(L13=295,317,IF(L13=317,341,0)))))))+IF(L13=341,365,IF(L13=365,391,IF(L13=391,417,IF(L13=417,443,IF(L13=443,471,IF(L13=471,499,IF(L13=499,527,0)))))))+IF(L13=527,555,IF(L13=555,583,IF(L13=583,613,IF(L13=613,643,IF(L13=643,673,IF(L13=673,700,0))))))

Answer 2

if普通使用方法只能七层
虽然有办法解决七层的限制，但是你会想到公式很繁琐
建议你可以使用vlookup
你将你的基础数据列入AB二列中。
然后使用vlookup函数吧。简单的函数，看一下帮助。

Answer 3

if嵌套过多，用数组公式解决。

Answer 4

错误原因是判断语句（if）过多。excel不能超过7个if。