=IF(AND(VALUE(AL237)=14,VALUE(AM237)=12,TRIM(UPP ER(AN237))="S",TRIM(UPPER(AV237))="T319",TRIM(UPPE R(AJ237))="Y"),IF(VALUE(AZ237)600,600,VALUE(AZ237 )),IF(AND(VALUE(AL237)=14,VALUE(AM237)=11,TRIM(U PPER(AN237))="P",TRIM(UPPER(AV237))="T319",TRIM(UP PER(AJ237))="Y"),IF(VALUE(AZ237)600,600,VALUE(AZ2 37)),IF(AND(VALUE(AL237)<14,TRIM(UPPER(AV237))="T3 18"),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?

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
--
Don Guillett
SalesAid Software

"Perico" wrote in message
...
=IF(AND(VALUE(AL237)=14,VALUE(AM237)=12,TRIM(UPP ER(AN237))="S",TRIM(UPPER(AV237))="T319",TRIM(UPPE R(AJ237))="Y"),IF(VALUE(AZ237)600,600,VALUE(AZ237 )),IF(AND(VALUE(AL237)=14,VALUE(AM237)=11,TRIM(U PPER(AN237))="P",TRIM(UPPER(AV237))="T319",TRIM(UP PER(AJ237))="Y"),IF(VALUE(AZ237)600,600,VALUE(AZ2 37)),IF(AND(VALUE(AL237)<14,TRIM(UPPER(AV237))="T3 18"),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?

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

"Don Guillett" wrote:

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
--
Don Guillett
SalesAid Software

"Perico" wrote in message
...
=IF(AND(VALUE(AL237)=14,VALUE(AM237)=12,TRIM(UPP ER(AN237))="S",TRIM(UPPER(AV237))="T319",TRIM(UPPE R(AJ237))="Y"),IF(VALUE(AZ237)600,600,VALUE(AZ237 )),IF(AND(VALUE(AL237)=14,VALUE(AM237)=11,TRIM(U PPER(AN237))="P",TRIM(UPPER(AV237))="T319",TRIM(UP PER(AJ237))="Y"),IF(VALUE(AZ237)600,600,VALUE(AZ2 37)),IF(AND(VALUE(AL237)<14,TRIM(UPPER(AV237))="T3 18"),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?