AnsweredAssumed Answered

Need help with a formula

Question asked by ChrisElliot on Jul 23, 2010
Latest reply on Jul 24, 2010 by LaRetta_1


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.