View Single Post
 
Old 10-14-2016, 10:39 PM
xor xor is offline Windows 10 Office 2016
Expert
 
Join Date: Oct 2015
Posts: 1,029
xor is a glorious beacon of lightxor is a glorious beacon of lightxor is a glorious beacon of lightxor is a glorious beacon of lightxor is a glorious beacon of light
Default

Take a look at the attached.

The first sheet only shows discount as a percentage in column D (just enter 15, 20, 25 etc.) and the amount in column E is automatically calculated.

The second sheet (Invoice_2) shows discount both as percent and amount.

Write back if none of the two examples give what you want.
Attached Files
File Type: xlsx Invoice.xlsx (354.5 KB, 15 views)
Reply With Quote