|2 suggestions that might make the solution a bit more elegant and convenient.|
1 - Use a Data Validation Drop Down in A3 to choose B, D or L. That way you won't have to deal with incorrect entries and you can shorten the formula to:
2 - Use a VLOOKUP table for your B, D and L values so that you can update the table if your prices change instead of having to edit the formula. This will be especially convenient if your prices are going to be used in multiple formulas that would all have to be updated if there were a change.
The new formula might look something like this, assuming your VLOOKUP table was in G1:H3:
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.