Using IF, AND, OR together

[Nanaia]

Since you are all so wonderful at helping, I have another question.

I'm trying to nest IF, AND, and OR together. I want to tell it IF Q2<12, OR R2<12 AND B2=V are TRUE, then A5, if false then A4. My current working formula is however it doesn't have the AND function in it because I'm not sure how to add it.

=IF(OR(CSV!Q3<12,CSV!R3<12),(REF!$A$2 & REF!B3 & REF!$A$3 & REF!D3 & REF!$A$5 & REF!$A$6 & REF!$A$7 & TEXT(REF!V3,"0.000") & REF!$A$8 & TEXT(REF!W3,"0.000") & REF!$A$9),(REF!$A$2 & REF!B3 & REF!$A$3 & REF!D3 & REF!$A$4 & REF!$A$6 & REF!$A$7 & TEXT(REF!V3,"0.000") & REF!$A$8 & TEXT(REF!W3,"0.000") & REF!$A$9))

Regards,
Nanaia
"Do or do not, there is no try"~Yoda

 

[steve the fish]

Thats what post #8 does

 

[Nanaia]

Excel gives VALUE ERROR when I use #8's formula in the formula I have, and it marks the entry as "special" when it isn't if I use #8's formula in Special-K99's formula.