| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
