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