Welcome toVigges Developer Community-Open, Learning,Share
Welcome To Ask or Share your Answers For Others

Categories

0 votes
796 views
in Technique[技术] by (71.8m points)

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!


与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
Welcome To Ask or Share your Answers For Others

1 Answer

0 votes
by (71.8m points)

try perhaps:

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

与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
Welcome to Vigges Developer Community for programmer and developer-Open, Learning and Share
...