Need formula to add VAT in conditions

[jimmmi]

Hello i need a formula which adds VAT 13% if a specific word entered in cell.
In red i explain what i need. I have to type of invoices, one that i add VAT 13% and the other which i don't.
If i add the word "export invoice" in B3, i want the E3 total to just copy to F3.
I i add the word normal Invoice like B2 i want the formula to copy and add 13% to F2.
Help me please

 

[konew1]

It depends on which type of invoice you don't enter a type for.

If you leave it blank for normal invoices
=IF(b2="Export Invoice",E2,IF(OR(B2="",B2="Normal Invoice"),E2*1.13,"Check invoice type"))

If you leave it blank for export invoices
=IF(OR(B2="",b2="Export Invoice"),E2,IF(B2="Normal Invoice",E2*1.13,"Check invoice type"))

If you are not consistent with data entry then excel will also not be consistent.