If statement for cell ranges to equivalent value

[Rechie]

Hi,

Formula to get a equivalent of fixed value.

Formula to type in A1:
If range A2:A10=non blank (numeric value),
then A1=20.

Appreciate your time and help.

Rechie

 

[Jacob Skaria]

Do you mean

=IF(SUM(A2:A10),20,"")

If this post helps click Yes

 

[Rechie]

Hi Jacob,

This is it, Thanks a lot for helping me and the rest.

More power!

Rechie