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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Cell shows the last typed text, no matter where it is typed 0
Formula help 1
Excel Vlookup Help 0
Formula problems 2
if/then insert date but don't want automatic updates 7
Refreshing formulas automatically 3
Excel VBA 1
Ignore text but count values in same cell 2

Back
Top