Hello,

I am still not sure what to do.

What should the fomula be and where should it go?

Thanks!

"wambui" wrote:

Peo,

You are correct on the Sales Invoice (yellow colum, green background)

I have done what you suggested and unchecked R1C1 style and also uprotected
the sheet.

Under "M36" Sub Total I will add in a new Row for the Percentage discount.
That would make this cell: 'M37'.
Now I am figuring the calculation you gave me has something to do with the
cell number? If so, would I have to adjust this formula?: =G6*(1-H6)

Thanks so much for taking the time to help me out. I really appreciate it.

:)

"Peo Sjoblom" wrote:

You are using R1C1 reference style, it's quite handy once you get the hang
of it but you are probably better of to do toolsoptionsgeneral and uncheck
R1C1

Anyway is it called Sales Invoice and the total column is yellow and the
rest (apart from the invoice) is dark green?
If so do toolsprotection and unprotect the sheet, now you could add
discount in there


--


Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
(Remove ^^ from email)