Hello,
I am sorry if my title is terrible, but here is what I am looking to do:
I have an Excel with SKUs in one collum and prices in another, ~4000 rows total.
I am looking to calculate new prices based on the following rules:
If equal to or under $20, then add $2
If over $20, but equal to or under $100, then add $5
If over $100, but equal to or under $200, then add $10
If over $200, but equal to or under $300, then add $15
If over $300, then add $20
Thanks a bunch in advance!
Bookmarks