Need help on an IF Function

[Angela Meakin]

Hi

hoping someone can help me, i am trying to create an if formula, for instance if customer 1 is Vatable to add Vat to the net amount, also if Customer 2 isn't Vatable to just put in the value of net amount.  

I have included a sample of what i am trying to do

[#2]

That could be like

D2=C2*(1+0.2*(B2="Y"))

if columns on your screenshot are starting from A and VAT is 20%

[#3 · Accepted solution]

---

Hi Angela
you can do the following, in column D the totals.
=if(b2="y",c2*1.2,if(b2="n",c2,"check"))
the first if adds the VAT (assuming 20% VAT), the 2nd if adds the non vatable and check if there is a different value other then y or n


@Angela Meakin wrote:

Hi

hoping someone can help me, i am trying to create an if formula, for instance if customer 1 is Vatable to add Vat to the net amount, also if Customer 2 isn't Vatable to just put in the value of net amount.  

I have included a sample of what i am trying to do

---

[#4]

thank you it worked brilliantly