General discussion

Locked

Microsoft Access

By leopold.durrant ·
What si the correct syntax for this formula in Microsoft Access?

I want to calculate the SSDed2 if net pay is greater than $975 and less than 1950 then $39 else 4 divided by 100 X Net Pay

This is my syntax but it is wrong.

SSDed2: IIf([NETPay]>1950,87.75,4.5/100*[NETPay])

Thanks

This conversation is currently closed to new comments.

4 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Microsoft Access

by chainsawz In reply to Microsoft Access

Here's the syntax

SSDed2: IIf([NETPay]<1950 And [NETPay]>975,39,(4/400)*[NETPay])

Good Luck!

Collapse -

Microsoft Access

by chainsawz In reply to Microsoft Access

Sorry! I forgot the = signs! Here's the correct formula: ssdet: IIf([net pay]<=1950 And [net pay]>=975,39,(4/400)*[net pay])

Collapse -

Microsoft Access

by leopold.durrant In reply to Microsoft Access

Poster rated this answer

Collapse -

Microsoft Access

by leopold.durrant In reply to Microsoft Access

This question was closed by the author

Back to Software Forum
4 total posts (Page 1 of 1)  

Related Discussions

Related Forums