Use of Absolute Cell Address

An alternate way to carry out the desired calculation adds a significant amount of convenience for very little additional effort. Here we will introduce the spreadsheet feature called absolute address, which designates a cell address such as, for example, HI, when you intend the cell contents to be used elsewhere as a constant, as H 1. In this example, write in FI, use pH = , and in Gl, enter your selected value of the pH (we have 

One change from the table above is the editing of F([H]) using the function key, F2. Simply surround the formula by [- LOG(] on the extreme left and [)] on the extreme right. Another difference is apparent when you enter +10 -B2 in A3 you will observe that the entire process will be carried out. Henceforth, you can test the effect of changing the initial estimate of the pH by simply writing it in Gl. 

Note that the calculated pH values shown are meant to indicate the way in which the function converges and does not pay attention to the correct number of significant figures. It should also be pointed out that sometimes the method of successive approximations is not successful. Before abandoning the method, however, a reformulation of the function should be tried. 

---