Skip to main content
InvoicingTemplate.com main content
Sharing Is Caring! We do appreciate your efforts to let others know us!

Screenshots and Images

The printed version.

Drop-down List for Multiple Price Levels

Drop-down List for Multiple Price Levels (c5113)

c5113 now includes the customized invoice template for the latest version of Uniform Invoice Software. This is what you will see when you open drop-down-list-for-multiple-price-levels-uis.xlsx.

Drop-down List for Multiple Price Levels (UIS Edition)

Drop-down List for Multiple Price Levels - UIS edition

Download

License: Private Use (not for distribution or resale). See our Terms of Use.

You are safe to download the resources. We've added our digital signatures to the files.

DescriptionSizeDownload

Without database file. How to download and use

121 KBDownload

Download this if you have already installed UIS, but are looking for additional customized templates.

298 KBDownload

Download this if you want this design to be set as the default template by the installer program.

2.83 MBDownload

Detail

The template c5009 offers a sample for creating a sales invoice template that supports multiple price levels. This invoice template c5113 is an updated version of c5009. Here we implement a drop-down list for you to choose a price level on creating invoices.

With c5009, you specify multiple prices (5, to be specific) for each product. On creating an invoice, all the prices all loaded from the underlying Microsoft Access database and shown on the invoice form (outside the printable section). Once you specify the price level for the current customer, we use an Excel formula to pick up the applied price for the invoice being created:

=IF(ISERROR(CHOOSE(oknDiscountRate,oknDiscountPriceA_1,oknDiscountPriceB_1,
oknDiscountPriceC_1,oknDiscountPriceD_1,oknDiscountPriceE_1)),0,
(CHOOSE(oknDiscountRate,oknDiscountPriceA_1,oknDiscountPriceB_1,
oknDiscountPriceC_1,oknDiscountPriceD_1,oknDiscountPriceE_1)))

As you can see from the formula above, the proper price is chosen according to the value of "oknDiscountRate". The value of "oknDiscountRate" could be any value from 1 to 5. For example, if you enter "1" into "oknDiscountRate", then the value of "oknDiscountPriceA_1" is applied to "oknPrice_1". Then the value of "oknPrice_1" is used for calculating line totals.

This approach works but could be improved too. In this template, we'll make "oknDiscountRate" to be a drop-down list, so that you can choose a value from 1 to 5, instead of typing in manually.

To add the drop-down list to the "oknDiscountRate" cell, first switch to design mode by pushing down the "Design Mode" button on the "Invoice" ribbon tab. This unlocks the worksheet so that you can change the template layout and design.

  1. Click to select / activate the "oknDiscountRate" cell.
  2. Go to Excel "Data" ribbon tab.
  3. Click "Data Validation" in the "Data Tools" command group and then choose "Data Validation ..."
  4. From the "Allow" list, choose "List".
  5. In the "Source" section, enter "1,2,3,4,5" (without quotes).
  6. Click "OK" to create the drop-down list.
  7. Now when you click the "oknDiscountRate" cell, a down-arrow appears. Click it to expand the drop-list, which shows values from 1 to 5. You are able to choose one of the values from the list. Assigning any other values to this cell will cause Excel warning message.
  8. Exit design mode by clicking the "Design Mode" button again on the "Invoice" ribbon tab.
  9. Save the template.

That's it! As you can see it is fairly easy to create a drop-list for this invoice template which supports multiple level pricing.

Like other form designs here on InvoicingTemplate.com, Price Level Drop-down List is free (offered to you at a price of 0.00USD). It works on Windows XP and all newer versions of Windows, and Excel 2007, 2010, 2013 or 2016.

Format and Specification

Template#c5113
NameDrop-down List for Multiple Price Levels
CategorySales Invoice Template
Release DateTuesday, April 4, 2017
Format (XLS or XLSX).xlsx
Excel Version Excel 2003 / Excel 2007 / Excel 2010 / Excel 2013 / Excel 2016
Feature Gallery
Columns5
Lines30
Line Height (Points)13.50
Print Area$H$3:$O$57
Papaer Size / OrientationPortrait
Default Margins (Points)
Left18.00
Right18.00
Top73.70
Bottom73.70