Formula error on Multiple Criteria

  • I have a formula


    IF(J95="","",IF(AA12=5,MAX(LSDMatrix!D5:LSDMatrix!H9,IF(AA12>5,MAX(LSDMatrix!D5:LSDMatrix!H9,1)+MAX(LSDMatrix!D50:LSDMatrix!H9,2)))))


    which works when AA12=5 but when AA12 is more than >5 it returns "False" rather than the answer I am looking for.


    Can anyway please tell me where I am going wrong with the formula?


    Many thanks for looking.

  • Re: Formula error on Multiple Criteria


    Maybe:


    this highlited part:
    IF(J95="","",IF(AA12=5,MAX(LSDMatrix!D5:LSDMatrix!
    H9,IF(AA12>5,


    need to closed with bracket:
    IF(J95="","",IF(AA12=5,MAX(LSDMatrix!D5:LSDMatrix!H9),IF(AA12>5,

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!