excel中一个单元格A1如果满足不同数值在B1单元格返回A1-V(V是变量)的余值,怎么写函数

2025-03-22 04:31:48
推荐回答(3个)
回答1:

按照你字面意思,B1公式 : =A1-5*INT(A1/10)

回答2:

=if(a1>=10,a1-floor(a1,10)/10*5,"")

回答3:

=if(or(a1>10,a1<=20,a1-5,if(a1<=30,a1-10,if(a1<=40,a1-15,"")))