#1
|
|||
|
|||
Using multiple formulas in one (IF, AND and SUM) gives syntax error
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? |
#2
|
||||
|
||||
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] |
Tags |
bookmarks, formulas, macros don't work |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Syntax to use OFFSET() in a cell formula? | dlowrey | Excel | 3 | 07-09-2013 09:15 AM |
Multiple Formulas in one Cell one Formula Away From Completion | microsoftnovice | Excel | 2 | 12-05-2012 12:54 PM |
how to transfer multiple excel cells into specific place in word document by formulas | anton | Excel | 1 | 12-20-2011 03:56 AM |
Syntax help needed | blazzercat | Excel | 3 | 07-09-2009 02:15 PM |
How to transfer multiple cells from excel to word by formulas | justziggy | Word | 5 | 05-23-2009 02:33 AM |