Using IF in Excel97

[lencobb]

I want to be able to print "looseletters.ca" in C2 when any text/number is entered into B2.

I have used te formula below entered into C2 but cannot get it to recognise any date entry into B2 even when using the wildcards * or ?

=IF(B2=" ","looseletters.ca,""")

I know it is probably a very simple answer but I'm a numpty when it comes to Excel.

Thanks in advance,

Len

 

[scottylad2]

I want to be able to print "looseletters.ca" in C2 when any text/number is entered into B2.

I have used te formula below entered into C2 but cannot get it to recognise any date entry into B2 even when using the wildcards * or ?

=IF(B2=" ","looseletters.ca,""")

I know it is probably a very simple answer but I'm a numpty when it comes to Excel.

Thanks in advance,

Len

this should work

=IF(B2=<>"","looseletters.ca,""")

 

[scottylad2]

this should work

=IF(B2=<>"","looseletters.ca,""")

just spotted a comma in the wrong place as well
=IF(B2=<>"","looseletters.ca","")

 

[lencobb]

hi there

Thanks for the help but I am still getting an error message in te formula when I use your formula.

Best wishes

Len

 

[jasonb75]

Try

=IF(B2<>"","looseletters.ca","")

not

=IF(B2=<>"","looseletters.ca","")

Looking for a value that fits all 3 criteria is probably causing a little confusion.

 

[scottylad2]

copied the reply as a quote, hadn't spotted the extra = in there......schoolboy error lol