Hi there! I'm trying to work on a pricing project and how much a product will lift in sales based off a certain % off. Right now, as you'll see attached, I have an item, and a price, plus an ideal % off. I need to round that % down and look to an uplift table what the lift to sales would be. Does anyone know how to do this?
Let me know if you have any questions! Thank you!!!!