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
Jan 16, 2023 03:13 AM
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
)
)
)
)
Jan 16, 2023 06:50 AM
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
)
)
)