Use this instead...

=IF(C31="x","x",C31-C30)

Vaya con Dios,
Chuck, CABGx3



"Andy_Trow" wrote:

In cell C32 I have the formula =C31-C30. However on occasions cell C31 may be
x. How can I make destination cell to read x rather than #### due to the
error in the formula.

When this is fixed I will have more to follow