Excel表格——通过一个数字的末尾来判断

要求：一个数字末尾是1、2写1，
。。。。。。。。。。3、4写2，
。。。。。。。。。。5、6写3，
。。。。。。。。。。7、8写4。下面展示 实现函数代码。

=IF(RIGHT(D1,1)="1","1",IF(RIGHT(D1,1)="2","1",IF(RIGHT(D1,1)="3","2",IF(RIGHT(D1,1)="4","2",IF(RIGHT(D1,1)="5","3",IF(RIGHT(D1,1)="6","3",IF(RIGHT(D1,1)="7","4",IF(RIGHT(D1,1)="8","4"))))))))

黑白黄是相同代码

=IF(RIGHT(D1,1)="1","1",IF(RIGHT(D1,1)="2","1",IF(RIGHT(D1,1)="3","2",IF(RIGHT(D1,1)="4","2",IF(RIGHT(D1,1)="5","3",IF(RIGHT(D1,1)="6","3",IF(RIGHT(D1,1)="7","4",IF(RIGHT(D1,1)="8","4"))))))))

=IF(RIGHT(D1,1)=“1”,“1”,IF(RIGHT(D1,1)=“2”,“1”,IF(RIGHT(D1,1)=“3”,“2”,IF(RIGHT(D1,1)=“4”,“2”,IF(RIGHT(D1,1)=“5”,“3”,IF(RIGHT(D1,1)=“6”,“3”,IF(RIGHT(D1,1)=“7”,“4”,IF(RIGHT(D1,1)=“8”,“4”))))))))

大概逻辑 如果最后一位 = 1 那么显示 1 ，否者（如果最后有一位 = 2 那么显示 1 ，否者（如果…））

错误代码：

其实不是函数输入过多参数，而是格式错了，才导致出这个错误。从照片上可以看出和正确的有一点差别。