2 Replies Latest reply on Jul 24, 2010 4:58 PM by LaRetta_1

    Need help with a formula



      Need help with a formula


      I am struglling with the correct formula using greater than and less than functions:

      Field X is a calculated field based upon the the number in field "Z" .

      If the number in Z is greater than 365 or less than 1,  I want the field entry in X to be blank or zero, if it is 365 or less or 1 or more I want it leave the entry as the number in Z.

      I have tried this and a few other variations with no success :  If(z ≥ 365 ,≤ 0;"";z)

      Thanks in advance.