# 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

## 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