Formula in table
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
The only formula window in the proeprties is associated with Hide When formulas, which has nothing to do with what you are trying. (IMHO, Lotus screwed up by exposing this to begin with.)
ASKER