1 Reply Latest reply on Sep 5, 2012 2:41 PM by philmodjunk

    Silent auction bid sheet

    RayKlein

      Title

      Silent auction bid sheet

      Post

      I have a value for silent auction bid sheets and I can't figure out a calc to put a bid increment amount into a field.  Example: value = $100 or less would return a bid increment of $10, value = $101-$500 would return a bid increment of $25...

        • 1. Re: Silent auction bid sheet
          philmodjunk

          A Case function could do this:

          Case ( value < 100 ; 10 ;
                     Value < 500 ; 25
                     //and so forth as needed
                    )

          But it might be even better to set up a lookup up table so that the users can adjust what they want for bid increments by editing numbers in a table instead of having to redefine this calculation each time.