Can't figure out a simple formula!

[sebrame]

I’m trying to create a pretty basic formula in Calc, and for the life of me I can’t seem to get it right.

I’m setting up a pricing calculator for Videotape Conversion. The pricing structure is…

1 Videotape is $20
2-5 Videotapes is $13/per tape
6 or more tapes are $12 per tape

I have these prices entered on the sheet to use for the calculations so that I can alter prices easily.
The price for a single tape was easy, but everything I’ve tried beyond that gets an error.

Here is a screenshot of the sheet…

Any help offerred would be greatly appreciated.

[Villeroy]

If B3 equals 1 then 20. Bingo.
100640.ods (9.9 KB)

[karolus]

Hallo

price_lookup.ods (11.0 KB)

[sebrame]

The only issue that I have with VLOOKUP is that if there is no number of video tapes entered, the VLOOKUP returns #N/A, which messes up any other calculations using the VLOOKUP cell.

[karolus]

Hallo

=IFNA(B2*VLOOKUP(B2;$D$3:$E$5;2);"")