Select Page

Month: July 2019

SEARCH Function and FIND Function in Microsoft Excel

There are two very similar functions in Excel to look for data inside of cells matching parameters that you dictate: SEARCH and FIND. There are so similar, in fact, that one wonders why have two separate functions that perform virtually the identical results and are identical in the construct of the formula. This article will discuss he one, basic difference. SEARCH Introduction The SEARCH function is a way to find a character or string within another cell, and it will return the value associated with the starting place. In other words, if you are trying to figure out where a character is within the cell that contains a word, sentence or other type of information, you could use the SEARCH function. The format for this function is: =SEARCH(“find_text”,”within_text”,start_num). If, for example, the word “alphabet” was in cell C2, and your model needed the location of the letter “a” in that cell, you would use the formula =SEARCH(“a”,C2,1), and the result would be 1. To continue this simplistic example, if you were seeking the location of “b” in the word, the formula would be =SEARCH(“b”,C2,1), and the result would be 6. You can also use search on strings of characters. If, for example, cell F2 contains 1023-#555-A123, the formula =SEARCH(“A12”,F2,1) would yield the 11 as an answer. FIND Introduction The FIND function is another way to find a character or...

Read More

Obtaining Development Approval For Your Land

There is a right way and a wrong way to purchase "control" land before you actually exchange the funds. This is critical, critical to your developments success! You need to have this information to use in your feasibility study to determine the liability of the project. Once you have 'control' of the land, (which we will show you how to do with no risk of losing money or no money down) you need to be able to determine what you can build on this land which is determined by the appropriate governmental bodies in your area. You would already have a very good idea of ‚Äč‚Äčthis by following my guidelines for doing your market research. But unfortunately, sometimes the area size is not enough to be able to accurately determine how many 'units' can be build on this land. Your architect will have to accurately determine this for you. This is quite a simple process for the architect and than you will have to move onto obtaining a Development Approval. This is something True Developers do very early in the process. By doing this they are in effect minimizing their risk at the earliest stage of the development. So in the above mentioned article, I wrote how you do not buy land first !!!! You do your research to determine the land's 'development capacity' and once this is achieved...

Read More