Can someone please check this formula

[Guest]

=IF(AND(VALUE(AL237)>=14,VALUE(AM237)>=12,TRIM(UPPER(AN237))="S",TRIM(UPPER(AV237))="T319",TRIM(UPPER(AJ237))="Y"),IF(VALUE(AZ237)>600,600,VALUE(AZ237)),IF(AND(VALUE(AL237)>=14,VALUE(AM237)>=11,TRIM(UPPER(AN237))="P",TRIM(UPPER(AV237))="T319",TRIM(UPPER(AJ237))="Y"),IF(VALUE(AZ237)>600,600,VALUE(AZ237)),IF(AND(VALUE(AL237)<14,TRIM(UPPER(AV237))="T318"),IF(VALUE(AZ237)>350,350,VALUE(AZ237)),0)))

The sheet has the following values, but the problem is the cell containing
this formula is returning 0 and it should return 600:

AL237=14; AM237=12; AN237=P; AV237=T319; AJ237=Y; AZ237=650

All number cells are formatted as number. Do I have a parenthesis out of
place?

 

[Don Guillett]

I didn't look at all of this but you may want to start by
value(al237)>=12 al237>=12

formulas not case sensitive
upper(an237) an237="s"

See if that helps

 

[Guest]

Please disregard my post. I cleaned my glasses and AV237=T318. Thanks!