=max(42,min(70,A1/B1))
A1:3000=max(42,min(75,A1/40))
两个数在A1和B1中C1可以用公式=if(b1/a1>70,70,if(b1/a1<42,42,b1/a1))也可以用=min(70,max(42,b1/a1))
