Forum Discussion

Troy_Stouffer's avatar
Troy_Stouffer
Copper Contributor
Nov 21, 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! 

Resources