if funtion

[Rodrigues]

All
I would like to use the if function in a range of cells as below:
formula on cell B1
=if(A1:A100-"blank",10,"20")
If cells range a1:a100=blank then display10 otherwise display20.

Have tried a different formats without luck.
Many thanks in advance
R

 

[Deepak]

Here's two alternative as you want.

=IF(COUNTA(A1:A100),10,20)

=IF(COUNTBLANK(A1:A100)=100,10,20)

 

[Rodrigues]

Here's two alternative as you want.

=IF(COUNTA(A1:A100),10,20)

=IF(COUNTBLANK(A1:A100)=100,10,20)

Hi
I'm sorry, I have mentioned blank in error I meant white colour not blank cell.
So if there is white should display 10, if not 20
Thank you for your prompt reply
R

 

[Deepak]

Will u pls upload a sample indicating that.

 

[Rodrigues]

Please see attached.
Also I need (if possible) an if and or functions formula (file attached)
Thanks

 

[Deepak]

That Make sense!!

=IF(COUNTIF(A1:A100,"white"),10,20)
=IF(COUNTIF(A1:A100,{"brown","yellow","white"}),10,20)

 

[Rodrigues]

Thank you so much, exactly what I was looking for!

 

[Deepak]

This should be.

=IF(OR(COUNTIF(A1:A11,{"Blue","Green","Red"})),10,20)