excel函数,如果某值>80000,则等于某数*0.1;如果某值>=60000,<80000,则等于某数乘以0.8;如果某值>=40000,<60000,则等于某数乘以0.6;如果某值>=20000,<40000,则等于某数乘以0.5;如果某值<20000,则等于某数乘以0.4,怎么命令
假设某数在A1,公式:
=LOOKUP(A1%%,{0,2,4,6,8},{0.4,0.5,0.6,0.8,0.1})*A1