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, 2022 in Others by Kithuzzz
• 38,020 points
1,389 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, 2022 by narikkadan
• 63,680 points

Related Questions In Others

0 votes
1 answer

Excel: Is it possible to reorder the data in 2 columns to match up if they have a certain number of characters / a string in common?

Try this: =LET(files,A1:A4, URLs,B1:B4, f,BYROW(files,LAMBDA(r,TEX ...READ MORE

answered Jan 21, 2023 in Others by narikkadan
• 63,680 points
554 views
0 votes
1 answer

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

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

answered Jan 21, 2023 in Others by narikkadan
• 63,680 points
847 views
0 votes
1 answer

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

answered Jan 26, 2023 in Others by narikkadan
• 63,680 points
693 views
0 votes
1 answer

Excel formula to get certain cell if the value is between 2 numbers

So, first with vlookup(): A formula so you ...READ MORE

answered Feb 11, 2023 in Others by Kithuzzz
• 38,020 points
1,067 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, 2022 in Others by narikkadan
• 63,680 points
1,546 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, 2022 in Mobile Development by narikkadan
• 63,680 points
512 views
0 votes
1 answer

IfError with else, does this function exist in Excel?

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

answered Dec 23, 2022 in Others by narikkadan
• 63,680 points
819 views
0 votes
1 answer

IF statement for a tax sheet does not work

Use vlookup() as that is much easier ...READ MORE

answered Mar 20, 2023 in Others by narikkadan
• 63,680 points
512 views
0 votes
1 answer

Excel - allow result to change if value is greater than

Try this: =IF(OR(C9>1200,D9>1200),E9*E$4,E9*E$3) It will determine if C9 or ...READ MORE

answered Apr 3, 2023 in Others by narikkadan
• 63,680 points
457 views
0 votes
1 answer

Excel-VBA - How to identify Target range (more than 1 cell) is deleted in a Worksheet_Change function?

You misunderstand the purpose of the function ...READ MORE

answered Sep 23, 2022 in Others by narikkadan
• 63,680 points
3,683 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