Cumbersome title, sorry.......and sorry if that this is a simple one.
I use a spreadsheet to collate the hours worked on different clients and then apply the same formula to each client to work out deductions for corporation tax etc. Simply £(amount)*30%. Occasionally I need to change 30%. I want to call the % figure x and then simply change the value of x once so it applies to all of the clients. Can't quite get my head around Formulas>Define Name>Scope if that is the right way to do it.
Bookmarks