Find_text required argument This is the character or sub-string we wish to find. For example 1900 is evenly divisible by 100 but not 400 since it gives you a result of 475. In this case cell A1 does contain the value Super so the formula returns the value found in cell A2 which is 100.
FIND returns 1 when find_text is empty.
Quartile Formula Table of Contents Formula. If a year is divisible by 100 but not 400 then it is not a leap year. An easier method assuming that the values were generated by a polynomial would be to note that successive divided differences y i 1 y i x i 1 x i are constant and equal to 2. To do this look up the mass of each element present in the compound and then multiply that number by the subscript that appears after its symbol in the formula.