This should be easy, I am making formula's where some cells require to stay the same. I have been using open office recently where you just enter for instance A$3$ which will keep this as a constant no matter where you replicate the formula on a spreadsheet.
This is a full formula that I need the cell G3 to rmain always as G3:
=(G3*(E4-1)-(G3*(E4-1))/100*5)
Thanks
Bookmarks