sheet to automatically add vat to the commercials sale price

Hi All

Typical Newbie !

So I have a sheet that I need to add vat to only certain products (Commercial vehicle types)

We sell cars and vans and I need the sheet to automatically add vat to the commercials sale price

so im trying to get the formula to look at a cell which would have maybe 10 different names (Relay, Berlingo, Dispatch etc etc)(Cars do not attract VAT and obviously have different names) which would then add 20% to the sale price

Hope that make sense, wont let me add images !!!

"The following errors occurred with your submission
You are not allowed to post any kinds of links, images or videos until you post a few times".


Many thanks in advance