Adding an 'OR' Statment

[AllenMead]

I need to add an 'OR' statement to both the following formulas;

=IF(Q3="Y","Y","")

Q3 needs to be Y OR A

=IF(AND(Q3="",V3="Y"),"Y","")

V3 needs to be Y OR A

Any help would be much appreciated.

[contaminated]

Not sure but maybe...

=IF(OR(Q3={"Y","A"}),"Y","")
=IF(AND(Q3="",OR(V3={"Y","A"})),"Y","")

[AllenMead]

Spot on, thank you for your help.

[NBVC]

Allen, please remember to mark your threads as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save