Results 1 to 4 of 4

Thread: IIF(), MIN(), MAX() functions

  1. #1
    Join Date
    Dec 2015
    Location
    New Jersey
    Posts
    61

    Question IIF(), MIN(), MAX() functions

    I can't get IIF, MIN and MAX functions to work. Is this a bug in shopbot? If not, can someone send me an example or the proper format for these functions.

  2. #2
    Join Date
    Dec 2000
    Location
    Thorp, WI
    Posts
    2,855

    Default

    Do you have an example of what you're trying to do?

    Have you seen this pdf (C:\Program Files (x86)\ShopBot\ShopBot 3\Help\Calculated_Functions.pdf)?
    Attached Files Attached Files
    Scott




  3. #3
    Join Date
    Dec 2015
    Location
    New Jersey
    Posts
    61

    Default

    I have seen that PDF, thanks. I don't have a current need, I just noticed that IIF, MIN and MAX don't seem to work.

  4. #4
    Join Date
    Dec 2015
    Location
    New Jersey
    Posts
    61

    Default

    Here's the code I used to test:
    &A = IIF(1,4,5)
    PRINT &A


    &B = (min(10,3,27,15))
    PRINT &B


    &C = (max(1,9))
    PRINT &C

    This is the output:
    IIF(1
    (min(10
    (max(1

Posting Permissions

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