how do I =if(any one of 20 specified cell=1," ",1)

G

gwbeck

Excel formula help please. I want to check 20 cells within a spreadsheet for
a specific value. If at least one of the cells is equal to the specified
value return blank if none of the cells is equal to the specified value
return the specified value.
 
R

Ron Coderre

Try this:

=IF(COUNTIF(A1:A20,1),"",0)

Is that what you're looking for?

***********
Regards,
Ron
 
B

Bernard Liengme

Can I expand on Ron's answer?
If your data is in A1:A20 and B1 contains the "specified value" then
=IF(COUNTIF(A1:A20,B2),"",B2)
best wishes
 
Top