4 Replies Latest reply: Feb 13, 2015 12:48 AM by Jonathan Dienst RSS

    Include numbers but exclude during calc

      I have a number range 1-1000 which I successfully import.

      No 15,25,50,75 and 90, I need to exclude from all calculations but later on a seperate sheet display my analysis.

      How do I go about doing this.

      My statement reads as follows -

      If([number] >=1 and [number] <= 10000, 'Valid','Not defined') as d_type