Forum Discussion

Troy_Stouffer's avatar
Troy_Stouffer
Copper Contributor
Nov 20, 2024

MAX & IFBLANK Formula Combined

Just wanted to say thanks to everybody out there that continues to help us less knowledgeable Excel users.

I have a range of values from K106:O110. There are situations where they are either filled with a value or they are blank. I want the maximum value of the range to be displayed in cell D275. If there is no values in the range of K106:O110. I want cell D275 to be blank. Right now I can only get a "0.000" when my range K106:O110 is blank.

Current D275 cell string:

 =MAX(IF(ISBLANK(K106:O110),"",K106:O110))

What am I doing wrong?

Thanks in advance for your help! 

Formulas and Functions

3 Replies

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    Nov 21, 2024

    As a comment, initial formula works as

    =IF( AND(ISBLANK(K106:O110)),"", MAX(K106:O110) )

     

    • Troy_Stouffer's avatar
      Troy_Stouffer
      Copper Contributor
      Nov 20, 2024

      Thank you very much. It works.

      =IF(COUNT(K106:O110), MAX(K106:O110), "")

Resources