Forum Discussion
Troy_Stouffer
Nov 21, 2024Copper Contributor
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!
3 Replies
Sort By
As a comment, initial formula works as
=IF( AND(ISBLANK(K106:O110)),"", MAX(K106:O110) )
- m_tarlerBronze Contributor
maybe try:
IF(COUNT(K106:O110), MAX(K106:O110), "")
- Troy_StoufferCopper Contributor
Thank you very much. It works.
=IF(COUNT(K106:O110), MAX(K106:O110), "")