• gornius@lemmy.world
      link
      fedilink
      arrow-up
      10
      ·
      edit-2
      11 months ago

      I have a spreadsheet with items with their price and quantity bought. I want to include a discount with multiple tiers, based on how much items have been bought, and have a small table where I can define quantity and a discount that applies to that quantity. Which Excel functions should I use?

      Response:

      You can achieve this in Excel using the VLOOKUP or INDEX-MATCH functions along with the IF function.

      Create a table with quantity and corresponding discounts.

      Use VLOOKUP or INDEX-MATCH to find the discount based on the quantity in your main table.

      Use IF to apply different discounts based on quantity tiers.