0
How do you calculate in Excel commission of 7 percent on all sales that are at least 25 percent above cost?
Wiki User
∙ 9y ago
Assuming the sale is in B2 and the cost in A2, you could use the following formula to do it:
=IF( B2>=A2*1.25, B2*7%, 0 )
Assuming the sale is in B2 and the cost in A2, you could use the following formula to do it:
=IF( B2>=A2*1.25, B2*7%, 0 )
Assuming the sale is in B2 and the cost in A2, you could use the following formula to do it:
=IF( B2>=A2*1.25, B2*7%, 0 )
Assuming the sale is in B2 and the cost in A2, you could use the following formula to do it:
=IF( B2>=A2*1.25, B2*7%, 0 )
Assuming the sale is in B2 and the cost in A2, you could use the following formula to do it:
=IF( B2>=A2*1.25, B2*7%, 0 )
Assuming the sale is in B2 and the cost in A2, you could use the following formula to do it:
=IF( B2>=A2*1.25, B2*7%, 0 )
Assuming the sale is in B2 and the cost in A2, you could use the following formula to do it:
=IF( B2>=A2*1.25, B2*7%, 0 )
Assuming the sale is in B2 and the cost in A2, you could use the following formula to do it:
=IF( B2>=A2*1.25, B2*7%, 0 )
Assuming the sale is in B2 and the cost in A2, you could use the following formula to do it:
=IF( B2>=A2*1.25, B2*7%, 0 )
Assuming the sale is in B2 and the cost in A2, you could use the following formula to do it:
=IF( B2>=A2*1.25, B2*7%, 0 )
Assuming the sale is in B2 and the cost in A2, you could use the following formula to do it:
=IF( B2>=A2*1.25, B2*7%, 0 )
Wiki User
∙ 9y ago
Wiki User
∙ 9y agoAssuming the sale is in B2 and the cost in A2, you could use the following formula to do it:
=IF( B2>=A2*1.25, B2*7%, 0 )
Add your answer:
Earn +20 pts
Excel-A spreadsheet is a software program that allows you to do what analyze data calculate data or chart data or all of above?
All of the above.
How do you convert Acid Ph to Percent?
You can convert pH to Percent dissociated easily using the Ka value. You can calculate the [H+] from the pH value, the [A-] from stoichiometry, and the [HA] from all of the above. It is easy to find the percent dissociation from here.
What is a 5 letter word for higher?
outdo excel
How do find percent increase and decrease?
How to find percentage? What if you need to calculate percentage increase, but not only by how much a number increased, but also the change in percentage increase between two numbers? The below online calculator will calculate percent increase, and it will also calculate percent decrease, and percent difference calculation as well --> the example will explain how it works.Math Example: How to calculate percentage increase, Decrease or Difference How to calculate percent increase between two numbers? To calculate percent difference, you need to follow these steps:1. Problem: You need to calculate percent % increase from 2 to 102. First Step: find the difference between two numbers, in this case, it's 10 - 2 = 83. Second: Take the difference, 8, and divide by the original number: 8/2 = 44. Lastly, multiply the number above by 100: 4*100 = 400%You're done! You calculated difference of a number in percent, and the answer is a percentage increase of 400%.
How do you convert pH to acidity?
You can convert pH to Percent dissociated easily using the Ka value. You can calculate the [H+] from the pH value, the [A-] from stoichiometry, and the [HA] from all of the above. It is easy to find the percent dissociation from here.
How do I Calculate interest on 100000?
To calculate an interest (as money), multiply the capital, times the interest rate (divided by 100, if it is expressed in percent), times the number of periods. The above assumes simple interest; compound interest is a bit more complicated.
What does the word Excel mean?
To excel is to do very well in something, well above average. It comes from excellent. Experts in things excel in their areas of work. The top athletes excel in their sport. Excel is also the name of the most popular spreadsheet program. It is made by Microsoft.
In excel what is the heading above the worksheet grid?
The letters in the heading above a worksheet grid are called column names.
When you have excelled during your education or at work?
You can excel in your education, when you get really good grades. You can excel in the workplace when you go above and beyond your job duties.
What does ctrl comma do in Microsoft Excel?
Ctrl-comma does not do anything in Excel. Ctrl ' copies from the cell above and Ctrl `switches to and from the formula view.
Average ACT University of Florida?
percent above 18 - 99% percent above 24 - 84%
Is 40 percent relative humidity high or low in a classroom?
It would depend on the air temperature inside the classroom. There are differences in data, but generally, experts with Energy Star and the Consumer Products Safety Commission agree that 40 percent is considered to be an acceptable relative humidity point. The CPSC says this is the minimum (and below that a humidifier should be used) while this is in the middle of what Energy Star recommends (between 30 and 50 percent). Regardless, a room should never be above 60 percent as mold and bacteria grow easier above 60 percent relative humidity.
