Three different names as conditions to add to a formula

Ok, first of all, thank you for taking your time to read this thread and evaluate my current problem. Here's the situation that I'm having to deal with:

I currently have this formula:

Please Login or Register  to view this content.

Now, I was asked to add some extra variables to that context. Well, what about them? You see, there're three different names (which we shall name "Whiskey", "Vodka" and "Gin"). I need to make the formula understand that if any of these names is present in a given cell (A1, for instance), the return value should be of 0%. If not, it's just business as usual. I tried to fiddle with the "if(or" function a little bit and even read some pages about it but I still couldn't grasp the essence of the matter.


If is there someone here willing to give me a hand with this one, I'm gonna be really thankful. Thank you in advance!

You can add this to the beginning of your current formula:

=IF(OR(A1="Whiskey",A1="Vodka",A1="Gin"),0%,IF(ISERROR(...etc.

and then you need to put a close-bracket ) at the end.

Hope this helps.

Pete

Indeed it has, mr. Pete! If I lived there in the UK I would gladly buy you a drink in order to thank you for your support. Take care and thank you very much!

Glad to help, and thanks for marking the thread as Solved.

In addition, you could also click on the "star" icon below my post - it's cheaper than a beer !!

Pete

Not at all!

Oh that's fancy, I didn't know there was such a feature in here! It's a deal, although it's not a beer, the reputation was given. Thanks for this extra hint, when I return here in the future with another doubt I shall not forget about it