Forum Discussion
ISNUMBER with an IF statement help?
Basically, I need for there to be 2 ISNUMBER statements fulfilled before doing a calculation....if not, then leave the cell blank. Below so far, I have: =IF(ISNUMBER($AQ$13),AQ4/$AQ$13*100,"...
coming back to your original question: you can combine two conditions with the AND function
ISNUMBER($AQ$13) and ISNUMBER(AQ4) will be in Excel:
AND(ISNUMBER($AQ$13), ISNUMBER(AQ4))
and the whole formula will be
=IF(AND(ISNUMBER($AQ$13), ISNUMBER(AQ4)),AQ4/$AQ$13*100,"")
- Thanks!
