Using multiple formulas in one (IF, AND and SUM) gives syntax error

[markdeniet]

I am trying to use multiple formulas (IF, AND and SUM) based on bookmarks to calculate a sum only if several bookmarks (grades) are higher than 5,5. This formula works in excel, but not in word...

The formula is the following:


IF(AND(BOOKMARK1>=5,5; BOOKMARK2>=5,5; BOOKMARK3>=5,5;BOOKMARK4>=5,5); SUM(0,35*BOOKMARK1;0,35*BOOKMARK2;0,15*BOOKMARK3;0 ,15*BOOKMARK4)/10;4)

However, word does not accept this formula (syntax error), can anyone help?