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?
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!