#1
|
|||
|
|||
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. |
#2
|
||||
|
||||
Try = IF(ISNUMBER("*fireplace*",B2),"yes","nothing")
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#3
|
|||
|
|||
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. |
#4
|
|||
|
|||
I guess Pecoflyer just forgot SEARCH
=IF(ISNUMBER(SEARCH("fireplace",B2)),"yes","") |
#5
|
|||
|
|||
Thanks. i actually figured it out.
=IFERROR(IF(SEARCH("Fireplace",B2),"Yes",""),"") |
#6
|
||||
|
||||
I'm getting too old for this
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
Tags |
iferror |
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 |