exl条件计算在D求出BA不用比列下用C乘以不用的积数,如D在B/A>1.3时C*0.3且如果B/A>0.2时C*0.1.
来源:学生作业帮助网 编辑:作业帮 时间:2024/07/10 23:40:55
![exl条件计算在D求出BA不用比列下用C乘以不用的积数,如D在B/A>1.3时C*0.3且如果B/A>0.2时C*0.1.](/uploads/image/z/14757772-4-2.jpg?t=exl%E6%9D%A1%E4%BB%B6%E8%AE%A1%E7%AE%97%E5%9C%A8D%E6%B1%82%E5%87%BABA%E4%B8%8D%E7%94%A8%E6%AF%94%E5%88%97%E4%B8%8B%E7%94%A8C%E4%B9%98%E4%BB%A5%E4%B8%8D%E7%94%A8%E7%9A%84%E7%A7%AF%E6%95%B0%2C%E5%A6%82D%E5%9C%A8B%2FA%3E1.3%E6%97%B6C%2A0.3%E4%B8%94%E5%A6%82%E6%9E%9CB%2FA%3E0.2%E6%97%B6C%2A0.1.)
x)Ky6w^[|sV<}ϧx~ӎOvtOvx{)D?A&F'}G;C=gӷ9k?1(lTP&H^],/8ozi8;8tl@N $`
exl条件计算在D求出BA不用比列下用C乘以不用的积数,如D在B/A>1.3时C*0.3且如果B/A>0.2时C*0.1.
exl条件计算
在D求出BA不用比列下用C乘以不用的积数,如D在B/A>1.3时C*0.3且如果B/A>0.2时C*0.1.
exl条件计算在D求出BA不用比列下用C乘以不用的积数,如D在B/A>1.3时C*0.3且如果B/A>0.2时C*0.1.
=IF(B1/A1>1.3,C1*0.3,IF(B1/A1