Quote:
Originally Posted by SMHarman
What you really should do for clarity is put a line in it that says VAT RATE and then type the % in the box next to it and then refer all the VAT calcs to that number) Say it is in A27 that woudl be =sum(E19/(1+$A$27))
It's bad spreadsheet practice to put variables in as fixed numbers in multiple cells.
|
What a waste of time - I mean - come on - how often does the VAT rate change.......
Errrrrr - right - I see - will do that - good call!