How to use MAX IF Formula in Excel

In Excel, we can’t simply use default MAX function with a condition……(unless you are using Microsoft Office 365).But the thing is…If want to get maximum value from a range using