Syntax Error..... RRS feed

  • Question

  • I am using the following formula and getting a syntax error, but it is the same formula that I was using with a few additional arguments. Can anyone see the error? I wish SharePoint would point them out like Excel. 

    =IF(Family="Atlas","ML1",IF(Family="Magellan","ML1",IF(Family="Victoria","ML1",IF(Family="Mercury","ML1",IF(Family="Neptune","ML1",IF(Family="Mars","ML1",IF(Family="Apollo B56","ML2",IF(Family="Kronos","ML2",IF(Family="Helios","ML2",IF(Family="Kibo","ML2""STALL"))))))))))

    Wednesday, May 15, 2013 3:34 PM

All replies

  • Sorry. I was missing a comma (,) between "ML2" and "STALL" at the end in the equation above, but I put it in and I still have the same error:

    =IF(Family="Atlas","ML1",IF(Family="Magellan","ML1",IF(Family="Victoria","ML1",IF(Family="Mercury","ML1",IF(Family="Neptune","ML1",IF(Family="Mars","ML1",IF(Family="Apollo B56","ML2",IF(Family="Kronos","ML2",IF(Family="Kibo","ML2",IF(Family="Helios","ML2","STALL"))))))))))

    Wednesday, May 15, 2013 3:49 PM