本文介绍了Excel的公式的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

亲爱的,
我在导出公式时遇到问题
我的情况是:

如果某人的工资低于160,则按1%收取费用
如果某人的薪水少于260,则按1st 160的1%和余额的15%收取他的费用
如果某人的薪水少于100,则按第1 160的1%以及其后100000的15%和余额的25%收取费用

如果我能得到它的公式,我将非常感激

dear ,
i have a problem to derive the formula
my scenario is:

if salary of a person is less than 160,he is charged by 1%
if salary of a person is less than 260,he is charged by 1% of 1st 160 and 15% of balance
if salary of a person is less than 100,he is charged by 1% of 1st 160 and 15% of next 100000 and 25% of balance

if i could get its formula, i would be very grateful

please help me!!!!

推荐答案


这篇关于Excel的公式的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!

08-20 16:27