Excel If cell is greater than condition then minus number

0 votes

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 in Others by Kithuzzz
• 20,660 points
38 views

1 answer to this question.

0 votes

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.

answered Nov 7 by narikkadan
• 37,660 points

Related Questions In Others

0 votes
2 answers

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

answered Jul 6, 2020 in Others by Gitika
• 65,890 points
1,235 views
0 votes
1 answer

Is there a maximum number of formula fields allowed in Excel (2010)

See http://office.microsoft.com/en-us/excel-help/excel-specifications-and-limits-HP010073849.aspx for limits on specs it doesn't indicate ...READ MORE

answered Sep 30 in Others by narikkadan
• 37,660 points
55 views
0 votes
0 answers

What is the formula to keep first two words in a cell over excel?

I want to maintain the first two ...READ MORE

Nov 2 in Others by Kithuzzz
• 20,660 points
25 views
0 votes
1 answer

Calculate the number of days between a cell and today in excel?

Use the DATEDIF function when you want ...READ MORE

answered Nov 8 in Others by gaurav
• 22,040 points
32 views
0 votes
1 answer

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

answered Nov 4 in Others by narikkadan
• 37,660 points
38 views
0 votes
1 answer

Multiple IF statements in Excel not working

When you add an IF statement to a formula ...READ MORE

answered Nov 12 in Mobile Development by narikkadan
• 37,660 points
32 views
0 votes
1 answer

Calculate Birthdate from an age using y,m,d in Excel

Hello, yes u can find your birthdate using ...READ MORE

answered Feb 16 in Others by Edureka
• 13,640 points
142 views
0 votes
1 answer

Calculate Birthdate from an age using y,m,d in Excel

Hi To Calculate the date, we can ...READ MORE

answered Feb 16 in Others by Edureka
• 13,640 points
240 views
0 votes
1 answer
0 votes
1 answer

Excel VBA if file closed, then open and paste, else just paste data

Slightly re-worked to add full workbook/sheet qualifiers ...READ MORE

answered Sep 21 in Others by narikkadan
• 37,660 points
86 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP