Formula Help

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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