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?

In Word, the AND expression can only evaluate two variables. Word also uses a different syntax for IF fields. To see how to do this and a wide range of other calculations in Word, check out my Microsoft Word Field Maths Tutorial, at:
http://windowssecrets.com/forums/sho...Maths-Tutorial
or
http://www.gmayor.com/downloads.htm#Third_party
In particular, look at the items titled 'AND & OR: Testing Multiple Logical Numeric Expressions' and 'Testing Or Returning Text Strings With Logical Functions In Bookmarks'.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]