Misc Stuff

Contour Interval Cal - Simple spreadsheet to calculate the spacing between contour intervals.

Search Excel cell for given text =IF(ISNUMBER(SEARCH("Text I'm Looking For",Cell I'm looking at)), "Ans if true", "ans if false")

=IF(ISNUMBER(SEARCH("u",E1)), "u", IF(ISNUMBER(SEARCH("j",E1)), "j", "") )

=IF(ISNUMBER(SEARCH("<",L2)), "0", "1")

Indy =IF(ISNUMBER(SEARCH("S",C6)), "S", IF(ISNUMBER(SEARCH("I",C6)), "I", IF(ISNUMBER(SEARCH("D",C6)), "D", "X")) )

Convert excel date to digital year ((date/365.2425)+1900)

Add text infront of copied text

=+"text"&A1

Calculating the Hydronium Ion Concentration from pH

pH to =+((10)^(-1*A1)) or =+((10)^(-1*pH))

pH =(LOG10(Hydronium Ion Concentration)*-1)