With DocHub, you can quickly cover up subject in xls from any place. Enjoy capabilities like drag and drop fields, editable text, images, and comments. You can collect electronic signatures securely, add an additional level of protection with an Encrypted Folder, and collaborate with teammates in real-time through your DocHub account. Make changes to your xls files online without downloading, scanning, printing or mailing anything.
You can find your edited record in the Documents folder of your account. Prepare, email, print out, or turn your document into a reusable template. With so many advanced tools, it’s simple to enjoy smooth document editing and management with DocHub.
Hey everyone welcome back. We are looking at the IF formula in excel and in particular, if a cell contains the word amp;#39;mintsamp;#39;, we want to bring back something if thatamp;#39;s true, and if it doesnamp;#39;t contain the word amp;#39;mintsamp;#39; we want to bring back a blank. So to do this we need to combine the SEARCH function and Iamp;#39;ll show you in two easy steps how to get it all in one formula. So letamp;#39;s get started. EQUALS, SEARCH, weamp;#39;re searching for the word amp;#39;mintsamp;#39;, comma, within the cell B4, close brackets, and it comes up with the number six. What that means is it has found the word amp;#39;mintsamp;#39; and itamp;#39;s the sixth character along where we start to find that word mints. Weamp;#39;ll drag the cell down and you can see that in the cells that donamp;#39;t contain the word amp;#39;mintsamp;#39;, it brought back an error, and where it did contain the word amp;#39;mintsamp;#39;