March 2, 2018 at 4:52 pm
#469
Bill Finzer
Keymaster
Hi Randy,
Yes, it is possible, and with a single formula (though perhaps not as elegant as one would wish). The screen shot shows how, using attributes x and fLW. It’s basically a nested ‘if/else’. Notice that there’s no last else clause so when x is 13, fLW gets no value.
if(x<=10, 6.6,
if(x=11, 10,
if(x=12,0)))