Forum Discussion

gms4b's avatar
gms4b
Brass Contributor
Jun 24, 2019

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,"...
excel
Formulas and Functions
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Jun 24, 2019

gms4b 

 

Perhaps

=IFERROR(AQ4/$AQ$13*100,"")
  • gms4b's avatar
    gms4b
    Brass Contributor
    Jun 24, 2019

    SergeiBaklan 

     

    Duh. Hadn't considered that. Easy then.

     

    Thanks,


    Greg

     

     

    • SergeiBaklan's avatar
      SergeiBaklan
      Diamond Contributor
      Jun 24, 2019

      gms4b 

      Greg, glad to help

Resources