Excel Data Validation:

Microsoft Office 2003 professional w/sp1
November 17, 2009 at 14:22:57
Specs: Windows XP
Excel Data Validation:

The following Formula will determine if the data entered into a cell (D3) is a Capital "Y". If so it will allow it, otherwise report an error.


That part of the Formula works fine, although I can't figure out how to add an additional element which will be accepted by data validation.

The additional data element to be accepted into the cell is a Capital "H"

So basically the code will either accept a Captial "Y" OR Capital "H" into cell D3.

I'm thinking an OR statement is the way to go, but can't figure out how to incorporate it into the above formula?

See More: Excel Data Validation:

Report •

November 17, 2009 at 14:50:53

Try this:


PS I don't think that UPPER() is required.

Report •

November 17, 2009 at 15:26:12
Fantastic. Thanks a lot. Now that I've seen your correct formula, it all seems so simple!!!

Report •

November 17, 2009 at 17:07:33

You're welcome.

I served my time struggling through these formulas as well !!!


Report •

Related Solutions

Ask Question