skr35
Scholar

Nested IF statement for finding number value in range of values

Jump to solution

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-statemen...  was helpful but as I have 6 different number ranges I need a way to incorporate all of them in one line.

0 Kudos
Reply
2 Replies
shr47k
Scholar

Re: Nested IF statement for finding number value in range of values

Jump to solution

Hi,

shr47k_0-1636346680334.png

 

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

View solution in original post

0 Kudos
Reply
skr35
Scholar

Re: Nested IF statement for finding number value in range of values

Jump to solution

This worked perfectly, thank you!

Reply