I have a table that I created in a personal stationary. What i'd like to do is simply have a formula in a gross margin cell so it automatically calculates the GM%. I labeled and id each cell in my table. Formula is simply SALES - COST / SALES. Also trying to figure out how to have a cell have a currency value so when I type in a number it automatically has a dollar sign and two decimals. Sort of like the format option in excel.