Insert a blank row above your current cell A4. Then enter this formula in A5:
=IF(ISBLANK(A4),A3*A2*A1*0.283,A4)
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