Convert Excel formula for use in Access

[mlubbs]

I have an excel worksheet with the following formula

=IF(b40<50000,b40*0%,IF(b40<100000,b40*2.5%,b40*5%))

and I would like to convert it for use in access.

I came up with the following:

=iif([TOTAL]<50000,[TOTAL]*0%,IIF([TOTAL]<100000,[TOTAL]*2.5%,[TOTAL]*5%))

I get the following error: "The expression you entered contains invalid syntax.

You omitted an operand or operator, you entered an invalid character or comma, or you entered text without surrounding it with quotation marks."

I am probably missing something very simple here, but I have been unable to come up with a solution.

Any help would be greatly appreciated.

Regards,

Michael

 

[pbaldy]

I don't think it likes the %. Use the actual decimal value instead.

 

[gemma-the-husky]

why [total] * 0%, why not just 0

 

[mlubbs]

As my boss decided to make things more complicated in what he was looking for I have since decided to do this in just the excel worksheet.

It should have been 0 instead of 0%

Thanks for every ones input

Mike