View Single Post
  #4   Report Post  
colgor colgor is offline
Junior Member
 
Posts: 13
Default

I've had another go.

Not used VLOOKUP before, so thanks, as this function seems to be the right way to go, but the answer is still wrong.

The total should be £6,000 not £3750.

The reason being, the formula is calculating all all the sales at £15, as the number of sales is above 150, but it is not being calculated that way.

Instead, only the sales above 150 are being calculated at £15 each. The first 150 sales are being calculated broken down into the three lower pricing bands.

I will try and work out this VLOOKUP works and try to readjust the formula. If anyone can reply with the correct formula in the meantime before I post my progress that woulld be brilliant?

Thanks again
Colin