Question

In cell B13, create a formula without a function using absolute references that subtracts the values...

  1. In cell B13, create a formula without a function using absolute references that subtracts the values of cells B5 and B7 from cell B6 and then multiplies the result by cell B8. Copy the formula from cell B13 to the range C13:H13.
Engineering   Computer-Science   
0 0
Add a commentTranscribed image text
Next >

Homework Answers

Answer #1

The formula for the given problem is given below:

=($B6-($B5+$B7))*($B8)

1. Firstly the value of B5 and B7 are added together and its value is subtracted from value at Cell B6

Now the value from step 1 is multiplied by the value from Cell B8

In the below picture i have given some values in Cells B5, B6, B7 and B8 and given the formula in Cell B13.

0 0
Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
In cell B7, enter a formula without using a function to determine the profit generated at...
In cell B7, enter a formula without using a function to determine the profit generated at the Downtown location by subtracting the store’s expenses (cell B6) from the store’s sales (cell B5) for the week of March 1-7, 2018. Copy the formula you created in cell B7 to the range C7:D7.
In cell B9, create a payment function using the information provided in cells B2:B6. Make sure...
In cell B9, create a payment function using the information provided in cells B2:B6. Make sure that every cell is referenced in the formula. A B Input Area Cost of home $150,000.00 Down Payment $ 10,000.00 APR 4.00% No. Years for Loan                30 Payments Per Year                12 Output Area Monthly Payment ($5,600.00) My answer: =PMT(B4,B5*B6,B2-B3) Which comes out to $5,600.00 a month. Is this right, because i don't think so.
Enter a formula in cell B9 using the IFS function to calculate the owner's draw from...
Enter a formula in cell B9 using the IFS function to calculate the owner's draw from the company. If the value in cell B7 is greater than or equal to 500000, the draw amount is 50000. If the value in cell B7 is greater than or equal to 150000, the bonus is 5000. If the value in cell B7 is less than 150000, display the text "no draw".
add formulas to complete the table of hours used. in cell B17, create a nested formula...
add formulas to complete the table of hours used. in cell B17, create a nested formula with the IF and SUM functions that check if the total number of hours worked in week 1 (cells B9:F9) is equal to 0. if it is, the cell should display the total number of hours worked in week 1. copy the formula from cell B17 to fill the range B18:B20
Find (without using a calculator) the absolute extreme values of the function on the given interval....
Find (without using a calculator) the absolute extreme values of the function on the given interval. f(x) = x3 − 12x2 + 21x + 9 on [−1, 2] absolute min .. Your answer absolute max ..
Find (without using a calculator) the absolute extreme values of the function on the given interval....
Find (without using a calculator) the absolute extreme values of the function on the given interval. f(x) = x/x^2 +9 on [−7, 7] Solve and find the Absolute Minimum= ? and the Absolute Maximum = ?
13. Enter a formula in cell M7 using the VLOOKUP function to find an exact match...
13. Enter a formula in cell M7 using the VLOOKUP function to find an exact match for the department abbreviation. Look up the department abbreviation (cell M6) using an absolute reference, search the staff table data (the range A6:J13) using an absolute reference, and return the department name (the 2nd column).
In cell H7, create a formula that uses the NETWORKDAYS function to calculate the number of...
In cell H7, create a formula that uses the NETWORKDAYS function to calculate the number of working days between the dates in cells H5 and H6.
Create a formula using the PMT function to calculate the monthly loan payment using interest rate...
Create a formula using the PMT function to calculate the monthly loan payment using interest rate and loan period values in cells C4:C8. Enter the formula with a - (negative) sign to return positive value. Do not specify values for the optional arguments fv or type. Loan amount: $1,000,000 Interest Rate APR- 5.0% Monthly Interest Rate- 0.4% Payment periods (years)- 5 Period (months)- 60
You can create an in cell bar chart with the text function REPT! (True or False?)...
You can create an in cell bar chart with the text function REPT! (True or False?) Hint: Try the following: Put the numbers 100, 20, 80, 50 in cells A1 to A4. In cell B1 enter the formula: =Rept("o",Int(A1/5)) and copy it down. Try changing the font type to Wingdings. Play around with the numbers and see what happens. You could also try =rept(" ",int(A1/5))&"o". True False
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT