Help

If Statement Nesting Error

346 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Max_Mealing
4 - Data Explorer
4 - Data Explorer

This is not working for me - can anybody help correct?

 

IF({Count (Purchase Contracts Signed)} < 0 ; >=1399999,0,
    IF({Count (Purchase Contracts Signed)} <= 14000000 ; >=2399999, 0.007, 
      IF({Count (Purchase Contracts Signed)} <= 24000000; >=3299999, 0.01, 
        IF({Count (Purchase Contracts Signed)} <= 33000000, 0.013
      )
    )
  )
)
1 Reply 1
Ron_Daniel
7 - App Architect
7 - App Architect

Looks to me like based on the number of contracts signed, you're assigning one of four numbers:
0 - 1,399,999 is 0
1,400,000 to 2,399,999 is 0.007
2,400,000 to 3,299,999 is 0.010
3,300,000 and higher is 0.013
If that is correct, give this a try:

IF({Count (Purchase Contracts Signed)} <= 1399999,
0,
IF({Count (Purchase Contracts Signed)} <= 2399999,
0.007,
IF({Count (Purchase Contracts Signed)} <= 24000000,
0.01,
0.013
)
)
)