Using the OR function

[Nanaia]

I'm trying to add an OR function to an IF function. I want to say if Q2 or Q3 <12 then A5 otherwise use A4. I can get it to recognize when I say just one-like Q2, but can't get it to recognize both Q2 and Q3. I've got

=IF((OR(CSV!Q2<12)),....

Which works fine, but when I put

=IF((OR(CSV!Q2<12, CSV!R3<12))....

it doesn't reference A5, it still references A4 like it doesn't recognize CSV!R3 =<12...although it does occur to me I could be going about this wrong....

I can add more info if this isn't clear enough. I always have a heck of a time trying to explain Excel.

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

 

[Nanaia]

I just saw I mis-typed the working formula. It's not =IF((OR(CSV!Q2<12)),....
It's actually =IF(CSV!Q3<12,(....

 

[SteveO59L]

=if(or(q2<12,q3<12),a5,a4)

 

[Nanaia]

Thanks. Does the A5 and A4 have to be right after? I have them in the middle of a line of JOINTEXT cells. I have A5 in the formula if the <12 check is true, and A4 if it's false.

 

[Nanaia]

Thanks. Does the A5 and A4 have to be right after? I have them in the middle of a line of JOINTEXT cells. I have A5 in the formula if the <12 check is true, and A4 if it's false.

This is the formula I've got that isn't working
=IF(OR(CSV!Q2<12, CSV!R3<12),(REF!$A$2 & REF!B2 & REF!$A$3 & REF!D2 & REF!$A$5 & REF!$A$6 & REF!$A$7 & TEXT(REF!V2,"0.000") & REF!$A$8 & TEXT(REF!W2,"0.000") & REF!$A$9),(REF!$A$2 & REF!B2 & REF!$A$3 & REF!D2 & REF!$A$4 & REF!$A$6 & REF!$A$7 & TEXT(REF!V2,"0.000") & REF!$A$8 & TEXT(REF!W2,"0.000") & REF!$A$9))

This is the one I have with just one cell being checked instead of two, and it works
=IF(CSV!Q3<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))

 

[Nanaia]

I got it. I was referencing Q2 and R3 and it should have been R2.
Thanks for your help.
Regards,
Nanaia
"Do or do not, there is no try"~Yoda