I am building an Excel worksheet to calculate the retail price of tires. I want it to look at column 'A' and if A < Y, divide by .7 and if A > Y but A < X divide by .75 and if A > X divide by .8.

I can get parts of it to work, but when I try to put all the c... Login to read more.