Forum Discussion
Solved
Need help on an IF Function
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
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
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
thank you it worked brilliantly
That could be like
D2=C2*(1+0.2*(B2="Y"))
if columns on your screenshot are starting from A and VAT is 20%
