General discussion

  • Creator
    Topic
  • #2131125

    Microsoft Access

    Locked

    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

All Comments

  • Author
    Replies
    • #3569452

      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!

      • #3569446

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

      • #3576300

        Microsoft Access

        by leopold.durrant ·

        In reply to Microsoft Access

        Poster rated this answer

    • #3576299

      Microsoft Access

      by leopold.durrant ·

      In reply to Microsoft Access

      This question was closed by the author

Viewing 1 reply thread