Formula Help

L

Lost in SC

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.
 
D

David Biddulph

=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.
 
Top