Nest IF statement
I need some assistance with a nested IF statement. I am attempting to select a contract category based on expected amount of the contract. Everything seems to work properly except when letter values are included in the contract cost which I was hoping to return a value of "Other".
This is the formula I am using: =IF([Contract Amount]1 = "", "Blank", IF(FIND("Variable", [Contract Amount]1) > 0, "Variable", IF([Contract Amount]1 < 25000, "<25k", IF(AND([Contract Amount]1 >= 25000, [Contract Amount]1 < 50000), "25k-50k", IF(AND([Contract Amount]1 >= 50000, [Contract Amount]1 < 100000), "50k-100k", IF([Contract Amount]1 >= 100000, ">100k", "Other"))))))
And here is a link to a sheet https://app.smartsheet.com/b/publish?EQBCT=bb26dd85c00e4d1fb81087f5fd443d43
The two variables I know will be consistent, Blanks and Variables work out well. And when an actual amount is entered it properly assigns the category. But when something else is entered a value category is returned instead of the intended Other response.
Thanks for for any help!
Help Article Resources
Check out the Formula Handbook template!