paste_image16.jpg

 

Copy everything in the Parcel, Sale Price and Total Cost Value columns to a separate worksheet.   Then enter the formula =C2/B2 in cell D2.   You can do that either by typing it directly into D2 or by typing '=' then pointing to C2, typing '/', and finally pointing to B2.   The result of 0.822039 should be displayed in D2 after you hit ENTER.

This formula uses relative references.   You can see that if you simply copy it to D3.   The formula in that cell is now '=C3/B3'.

Copy this formula down the remainder of column D.   This can be done by dragging down to the bottom of the column or double clicking the mouse with the cursor at the bottom right corner of cell D3.

c3b3.jpg