Excel的公式 [英] formula for the 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!!!!

推荐答案

通过浏览这些示例，我确定您可以自行制定所需的公式.

MSDN游览 [电子表格浏览 [

By taking a tour of these samples, I''m sure that you can formulate the required formula on your own.

MSDN Tour[^]
Spread Sheet tour[^]

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