CODEWITHSUNDEEP
google-sheetsgoogle-sheets-formula
melgon
melgon

Reputation: 13

Need to convert an Excel formula to a Google Sheet formula

I created a formula that works in Excel but cannot get it to work in Google Sheets. Can someone please help?

=IF(ISNUMBER(SEARCH("amp",$A2)), "AMP", IF(ISNUMBER(SEARCH("feed",$A2)), "Feed", "Other"))

Thanks!

Upvotes: 0

Views: 40

Answers (1)

player0
player0

Reputation: 1

try perhaps:

=IF(ISNUMBER(SEARCH("amp";  A2)); "AMP", 
 IF(ISNUMBER(SEARCH("feed"; A2)); "Feed"; "Other"))

Upvotes: 1

Related Questions