Nested And & IF Statements

I’m trying to build a 9box formula into my Monday board, but Monday keeps telling me this is an illegal formula. Please help


IF({Cost}=“Low”,“4”, IF({Cost}=“Medium”,“6”,“7”)),

IF({Cost}= “Low”,“1”,IF({Cost}=“Medium”,“2”,“3”)))))

Hi Lauren,

Remove the = at the beginning of your syntax. It seems to work fine otherwise.

Looking for a simpler way to write complex formulas? Check out the Advanced Formula Booster at It’s a convenient third-party app that simplifies formula writing. With it, you can spread your formulas across several lines, utilize variables, and access dozens of functions not found in the standard formula column.