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
|