Hi, I am unable to figure out how to write an IF function with a few “greater than less then”.
This is simplified example of what I am trying to achieve here:
When the length of an object is 10<LenX<20, and 50<Lenx<60, the copies are equal to 1, else it is equal to 2.
I manage to make this work with one “greater than less then” only:
Copies= IF(Lenx>10,IF(LenX<20,1,2),2)
What would be the correct protocol for a few of them?
Thank you for any suggestions