Formula help

[DavidBrauch]

My formula quit working. This is the formula can someone help please?
=MAX(IF($C$9:$C$500="LIVE",IF($H$9:$H$500="A",IF($I$9:$I$500="L/R",$B$9:$B$500,0))))

[#2]

You have posted on the Microsoft Learn community board which is all about exams, certification and training.
You might get a better response on the Excel community board https://techcommunity.microsoft.com/t5/excel/ct-p/Excel_Cat