This is a formula I have created to calculate VAT depending on which cell is entered i.e. if an entry is made in T11 VAT is entered at 5% otherwise it is entered at 20%. I wish to add to this formula so that if an entry is made in cells J11 to Y11 which equals the amount in cell F11, it should return a value of 0(zero). Can anyone help?
September 30, 2012 5:34 PM
October 1, 2012 11:59 AM