Assign VBA Macro to apply discount on protected cell with formula

[Gtasios4]

Hi all,

I have the below quotation tool and in column O i have the line total with has the hidden formula: =M4*N4..

However i want to assign a Macro in -1%, so as to apply 1% discount in the each "line total" and then give the total. I also want to perform the same with 2% discount

I've a VBA code for inserting rows and keeping format & formulas. Would the discount vba code also work when I will insert rows?

Thanks in advance!!

 

[Gtasios4]

Hi,
In Server & Options sheet you have formula that returns '-' if no discount price.

Yet your lookup formula is testing for possibility of price in D being 0
Try changing formula to test for '-' !!

It works perfectly right!