=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?

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
(E-Mail Removed)
"Perico" <(E-Mail Removed)> wrote in message
news:258A7786-9174-449D-A3E4-(E-Mail Removed)...
> =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?

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
> (E-Mail Removed)
> "Perico" <(E-Mail Removed)> wrote in message
> news:258A7786-9174-449D-A3E4-(E-Mail Removed)...
> > =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?
>
>
>