+1 800 256 3608 (toll-free in North America) or +49 7531 90 60 10| service@combit.com

Multiple If Statements


(Guest) #1

Is it possible to have multiple if statements

I am trying to do something like this

if(value1 <= .135) then value2 = value3 + .021
if(Value1 > .135 AND Value1 <= .3125) Then Value2 = value3 + .037
if(Value1 > .3125 and value1 <= .500) Then Value2 = value3 + .074

does anyone know how you would do this?

Thanks in advance


(Guest) #2

if(a < b, c, if (d < e, f, if (…)))

You can use Ctrl-Return to structure the expression in the edit control.

if(a < b,
c,
if (d < e,
f,
if (…)
)
)

Paulchen


(Guest) #3

Thank you for the reply I will try this right away and see if I can get it to work