Nested IF statement for finding number value in range of values

Question

I have a currency field, "Currency" that I want to use in an IF statement in a calculated field. I am using SP2013. I have 6 different number ranges

ex)

IF "Currency"<25000 I want the calculated field to return "45"

IF 25000>="Currency"<250000 I want the calculated field to return "75"

IF 250000>="Currency"<1000000 I want the calculated field to return "100"

IF 1000000>="Currency"<5000000 I want the calculated field to return "150"

etc.

I can't figure out how to write the IF statement in the calculated field to achieve this. This post https://community.nintex.com/t5/Nintex-for-SharePoint-Forum/Nintex-Form-calculated-field-if-statement/td-p/107051 was helpful but as I have 6 different number ranges I need a way to incorporate all of them in one line.

Page 1 / 1

Hi,

i tested your cases with above formula. it seems to work

This worked perfectly, thank you!

shr47k · Accepted Answer

Hi, i tested your cases with above formula. it seems to work

skr35 · Answer

This worked perfectly, thank you!

Sign up