Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Excel > Excel

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 09-29-2017, 07:19 AM
BrookeJ239 BrookeJ239 is offline Mac OS X Office 2016
Novice
 
Join Date: Sep 2017
Posts: 3
BrookeJ239 is on a distinguished road
Default Using IFERROR & FIND Function

I have a project that requires a formula to input a "yes or "nothing" by searching another cell for the words "Fireplace" or "Hot tub". I have figured out how to get the IFERROR function to answer "nothing" if it is not in the cell, but not sure how to get it to ssy "yes" instead of fireplace if it is in the cell it is searching.



Formula I am using :

=IFERROR(SEARCH("fireplace",B2),"")

Please help been working on this for days. Can't seem to figure it out.
Reply With Quote
  #2  
Old 09-29-2017, 08:31 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Windows 7 64bit Office 2010 64bit
Moderator
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 1,901
Pecoflyer is just really nicePecoflyer is just really nicePecoflyer is just really nicePecoflyer is just really nicePecoflyer is just really nice
Default

Try = IF(ISNUMBER("*fireplace*",B2),"yes","nothing")
Reply With Quote
  #3  
Old 09-29-2017, 08:42 AM
BrookeJ239 BrookeJ239 is offline Mac OS X Office 2016
Novice
 
Join Date: Sep 2017
Posts: 3
BrookeJ239 is on a distinguished road
Default Did not work.

Tried it, comes back with too many arguments for this function.

Here is what I am trying to do.

The boss wants the Current Rates sheet to indicate whether each cabin has a fireplace and/or a hot tub. Columns G and H have been created to contain that data, but nobody knew how to make text functions, so the columns are empty. Good thing you work here now… Your task is to create formulas in G2:H61 of the Current Rates sheet that will analyze the content of B2:B61 and display either a “Yes” or nothing (“”) to tell the user whether or not that cabin has a particular feature (fireplace for column G and hot tub for column H). Note: this will require a SEARCH or FIND function – and an IFERROR function – to complete.
Reply With Quote
  #4  
Old 09-29-2017, 09:23 AM
xor xor is offline Windows 10 Office 2016
Expert
 
Join Date: Oct 2015
Posts: 773
xor is a jewel in the roughxor is a jewel in the roughxor is a jewel in the rough
Default

I guess Pecoflyer just forgot SEARCH

=IF(ISNUMBER(SEARCH("fireplace",B2)),"yes","")
Reply With Quote
  #5  
Old 09-29-2017, 09:42 AM
BrookeJ239 BrookeJ239 is offline Mac OS X Office 2016
Novice
 
Join Date: Sep 2017
Posts: 3
BrookeJ239 is on a distinguished road
Thumbs up

Thanks. i actually figured it out.

=IFERROR(IF(SEARCH("Fireplace",B2),"Yes",""),"")
Reply With Quote
  #6  
Old 09-30-2017, 12:02 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Windows 7 64bit Office 2010 64bit
Moderator
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 1,901
Pecoflyer is just really nicePecoflyer is just really nicePecoflyer is just really nicePecoflyer is just really nicePecoflyer is just really nice
Default

I'm getting too old for this
Reply With Quote
Reply

Tags
iferror
Please reply to this thread with any new information or opinions.

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
IFERROR not (consistently) working John 1978 Excel 8 04-26-2017 12:05 AM
Using the find function between sheets mnut Excel Programming 1 10-17-2014 10:13 PM
find function default is not saved potolok Word 7 06-02-2014 06:44 AM
Find and Replace function shooting off screen to the left of the document Mattblack Word 1 04-10-2014 03:06 PM
FIND function, where? Yumin Word 2 04-02-2010 07:16 PM


All times are GMT -7. The time now is 09:33 AM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft