=IF(A1>100,IF(100<=A1<=10,10,100),IF(A1<=10,10,A1))公式是这样的的你可以先试试可加我好友
=IF(A1>100,100,IF(AND(A1>=10,A1<=100),A1,IF(A1<10,10))
=IF(A1>100,100,IF(AND(A1>=10,A1<=100),A1,IF(A1<10,10,"")))
=if(a1>=10,if(a1>100,100,a1),10)
IF函数可以嵌套使用