iff statement with a few conditions

[Eric2013]

I've been messing with this for a while, tried to work it through, searched this forum and google and probably missed what i need.



But, I need some help with an expression in Query if this is possible.

I have a parts column with net price values in it that range from .50 cents to $1,000.00. Next to that I have a column that I would like to have list price values in it that are calculated from the net price values. But, need this column to adjust using profit margins. Eg: 0-10.00 add 40% margin, 10.01-20.00 add 30%, 20.01-30.00 add 20%
«Expr» IIf( [Net $ <0, 10>, /0.6] , «truepart», «falsepart») [I know this expression is wrong]

First question I have, is can this be done using an expression? If so, can someone help me with it?

Or, do I need to build a subroutine and then an If and then statement to call them.
If so, can someone help me with it?. I’m not a vba expert by any means, but, can follow step by step.

Thanks in advance for any help.

[June7]

MarginPct: Switch([Net]<10.01, 0.4, [Net]<20.01, 0.3, [Net]>=20, 0.2)

[Eric2013]

thanks June 7 ! works great.