Don't use that cell for calculations.

Or use a formula that gives "rest" a value.

=IF(A1="rest", 10*A2,A1*A2)

If you posted a sample of your formula that you're using perhaps someone could
offer an alternative.


Gord Dibben MS Excel MVP

On Mon, 11 Dec 2006 06:42:00 -0800, aloncillo
wrote:

how can i write on mi time shhet for example "rest" wht out #VALUE!
error apears