Zoho Spreadsheet: Using Absolute and Relative Formulas

I made a Zoho Spreadsheet using absolute and relative formulas. In order to do this I signed into my Zoho account and clicked on “docs” then “create” and then chose “spreadsheets” from the dropdown menu on the left-hand side of the screen. I chose to work with a spreadsheet I had made earlier, but I now added formulas into the spreadsheet. I right-clicked on the top of the cost column and chose “insertàcolumn after,” I named this column “future cost”, I then added a column after the profit column and called it “future profit.” The next thing I did was add new column called “inflation” and added an arbitrary inflation amount of 1.04. I added formulas in so the future cost and future profit would be automatically calculated as I changed the amount of inflation. To do this I clicked on the box directly under “future profit”, future profit is revenue minus future cost, so I typed “=d2-c2” into the box, and hit “enter”. Once the value appeared, I held my cursor on the lower right corner of the box until it aligned and dragged the corner down to highlight the rest of the spaces I wanted to calculate. The formula copied all the way down and summed in the total row at the bottom.

The next formula I made was an absolute formula. I clicked on the box beneath “future cost.” Because future cost is cost multiplied by the inflation rate, and the inflation rate stays the same for all of the items, we can use an absolute formula. I typed “=b2*$h$10” into the cell and hit enter, once the value appeared I placed my cursor on the lower right corner of the box and dragged it down the column I needed formulas in. This allowed the cost value to change as it went down the column, but it kept the value of the inflation rate the same. If I change the inflation rate and hit enter, the values for these two columns will now automatically change as well.

The spreadsheet I made can be found at the link below or embedded at the bottom of this page.

https://docs.zoho.com/sheet/published.do?rid=n9y9pabad8a7fe9034f7f894659197297bf51