Cells A1,A2 & A3 are multiplied together and then multiplied by .283 to figure out weight of a square plate of steel. The answer is placed in cell A4 which contains the formula. If the plate is not square I would like to be able to enter the weight directly into cell A4 without losing the formula. Sizes and plate configuration change quite frequently and we may need to use the formula again later. The answer from cell A4 is also used on several other sheets.
Insert a blank row above your current cell A4. Then enter this formula in A5:
The user has the option of accepting what's in A5, or he may manually enter a value into A4, which will automatically be reflected in A5, an override value.
Then protect cell A5, and that should do it.
/s/ Larry This message was edited by indiantrix on 2002-10-26 10:19 This message was edited by indiantrix on 2002-10-26 10:23