Microsoft Word 2016 - IF Formula - Syntax Code Error!!

Question

I want this

I did this

But I had this !

I need help.

Answer 1

It looks like you’re mixing Excel syntax with Word field codes, and Word is very picky about this. In Word tables, formulas must be inserted as field codes, not typed with {} manually, and the formatting switch goes at the end.

Use Ctrl+F9 to insert the field braces, then type the formula inside.

Change your formulas to the following:

{ =IF(A1*B1=0, "", A1*B1) \# "# ##0,00" }
{ =IF(A2*B2=0, "", A2*B2) \# "# ##0,00" }
{ =IF(A3*B3=0, "", A3*B3) \# "# ##0,00" }
{ =IF(A4*B4=0, "", A4*B4) \# "# ##0,00" }

For the total, Word works more reliably with positional formulas:

{ =IF(SUM(ABOVE)=0, "", SUM(ABOVE)) \# "# ##0,00" }

Key things that were causing your syntax errors:

You cannot type {} manually; Word only recognizes them when inserted with Ctrl+F9.

The formatting switch should be outside the formula, exactly like \# "# ##0,00".

Depending on your regional settings, commas and spaces in the number format must match your locale (you’re using comma decimals, so "# ##0,00" is correct).

After entering each field, press F9 to update it.

---

If the above response helps answer your question, remember to "Accept Answer" so that others in the community facing similar issues can easily find the solution. Your contribution is highly appreciated.

hth

Marcin