ExcelBanter - formula

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - formula (https://www.excelbanter.com/excel-discussion-misc-queries/151962-formula.html)

Andy_Trow

formula

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

CLR

formula

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

All times are GMT +1. The time now is 07:54 AM.