Hi, this is probably a simple question, here is my formula which is located in D2:
=IF(C2={"Insured","Regular Driver","Insured is Regular"},{"Insured","Regular Driver","Insured is Regular"},"What is the relation of the driver to the Insured Party?")
In C2 there is a drop down list which include the following : Insured, Regular Driver, Insured is Regular, None of the above
What I Basically want to do is if C2 is "Insured" OR "Regular Driver" OR "Insured is Regular" Then return which one of the 3 it is otherwise return the statement "What is the relation of the driver to the Insured Party?"
What is happening at the moment is that if on the drop down I select "Insured" the in D2 "Insured" is returned but for any of the other options the statement "What is the relation of the driver to the Insured Party?" is returned. I only want this to be returned if none of the above is selected from the drop down list.
Thanks!!!
Bookmarks