Sorry dont know much about excel and trying to help a friend. Im using vlookup to try to calculate varrying commission percentages: when $0-100 sold money received is 1% of sale, $101-200 is 2% and so on until $501+ is 5%. The equation is =(VLOOKUP(B3,Sheet2!B3:C7,2,TRUE))*B3
When i try to populate other cells with the equation by dragging is changing the value of the $ cell (B3) but also the cells with the ranges that stay stationary (sheet2!B3:C7). This is a little confusing but some help on how to fix this or a more efficient way of calculating would be helpful.
When i try to populate other cells with the equation by dragging is changing the value of the $ cell (B3) but also the cells with the ranges that stay stationary (sheet2!B3:C7). This is a little confusing but some help on how to fix this or a more efficient way of calculating would be helpful.
