Hello!

Say i want A1 to show a the number 123, if A2 contains the text abc.

Wouldn't the function be:

=IF(A2="abc", 123)

Apparently this doesn't work. What am i doing wrong?

Thanks in advance! :)