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.

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.

=IF(AND(ISNUMBER(A1),ISNUMBER(A2)),A1*A2,"")
or
=IF(OR(ISTEXT(A1),ISTEXT(A2)),"",A1*A2)

You'll see that these give different results for empty cells.
--
David Biddulph

"Lost in SC" <Lost in wrote in message
...
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.