Post reply

Help with an IIF statement please

  • February 19, 2015 at 7:21 am

    #297852

    Hello

    The following IIF expression isn't working for me:

    IIF(Fields!Number.Value BETWEEN 1 AND 1000, Fields!Number.Value, "all ok")

    Basically I want to list the value if it falls within 1 and 1000 and show 'all ok' if it doesn't.

    Please can you advise where I've gone wrong as this is throwing an error.

    Thanks

  • February 19, 2015 at 7:38 am

    #1778636

    =IIf(Fields!Number.Value >= 1 and Fields!Number.Value <= 1000

    , Fields!Number.Value

    , "All OK")

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply