In excel if you want to subtract the cost of fuel 150.00 in cell R6 from the selling price in cell W6 of 26000.00 what should be the calculation look like.
Added by Tiffany P.
Step 1
Step 1: Open your Excel workbook and navigate to the worksheet that contains the cells R6 (cost of fuel) and W6 (selling price). Show more…
Show all steps
Your feedback will help us improve your experience
Supreeta N and 67 other Principles of Accounting educators are ready to help you.
Ask a new question
Labs
Want to see this concept in action?
Explore this concept interactively to see how it behaves as you change inputs.
Recommended Videos
What microsoft excel formula would I use for this? Calculate the Bonus Amounts: If the Sales Price is less than $749.99, the company will give the salesperson a bonus amount that is equal to 2% of the Sales Price. If the Sales Price is between $750.00 and $999.99, the bonus is 5%; for Sales Prices between $1000.00 and $1999.99, the bonus is 10%; and for Sales Prices over $2000.00, the bonus is 15%.
Akash M.
In cell C2, enter a formula to calculate the total sale. Multiply the quantity sold (cell B2) by the price per box (cell F1). You are going to copy this formula to cells C3:C9, so use relative and absolute references as appropriate.
In cell C6, before the comma in the IFERROR function, create a formula without using a function that divides the amount of automobile insurance sales (cell B6) by the total sales (cell B11). Use an absolute reference to cell B11 in the formula.
Recommended Textbooks
Horngren’s Cost Accounting
Cost Accounting A Managerial Emphasis
Principles of Accounting Volume 1: Financial Accounting
Watch the video solution with this free unlock.
EMAIL
PASSWORD