multiple IIf statement doesn't work - please help

Joined
Jun 19, 2011
Messages
1
Reaction score
0
Hi,

I am really new to Microsoft Access and have tried to get a multiple IIf statement to work in a Form but it doesn't. What I want it to do is:

If Qualifying Car is true and sale price is 20% VAT then *11/66. If qualifying car is true and sale price is 17.5% VAT then *7/47. If qualifying car is false and sale price is 20% then profit *11/66. If qualifying car is false and sale price is 17.5% then profit *7/47. If profit is less than zero then render zero.

I wrote this...

=IIf([Qualifying Car]=True And [Selling VAT rate]="20",[Sale Price]*11/66,IIf([Qualifying Car]=True And [Selling VAT rate]="17.5",[Sale Price]*7/47,IIf([Qualifying Car]=False And [Selling VAT rate]="20",[Profit]*11/66,IIf([Qualifying Car]=False And [Selling VAT rate]="17.5",[Profit]*7/47))))

It doesn't work and nor do I know how to get it to show zero if the Profit is less than zero.

I have now spent days and days trying to make it happen but I just can't.

If anyone can help then I would be truly grateful.

Thanks in advance,

Sarah
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top