Forum Discussion
Troy_Stouffer
Nov 20, 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 ...
SergeiBaklan
Nov 21, 2024Diamond Contributor
As a comment, initial formula works as
=IF( AND(ISBLANK(K106:O110)),"", MAX(K106:O110) )