IIF Equation question (1 Viewer)

[Doghousemom]

I need to read the value of [net] and based on the value return one of two new values. If the value is greater than zero then I want the new value (commission) to be calculated at 50%. If the value is less than zero then I want the commission to be calculated at 33.3%. I've tried the following:

=iif([net]>"0",[net]*0.5),([net]*0.333))
and
iif([net]>"0",[net]*0.5,iff([net]<"0",[net]*0.333)

Neither to any avail.

What really frosts my behind is that I decided to make my life simplier by converting an excel spreadsheet to access. I had the formula working in Excel. I'm still dealing with an MS product but the syntax (and why is if spelled iif?) etc changed. This is my excel equation =IF(H6>0,(H6*0.5),(H6*0.333)) (H6 is net).

help??

Sue

 

[Fizzio]

Try this

=iif([net]>0,[net]*0.5,[net]*0.333)

 

[Pat Hartman]

I'll say it in words. Numeric values should not be enclosed in quotes.