adding text to cell

[Daza]

Hello,
i am having problems solving this formula.
i need to check cells A1 to A5 if any of these cells have a 12 in them i need to return a "Inter" text
so in b 7 i have =if(a1:a5=12,"inter",0)
this does not work gives an error
but if i move it to under any one of the cells a1 to a5 if works only for the cell it is under.


this is the long formula that works but i would like a short one if possible

=IF(A1=12,"inter",IF(B1=12,"inter",IF(C1=12,"inter",IF(D1=12,"inter",IF(E1=12,"inter",0)))))

Thanks

[samba_ravi]

Try
=IF(COUNTIF(A1:A5,12),"Inter","0") or
=IF(COUNTIF(A1:E1,12),"Inter","0")

[Daza]

Thanks that got it, didnt realise i could use the countif for that.
Thanks heaps

[Tony Valko]

Try
=IF(COUNTIF(A1:A5,12),"Inter","0") or
=IF(COUNTIF(A1:E1,12),"Inter","0")

Probably don't want to quote the 0.

=IF(COUNTIF(A1:A5,12),"Inter",0)

=IF(COUNTIF(A1:E1,12),"Inter",0)

[samba_ravi]

Probably don't want to quote the 0.

=IF(COUNTIF(A1:A5,12),"Inter",0)

=IF(COUNTIF(A1:E1,12),"Inter",0)

You are right, by mistake it happened

[Daza]

Yes thanks saw that and removed before pasting..
tried with after seeing post and works either way.
so it all good

[Tony Valko]

Good deal. Thanks for the feedback!