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 ...
Formulas and Functions
m_tarler's avatar
m_tarler
Bronze Contributor
Nov 20, 2024

maybe try:

IF(COUNT(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