0 Replies Latest reply on Jul 2, 2011 4:26 PM by paulgower

    Field Question

    paulgower

      Title

      Field Question

      Post

      Hi,

      Could someone tell me how i can add more to this field basically from a drop down menu 'paper1' someone selects the paper they want, the field 'paper cost1' works out how much it costs. The problem i have is i only seem to be able to put 2 if commands into the field for 'paper cost1' when i actually have about 6 to put in.

      I'm new to this program so wanted to keep it as simple as possible !

      The calculation i have at the moment is..... If ( PAPER1 = "WHITE A4"  ; SHEETS USED 1 * .0075 ;If ( PAPER1= "GREEN A4" ; SHEETS USED 1 * .0675))

      The above works but it doesn;t if i try to put anymore in, if someone can help me with this it would be great.

      Paul.