Get instant live Excel expert help with ABS Function
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”
Here are some problems that our users have asked and received explanations on
Insert an IF function in cell E5 to calculate the total due. If the student has chosen to personalize the ring, there is an additional charge of 5% located in cell B21 that must be applied; if not, the student only pays the base price. Use appropriate relative and absolute cell references. Cell C5 contains $400 that needs the cell B21 surcharge applied to but will calculate totals for the students who didn't personalize their ring
Solved by B. B. in 29 mins
Use the HLOOKUP function in cell H11 to calculate freight cost based on the shipping class and state to which the shipment is going. Freight Cost can be referenced on the "Freight Cost" lookup table (range E5:N8). Be sure to use appropriate relative and absolute cell references.
Hint: You will need to use a function within the HLOOKUP function to determine the appropriate row.
Solved by X. C. in 23 mins
Use an IF function in Cell G15 to calculate the Net Price. There is a discount of 2% applied to the Unit Price in E15 if 2 or more items are ordered and a discount of 5% applied if 10 or more are ordered. Refer to the appropriate discounts in cells E10, E11 and E12 for your IF function arguments. Use absolute and relative references when appropriate. [6 points]
Solved by S. Q. in 11 mins
Use the VLOOKUP function in cell G11 to determine the insurance cost. Use the “Value” in cell E11 to lookup the appropriate cost on the "Insurance Cost" reference table (range K11:L18). Make sure to use relative and absolute references appropriately
Solved by I. D. in 27 mins
In cell B3, create a formula to retrieve the item within each category in cell B1. Enter an INDIRECT function to return the item numbers by category. The function will reference cell $B$1 (absolute) and index the value of the intersection of row 3 (A3) and column 1.
Nest the function in an IFERROR function to return a blank cell if no items exist within the category.
Solved by S. H. in 18 mins
Complete the following steps in the TysonsStore worksheet:
a. In cell F2, enter a formula to calculate the daily total in dollars. Multiply the value in the Daily Total
(# sold) column by the current price per box in cell H1. Use an absolute reference where appropriate
and copy the formula to cells F3:F31.
b. In cell H3, enter a formula to calculate the average daily sales in dollars.
c. In cell H4, enter a formula to find the lowest daily sales in dollars.
d. In cell H5, enter a formula to find the highest daily sales in dollars.
Solved by B. B. in 26 mins
In cell B6, add an INDEX function that will use an INDIRECT function to retrieve the department issue list for the department listed in cell B3. Use an absolute reference to B3, and then use a relative cell reference to A6 as the row_num argument. Copy the formula down to cell B9.
Solved by T. J. in 25 mins
how do i calculate the interest rate so that it is a positive number. Here is the question "Insert the PMT formula in J7 to calculate the first client's monthly payment; use appropriate relative and absolute references in your formula, do not use actual numbers. show the result as a positive number.
Solved by K. L. in 26 mins
Calculate the periodic interest rate in cell E3. I am only aloud to use absolute references.
Solved by D. H. in 24 mins
Did I calculate the beginning balance correctly?
Here is the question I'm referring to.
In cell E2 calculate the present value of an auto loan that has a $450.00 payment. 5.25% interest rate, and a four year repayment period. could you explain how to do this? Also we use pmt function and absolute references instead of mixed.
Solved by A. H. in 19 mins