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.
|