Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #3  
Old 09-29-2017, 08:42 AM
BrookeJ239 BrookeJ239 is offline Using IFERROR & FIND Function Mac OS X Using IFERROR & FIND Function Office 2016
Novice
Using IFERROR & FIND Function
 
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
 

Tags
iferror



Similar Threads
Thread Thread Starter Forum Replies Last Post
Using IFERROR & FIND Function IFERROR not (consistently) working John 1978 Excel 8 04-26-2017 12:05 AM
Using IFERROR & FIND Function 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
Using IFERROR & FIND Function Find and Replace function shooting off screen to the left of the document Mattblack Word 1 04-10-2014 03:06 PM
Using IFERROR & FIND Function FIND function, where? Yumin Word 2 04-02-2010 07:16 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:23 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft