Excel formula (validation check)


I need some assistance with creating a validation check (formula).

Here's what I have in the Excel file:
- Columns D:F may have a cell values = "True"

Here's what I need to check:
- If cells in either column D or column E have a value of "True", then I must validate whether or not I have a value of "True" in associated cells in either column G or column H.  

For example, if either cell D2 or E2 has a checked checkbox (value of "True"), then I must also have a checked checkbox in either G2 or H2.  If G2 *or* H2 don't have a value = True, I want to display a message indicating "Please select a value in column G or H).

Any ideas how to create such IF statement?

Thank you,
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Rob HensonFinance AnalystCommented:
=IF(AND(OR(D2=TRUE,E2=TRUE),G2="",H2=""),"Please select a value in column G or H","")
ExpExchHelpAnalystAuthor Commented:

Thank you for the prompt response.   I appreciate your assistance.

Ok, the checkbox in E2 is checked (thus value equals "true").   For testing purposes, I have *unchecked* both cells G2 and H2 (thus, their values are now "false").   Based on this scenario, I should see the error message "Please select a value in column G or H".... however, I don't.

Anything obvious missing?

Subodh Tiwari (Neeraj)Excel & VBA ExpertCommented:
Maybe this......

=IF(AND(OR(D2=TRUE,E2=TRUE),G2=FALSE,H2=FALSE),"Please select a value in column G or H","") 

Open in new window

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
ExpExchHelpAnalystAuthor Commented:
Sktneer:  Excellent -- this formula works great!   Thank you.
Subodh Tiwari (Neeraj)Excel & VBA ExpertCommented:
You're welcome. Glad I could help.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.