Performing calculations with Nintex Forms using the calculated value control

[bimi82]

Hi,

use this function in the calculated value:

If(TextBox1<"1000", "Incidental", "Minor") && If(TextBox1<"10000", "Minor", "Moderate") && If(TextBox1>"20000", "Moderate", "Major") && If(TextBox1>"100000", "Major", "Severe")

I am sure there is a way to shorten it down but ...  not an expert

[shaunlub]

Better to nest the ifs:

If(TextBox1<"1000000", "Incidental", If(TextBox1<"10000000", "Minor", If(TextBox1<"20000000", "Moderate",If(TextBox1<"100000000", "Major","Severe"))))

Tested it; works fine(on-prem, SP2013)

Input no in Text Box control; Calculation in Calculated Value control

[obaidaaqel86]

Thanks a lot ,its working fine now

[obaidaaqel86]

Hi @shaunlub  again

I need ur help again , if I have textbox , the result of this textbox will be based on another 5 textbox's  ( he will take the highest value from these textbox) as following:

EXP1:

TXT1 : Incidental

TXT2: Minor

TXT3: Moderate

TXT4: Major

TXT5: SEVERE

RESRULT TXTBOX will be : SERVERE ( because its the height value).

EXP2:

TXT1 : Incidental

TXT2: Incidental

TXT3: Incidental

TXT4: Major

TXT5: Minor

RESRULT TXTBOX will be : MAJOR ( because its the height value).

EXP3:

TXT1 : Incidental

TXT2: Incidental

TXT3: Incidental

TXT4: Minor

TXT5: Incidental

RESRULT TXTBOX will be : Minor( because its the height value).

EXP4:

TXT1 : Incidental

TXT2: Moderate

TXT3: Incidental

TXT4: Minor

TXT5: Incidental

RESRULT TXTBOX will be : Minor( because its the height value).

how I can handle this in IFCondition Please?