Results 1 to 3 of 3
  1. #1
    Join Date
    May 2005
    Posts
    54

    Red face Unanswered: If a value is less than....form question

    I trying to create an argument for the following unbound textbox in a form:

    =[InvoiceAmount]*0.0021

    if the Invoice Amount *0.0021 is less than $25.00, I want it to return a value of $25.00.

    How can I do this? Any help would be very greatly appreciated.

    Thanks,

    Mary
    Last edited by somthinboutmary; 10-05-07 at 11:34.

  2. #2
    Join Date
    Apr 2004
    Location
    metro Detroit
    Posts
    634
    =iif([InvoiceAmount]*0.0021 >25,[InvoiceAmount]*0.0021,25)

  3. #3
    Join Date
    May 2005
    Posts
    54
    Thank you for your help!!

Posting Permissions

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