让IF函数嵌套不受限制
!"#$%&'(!
!"
#!
)*+!,-.!"
!#
!/
$%$%!.
/$%!-/$
%!&'!
!(&
'!
&-/0
/1/!&
'
0/'2&'3./2445
/6/67/5&'3./2445/6/6785&'3+/9445 /6/67:5&'3./9445/6/67;5&'3./2445 /6/67<5&'3./2445/6/67=5&'3./2445 /6/6;>5&'3./2445445?/@@@@@@@@&'44 (./)44!0/4/6/6A/4*4
444!0/4
/6/6A84*!!!!!!44!0/!
!?/#
1/'2&'3./244
5/6/6AA5&'3./2445/6/6</5&'3./244 5<6666:5&'3./2445445?/@@@@#-/'
2&'30/B650/544@C&'31/B651/544@#' 0/B6!0/!1
/B6!1/!#+
%#
!!
#
'DE$$F/!-/
!+!!%!8+
%!+G%5+%
H2&'3DE$$F/I./2JK5
/6/6A/5&'3DE$$F/I./2445/6/6A85&'3DE$$F/I ./2445/6/6A:5&'3DE$$F/I./2445/6/6A;5 &'3DE$$F/I./2445/6/6A<5&'3DE$$F/I./244
5/6/6;>5&'3./2445/6/6A=5&'3./244 5/6/6AA@@@@@@@@!+%#5
+L%5H2&'
3DE$$F/I./2445/6/6</5&'3DE$$F/I./244 5<6666:@@
!'
DMNFOPQ$RSSSSTU$FTSU&
'"
#
!""#$!!
!%&'()*+,-,-./!"
-
"
!!!"
""!!#$#
$!$%""
#
")
*0!1233456
""
'
!%&''(!"")*+,)#
!+!&-./00123 4",5%&''(!'")*+!)6)67"/%89("",$
%"+,$%(
37789:!"";" 37789:!"";! !
#
<=>?!"";!$ %&$%<=>?
!"";!"
&$%!
$
%"
#$!
"
!'(
$%'$
%'$%!!
$%!$%)
!'
'!"
!'"
!$%$
%"$%!$%
$%'$%$%'$%$
%!!"
"
!!
&"!
!
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
*
@=7ABC>:D9999$E:A$9E< =>?!"";$%"
#