EXCEl 函数问题,A列有任意数值 ,如果A列数值等于50,则在B列返回50,如...答:B1输入公式 如果小于50,A数值,50-59,A*3-50,大于60,A*3-100 =LOOKUP(A1,{0,50;50,A1*2-50;60,A1*3-100})公式下拉。按你的题意,小于50怎么处理没说,直接空值,如果有值,把""替换就行了。=IF(A1=50,A1,IF(A1>=60,A1*3-100,IF(A1>=50,A1<60),A1*2-50,"")))...
if函数求助答:=LOOKUP(B1,{"A","B","C","D","E","F","G","H"},{"A对应的值","A对应的值","B对应的值","C对应的值","D对应的值","E对应的值","F对应的值","G对应的值","H对应的值"})如:=LOOKUP(B1,{"A","B","C","D","E","F","G","H"},{"[进仓单]","[出仓单...