Comment on this AI thing

• gornius@lemmy.world ⁨2⁩ ⁨years⁩ 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.

  source

  • TheDoozer@lemmy.world ⁨2⁩ ⁨years⁩ ago

    That’s really cool, I gotta try that in the future. Thanks!

    source
  • veni_vedi_veni@lemmy.world ⁨2⁩ ⁨years⁩ ago

    It’s shunned upon in the Excel pro scene (shout-out to my boi Makro), but xlookup can be used instead

    source
  • Gork@sopuli.xyz ⁨2⁩ ⁨years⁩ ago

    Index / Match gang represent. Much more flexible than Vlookup.

    source