How do you calculate the appropiate discount using the IF function on Excel?

Posted by admin
m s asked:


I am suppose to use the IF function with an absolute reference to the discount value listed (20%). The discount only applies to orders with a quantity of two or more; otherwise the discount is zero. How am I suppose to enter this formula in Excel?
Logical_Test ?
Value_if_true ?
Value_if_false ?

Concrete Floor Paint
Share and Enjoy: These icons link to social bookmarking sites where readers can share and discover new web pages.
  • Digg
  • Bumpzee
  • del.icio.us
  • Facebook
  • Furl
  • Mixx
  • NewsVine
  • Reddit
  • StumbleUpon
  • YahooMyWeb
  • Google

  • Excel Lookup & Search Tip 9 - Vlookup to Return Prices with Quantity Discounts for Orders in Excel
  • How to calculate the original price after the discount?
  • Excel Busn Math 44: Series Trade Discounts
  • How does the Macys employee discount work?
  • How many have you been rejected a military discount because you were not in uniform?
  • How much of a discount should I give to bring in new customers at a new restaurant?
  • How much discount will I get on a Sprint Palm Pre if I am eligible for a 150 dollar discount?

    • This entry was posted on Thursday, June 24th, 2010 at 2:27 pm and is filed under Shopping. You can follow any responses to this entry through the RSS 2.0 feed. Both comments and pings are currently closed.

    « How to calculate the original price after the discount?
    How much discount do you get for having good grades and then getting auto insuracne? »

    No Responses to “How do you calculate the appropiate discount using the IF function on Excel?”

    1. cozmosis Says:
      June 26th, 2010 at 12:40 am

      A1 = 20%
      B1 to B? = Price
      C1 to C? = Order Quantity

      in D1 put this formula
      =IF(C1>=2,B1*C1*$A$1,B1*C1)