How to eliminate a #VALUE! error

[Kemper]

I have this formula that I'm working with and cannot find a way to correct the error.

=IF((AND($C$7=T12:T45,$C$13=W11:W32)),"YES","NO")

Thanks for any help

 

[Nine Zero]

are you trying to say

if C7 equals the sum of T12 thru T45 AND C13 equals the sum of W11 thru W32 say YES or else say NO???

 

[Joe4]

Welcome to the Board!

Your formula doesn't really make sense. A single cell cannot be equal to an entire range, i.e.
$C$7=T12:T45
and
$C$13=W11:W32
are not valid formulas.

What are you trying to do there? Are you wanting to see if the value exists anywhere in that cell?
If so, try using COUNTIF instead, i.e.
COUNTIF(T12:T45,$C$7)>0
etc

 

[Nine Zero]

Weird... it wont let me edit ...

Well if the above post is correct do this

=IF((AND($C$7=SUM(T12:T45),$C$13=SUM(W11:W32))),"YES","NO")

 

[AlanY]

try this instead

=IF(AND(COUNTIF($T$12:$T$45,$C$7)>0,COUNTIF($W$11:$W$32,$C$13)>0),"YES","NO")

 

[Kemper]

I'm building an automotive maintenance menu. What the T12:T45 refers to is the year models and the W11:W32 refers to the vehicle mileages. I want to formula to give a Yes or No depending on the requirements at certain mileage and year models .
Thanks

 

[Kemper]

This formula gives a "NO" no matter what the entry is

 

[Kemper]

The value returns a "NO" not matter the selected data

 

[Joe4]

You still haven't really clarified what this formula should be doing (and we really cannot guess because we cannot see your data).

What exactly is in cell C7, and how does that relate to range T12:T45?
Likewise, what exactly is in cell C13, and how does that relate to range W11:W32?

Sometimes providing an actual example (with data) goes a long way in describing to us what it is you are actually trying to do.

 

[Kemper]

The C7 cell is the year and the C13 cell is the mileage.