1 reply to this topic

[b00g3R]

What i want to do is look in a cell and see if there is an @ in it and to unput another cell saying Email..

Ex,

C1 has "name@whatever.com"
then in C2 it says "Email"
and if in C1 doesnt have that "@" then return saying "other"

now my formula is part right but obviously needs work..

=IF(C4="@","Email","Other")

now thats part right cuz it says other but obviously i need it to check the whole cell for any character with "@" i guess..

Please help!

Edit:
I found a way that works..

=IF(ISNUMBER(SEARCH("@",C4)),"Email", "Other")

if you have another way just let me know. Thx

Edited by b00g3R, 28 February 2008 - 05:38 PM.

[Scythar]

right,
its possible with little detour:
(beware my functions are in dutch and i dunno the equivalent, but ill try to translate)

function:
=ALS(ALS.FOUT(VIND.ALLES("@";A1;1);"other")="other";"other";"e-mail")

ALS = IF
ALS.FOUT = IF.ERROR (i guess??), this function looks at a result and if the result is a error, he replaces it with the value you put in the second part, in this case "other".
VIND.ALLES = FIND.ALL (i guess again ); this function looks at a text (here in cell A1) and searches for a specific item (here being "@"), the possible results are the place where he finds the letter, or if he didnt find it he give a #value error.

this was then nested in a IF function.