Multiple If Statements

English Forum
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

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

3

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