Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

If Statement Nesting Error

78 1
cancel
Showing results for 
Search instead for 
Did you mean: 

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

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
)
)
)