I'd like to add a row to my spreadsheet that automatically calculates mark up based on price. I.e. if the price is between $0.01 - $4.00 then it is a 150% mark up, between 4.01 and 10.00 it's 75% etc. This way I am not doing it for thousands of items all the time...Is this possible or will I have to go through each line individually?
