I have 3 columns on my worksheet. Column A contains codes, some are all numeric and some are alpha and numeric. Column b has dollar values. I need column c to check code in column A, and if it is between 767000 and 93971 multiply column b times 85%. If the code in column A does not fit the parameters, I would like column C to be blank or zero. I am doing something wrong.