This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I'm trying to use the Formula Tool to do a nested If statement so I can input from the left column and get the output like the right one (see below).
The if statement I wrote is "IF [Cash Rent] > 5000000 THEN 11790 ELSE if [Cash Rent] > 1000000 THEN 6000 ELSE IF [Cash Rent] >500000 THEN 2500 ELSE IF [Cash Rent] > 250000 THEN 900 ELSE 0 ENDIF" but Alteryx is giving me a "Malformed If Statement".