Hello.
I'm trying to do a little work on excel but it has the problem. I have a table like this:
excel last season.png
I want to check the season number in column E with the season number in column F so I write a formula like this:
=IF(F2=("Season "&E2);"yes";"no")
and put it into column G said cell G2. But it says "no" for every pair even if the number is the same. I think it was because the format of the two things weren't the same so I changed to another formula which I know a little information from Google. It was:
=IF(TEXT(F2;"0")=TEXT("Season "&E2;"0");"yes";"no")
But this time it said "no" for everything also even the number was the same.
Any one tell me know what's wrong with my formulas please. I think I didn't know something that I should have known.
Thanks.
Bookmarks