If you are discounting by a percentage you could try something simple like this:
A1 (formatted General) holds the discount percentage (for 10% discount enter 10)
B1 has the formula =(100-A1)/100
Column C has the undiscounted price of the articles
The discount price in D1 has this formula =$B$1*C1 (scroll it down column D)
You can change the value in A1 to reflect any change in the discount percentage
I already have a sum in my total cell =Sum(I4:i22) I have been trying to apply the discount formula to the cell but I either get a "value" or I make it so the formula is null........
How would I apply the formula to the cell? I am using an if or statement but I don't know if that is the proper way to go......