Combine IF Statement

[nike2000]

Hi, I am looking to combine the following IF Statements, I need some help...

The statements are:

=IIf(Abs(([FOCUS PV]-[MAD PV])/([FOCUS PV])*100)>9,"Yes","No&quot

=IIf(Abs([FOCUS PV])-Abs([MAD PV])>30000,"Yes","No&quot

Thanks,
Nike

 

[jdegeorge]

Does the 2nd one run independent of the first? Access help has good examples built in for nesting IIF, which it sounds like you're trying to do. Hope this helps.

Hope this helps!

Jim DeGeorge
Developer

 

[nike2000]

No, it wouldn't run independently.
The logic is the statement should display 'Yes' if the amount was greater than 30,000 or over 9% {I have provided this by dividing by 100).
If both are less they should display 'No'
Thanks,
Nike

 

[nike2000]

No, it wouldn't run independently.
The logic is the statement should display 'Yes' if the amount was greater than 30,000 or over 9% {I have provided this by dividing by 100).
If both are less they should display 'No'
Thanks,
Nike

 

[CosmoKramer]

This should work:

=IIf(Abs(([FOCUS PV]-[MAD PV])/([FOCUS PV])*100) > 9 Or Abs([FOCUS PV])-Abs([MAD PV]) > 30000,"Yes","No")

Let me know if this helps.....