Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2007
    Posts
    12

    Unanswered: Calculated Control using If

    I would like to write a formula such as: If [cost] is less than or equal to $1000, $10 for the fee, otherwise use the formula =(([Cost]-1000)/1000)*2+10

    The formula shown works, but I cannot figure out how to write it as part of a conditional expression. As you have probably guessed, the field in the table is named "Cost".

    What happens with the formula is that the result is sometimes less than $10, but the minimum has to be $10.

    Thanks

    Sonnyboy

  2. #2
    Join Date
    May 2005
    Location
    Nevada, USA
    Posts
    2,888
    Provided Answers: 6
    IIf(Cost < 1000, 10, (([Cost]-1000)/1000)*2+10)
    Paul

  3. #3
    Join Date
    Sep 2007
    Posts
    12
    That worked for me. Thanks a lot.

    Sonnyboy

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •