EXCEL分段函数

n<=3 s=46*n
4<n<=10 s=46*3+86*(n-3)
n>=11 s=46*3+86*7+166*(n-10)

 

=if（n<=3,46*n,if（n<=10 ,46*3+86*(n-3) ,46*3+86*7+166*(n-10)））