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.