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 total that was subtracted from Bob’s student allowance this specific fortnight.

Subtraction of allowance: If bob earns more than \$300 as a subcontractor his allowance will be reduced by 0,60 cents for 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?

Nov 7, 2022 in Others 89 views

## 1 answer to this question.

The IF function to calculate B5 (amount to subtract from student allowance)

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

IF Bob earns more than \$300 then multiply 0.6 cents per euro above 300. Else, the subtraction equals \$0.

• 52,760 points

## Is there an excel function to tell if a cell has a dependency?

I think there is no built-in function ...READ MORE

## Excel - return a value only if a condition is met via VBA

You could use IIf() DestSheet.Cells(erow, 9).Value = IIf(newuplift = ...READ MORE

## Is Peterson’s Algorithm a good solution for Critical Section problem? If yes, then why? If no, then why?

Peterson’s solution provides a good algorithmic description ...READ MORE

## Excel Formula - if values in columns all contain X then return

You can use the AND function: = IF(AND(A3="OK";B3="OK";C3="OK");"everything ...READ MORE

## IfError with else, does this function exist in Excel?

Next to IFERROR(), there also is the ISERROR() function, which ...READ MORE