@pcmoor said:
if using in the context of lenz attribute and assuming using cm, then value compare current("lenz")*2.54
lenz = if(current("lenz")*2.54<=240,240,if(current("lenz")*2.54<=270,270,if(current("lenz")*2.54<=300,300,360)))
if calculating a nearest_size attribute without forcing the lenz to snap to the result, then use
size = if(lenz<=240,240,if(lenz<=270,270,if(lenz<=300,300,360)))
Sometimes, I think I'm smart, and then someone proves to me I'm not so!
Sorry about the delayed response mate, I just got to try that and bang, works a treat!!!!!!!!
You are a modern day superhero!!!!!!