Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi, i'd like to know if my expression is correct.
if parameter <1.5 give out extension
if paramter is in [1.5 ; 2[ give out 60
if parameter is in [2 ; 2.4[ give out 48
if parameter is > 2.4 give out 36
here is my solution. is expression correct?
if(parameter<10.5, 'extension',
if(parameter=1.5 or parameter<2.0, '60',
if(parameter=2.0 or parameter <2.4, '48','36')))
If(parameter >=1.5 and parameter < 2.0, '60',
If(parameter >=2.0 and parameter < 2.4, '48',
If(parameter >=2.4 and parameter <10.5, 'extension','36')))
If(parameter >=1.5 and parameter < 2.0, '60',
If(parameter >=2.0 and parameter < 2.4, '48',
If(parameter >=2.4 and parameter <10.5, 'extension','36')))
thank you
If this is working for you... Kindly close the thread by selecting appropriate answer so that others can also use it.