if-statement - (Excel) If cell is greater than then minus

Question

I’m creating an excel spreadsheet that contains the following:

• Cell B4: Number that represents Bob’s subcontractor fortnight (earning in 2 weeks) earnings.
• Cell B6: Number that represents Bob’s student allowance a fortnight.
• Cell B5: Display the the total that was subtracted from Bob’s student allowance this specific fortnight.

Subtraction of allowance: If bob earn more than $300 as subcontractor his allowance will be reduce by 0,60 cents in each dollar over $300 in his subcontractor earnings.

0,60 * (B4-300) = subtraction

Using Excel, what is the formula to calculate the remaining amount in Bob's student allowance?

I have tried the below, but it doesn't work.

IF B4>300-60% from B6

标签： if-statementexcel-formula

Answer 1

可以，然后呢..

计算 B5 的 IF 函数（从学生津贴中减去的金额）

=IF(B4>300;0,6*(B4-300);0)

如果 Bob 的收入超过 300 美元，那么每超过 300 欧元的多人游戏 0.6 美分。否则，减法等于 0 美元。

使用 Excel，计算 Bob 学生津贴中剩余金额的公式是什么？

=IF(B4>300;B6-0,6*(B4-300);0)