HELLP!! - I need a formula and I cant quite get my head around it.
I am trying to create an invoice, with a feature so we can put a percentage in one box, say 10%, and the formula will subtract 10% from the subtotal box.
Thing is, the subtotal box has a formula in it already to add up the product totals. This is what the formula is - =SUM(I28:J40)
Now the percent box is under this, so how would I get the sub total box to change if I put a percentage in the discount box? say 10% for example?
many happy cheers and rep waiting for the answer lol!!