Thread: Using multiple formulas in one (IF, AND and SUM) gives syntax error
View Single Post
 
Old 02-05-2014, 03:47 AM
markdeniet markdeniet is offline Windows 7 32bit Office 2007
Novice
  
Join Date: Feb 2014
Posts: 1
markdeniet is on a distinguished road
Default 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?
Reply With Quote