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,"...
A slight variation on the previous solution using multi-cell array formula or a dynamic array.
= IF( Theoretical * QCLow, 100 * QCLow / Theoretical, "" )
and commit with CSE or allow to spill. Within an array formula AND will take in the entire array whereas '*' will work term by term. If the non-numeric values are simple blanks then a test for non-zero will work as well as ISNUMBER.
If you then remove the zeros with a custom number format, the formula in AR4 reduces to
= IF( Theoretical, 100 * QCLow / Theoretical, "" )
and the number format is "0.0; ; ;"