gornius
@gornius@lemmy.world
This is a remote user, information on this page may be incomplete. View at Source ↗
- Comment on New gameplay 11 months ago:
Dude looks like Dexter DeShawn from Cyberpunk.
- Comment on this AI thing 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.