Excel

How am i to Calculate the appropriate discount using the IF function with an absolute reference to the value listed in cell I1( which is 10%) for any order with a quantity of two or more; otherwise the discount is zero. Place the calculated discount value in the discount column.

Thank you
This is within Case Grader

  1. 👍 0
  2. 👎 0
  3. 👁 52
asked by Tiler
  1. I think I see your problem. The IF function in excel is:
    @IF(logical test, value if true, value if false)

    So let column A be price, B be quantity, column C be receipts after discount. So for any sale (row i), put in the C columns cell row i:
    @IF (Bi >= 2, Ai*Bi*(1-$I$1), Ai*Bi)

    1. 👍 0
    2. 👎 0

Respond to this Question

First Name

Your Response

Similar Questions

  1. computer science

    Can you find the reason that the following pseudocode function does not return the value indicated in the comments? // The calcDiscountPrice function accepts an item’s price and // the discount percentage as arguments. It use

    asked by Terry on November 21, 2012
  2. math

    A store offers a discount of 30 percent on all reference books if a dictionary cost 12$ before the discount what is the dollar amount?

    asked by malachi alexander on November 17, 2014
  3. Math (excel formulas)

    I am finding absolute and relative differences in excel. I have a compared value of 1.00 (D6) and a reference value of 38.50 (D6). I found the absolute difference to be -37.50 (D6-D9). For the relative difference I took the

    asked by Emily on March 1, 2009
  4. Calculus (pleas help!!!)

    Find the absolute maximum and absolute minimum values of the function f(x)=(x−2)(x−5)^3+11 on each of the indicated intervals. Enter -1000 for any absolute extrema that does not exist. (A) Interval = [1,4] Absolute maximum =

    asked by Cady on April 5, 2011
  5. Calculus (pleas help!!!)

    Find the absolute maximum and absolute minimum values of the function f(x)=(x−2)(x−5)^3+11 on each of the indicated intervals. Enter -1000 for any absolute extrema that does not exist. (A) Interval = [1,4] Absolute maximum =

    asked by Cady on April 5, 2011
  6. computer

    If you want to multiply the contents of each of the cells in column C by the tax rate that appears in cell A24, use a/an A. relative cell reference. C. filter. B. absolute cell reference. D. 3-D cell reference.

    asked by eleni on October 29, 2009
  7. Calculus

    Find the absolute extrema of the function. (Round your answer to three decimal places.) f(x) = xe^-x2 on [0,2] Absolute maximum value: at x = Absolute minimum value: at x =

    asked by Anonymous on July 12, 2013
  8. Calculus

    Find the absolute extrema of the function. (Round your answer to three decimal places.) f(x) = xe-x2 on [0,2] Absolute maximum value: at x = Absolute minimum value: at x =

    asked by Shan on July 12, 2013
  9. Math(Calculus)

    Im having a real difficult time solving this question. Find the absolute extrema of the function. h(x) = e^x^(2) - 4 on [-2,2] Absolute maximum value: at x = Absolute minimum value: at x =

    asked by Chris on April 25, 2017
  10. Calculus

    Find the absolute extrema of the function on the interval [2, 9]. (Round your answers to the nearest hundredth.) g(x)=x/(ln(x)) Absolute minimum: at x = Absolute maximum: at x =

    asked by Anonymous on July 12, 2013

More Similar Questions