[shuazien]

Can anyone tell me what the error is in this formula:

=IF(OR(State="IL",State="illinois"),(=PRODUCT(Subtotal,0.0725),"0")))

State refers to a cell ,g17, that I have named State.
Subtotal refers to a cell, h37, that I have named Subtotal

I am trying to get a sales tax amount that equals the subtotal times .0725, if Il or Illionois are entered in the state cell, if anything else is in the state cell then sales tax should equal 0.

My brain can almost grasp the problem, then I lose it....

[shuazien]

Aha!!

If I remove the equals sign before "Product", and the parenthesis that surrounded that part it works.

i.e.:

=IF(OR(State="IL",State="illinois"),PRODUCT(Subtotal,0.0725),0)

Silly me....