Find the highest result in a range of formulas

[Nigeljones]

I have a range of cells that have formulas in them that give a number as a result. I want to find the highest number. When I use MAX, the end result is always 0 as it is looking at the formula and not the result.

 

[Nigeljones]

Can you alter this formula =IF(AA5="","","1") so that the 1 is formatted as a number not text. This formula appears to be the problem.

 

[Peter_SSs]

=IF(AA5="","",1)

 

[Nigeljones]

Perfect. Thank you