Posted March 27, 201311 yr FPCH Admin I am cross checking the percentage rate used as follows: F8: Value excluding VAT e.g. 1180 G8: VAT paid/received e.g. 180 H: VAT Percentage which I formulated as =G8/F8*(1+G8/F8) The result is 17.58%, rather than 18%, whereas if I work the other way round 1000 * 1.18 = 1180, therefore I am not sure what is wrong with my proportions, can you help me with the right formula please? View this thread Off Topic Forum - Unlike the Rest
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.