perhaps,

=IF(ISERROR(A1*B1),"",A1*B1)

Mike

"Lost in SC" wrote:

I have a huge spreadsheet... I'm trying to do a formula that will multiply
two cells, however occasionlly there is text in a cell. Is there a formula
to ignore the text? This spreadsheet updates from another, so the chance of
me just not entering a formula into that cell would only work for a month.