How to determine the initial cost current value and gain loss percentages first you type in the formula you want to use then select the area you want to fill in next point to the fill handle and stretch it out to ranges f4-f12 and the same for g4-j12 and click enter.