Hello,
Anyone know how to block out 1m from this formula?
IF(FIND("2m4f", "market_name") > 0, 324, IF(FIND("3m1f", "market_name") > 0, 381, IF(FIND("2m1f", "market_name") > 0, 258, IF(FIND("2m3f", "market_name") > 0, 282, IF(FIND("2m6f", "market_name") > 0, 355, IF(FIND("2m2f", "market_name") > 0, 263, IF(FIND("1m6f", "market_name") > 0, 212, IF(FIND("1m3f", "market_name") > 0, 135, IF(FIND("2m5f", "market_name") > 0, 326, IF(FIND("2m7f", "market_name") > 0, 354, IF(FIND("1m4f", "market_name") > 0, 142, IF(FIND("1m2f", "market_name") > 0, 125, IF(FIND("1m5f", "market_name") > 0, 189, IF(FIND("1m1f", "market_name") > 0, 102, IF(FIND("3m3f", "market_name") > 0, 419, IF(FIND("3m7f", "market_name") > 0, 389, IF(FIND("3m4f", "market_name") > 0, 467, IF(FIND("3m2f", "market_name") > 0, 393, IF(FIND("3m5f", "market_name") > 0, 476, IF(FIND("3m6f", "market_name") > 0, 450, IF(FIND("4m1f", "market_name") > 0, 523, IF(FIND("4m3f", "market_name") > 0, 520, IF(FIND("1m7f", "market_name") > 0, 228, IF(FIND("4m2f", "market_name") > 0, 546, IF(FIND("5f", "market_name") > 0, 55, IF(FIND("6f", "market_name") > 0, 61, IF(FIND("7f", "market_name") > 0, 79, IF(FIND("4m", "market_name") > 0, 497, IF(FIND("3m", "market_name") > 0, 360, IF(FIND("2m", "market_name") > 0, 228, IF(FIND("1m", "market_name") > 0, 91, 0)))))))))))))))))))))))))))))))
I tried to remove it but triggers wouldn't work once I did that?
Thank you