1 Reply Latest reply on Oct 9, 2011 9:19 AM by Sorbsbuster

    IF Function

    BenjaminBeckert

      Title

      IF Function

      Post

      I have Table called Stock with field called "Quantity in stock", "Re-oder Level" and "Status".

      I want the status to tell me if the item is in stock or Low on stock or out of stock. Can someone please tell me a if function that i could use?

        • 1. Re: IF Function
          Sorbsbuster

          I would (almost) always use a Case Statement.  It is more flexible.

          You could try:

          Case (

          Quantity in stock <= 0 ; "Out of stock" ;

          Quantity in stock <= Re-order Level; "Order more stock" ;

          "OK"

          )

          This will check if you are out of stock, below the re-order point, or have enough stock.