Share via

How to create a null value in word formulas

Anonymous
2020-05-24T14:14:02+00:00

It is possible in word to create a table just like in excel. In these tables it is also possible to run logical statements. I'm trying to let an if statement return a null value but i can't seem to acomplish this. In excel i would create an empty string by adding to quotation marks like in the following example {if(a3>1);a3;"")}. If I would use this syntax in word I get a syntax error. What would be the correct syntax or another workarround for this situation. 

Thanks in advance for your time. 

Cheers

Microsoft 365 and Office | Word | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

5 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Paul Edstein 82,861 Reputation points Volunteer Moderator
    2020-05-24T22:21:56+00:00

    Word formula fields use a different syntax from Excel.

    To see how to do this and a wide range of other calculations in Word, check out my Microsoft Word Field Maths Tutorial, at:

    https://www.msofficeforums.com/word/38720-microsoft-word-field-maths-tutorial.html

    or:

    http://www.gmayor.com/downloads.htm#Third_party

    In particular, look at the item titled Formatting Numeric Field Results.

    1 person found this answer helpful.
    0 comments
  2. Deleted

    This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.

    Comments have been turned off. Learn more

  3. Deleted

    This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.

    Comments have been turned off. Learn more

  4. Anonymous
    2020-05-24T14:55:19+00:00

    Hello, 

    First and foremost thank you for your reply. I hope that resorting to VBA will not be neccesariy to solve my problem since I have next to no experience in VBA. I expect (and hope) that my issue is a simple syntax issue. I have the following statement in a table, 

         =IF(c2>0;product(c2;a2);"")

    I want it this statement to check for a value in c2 if there is a value there i want to multiply it with another value otherwise i want the cell to remain blank. Because otherwise there will be random zero's that would make the layout confusing.

    I know that in excel "" would return an blank cell but in word i get a syntax error as return. So i hope you can help me to achieve the result of a blank/empty cell. 

    Cheers

    0 comments
  5. Anonymous
    2020-05-24T14:30:44+00:00

    Hello ,

    You may want to check forum that will help you further on your coding.

    https://answers.microsoft.com/en-us/msoffice/fo...

    This forum is a user-to-user support forum. I'm an independent advisor.

    If you have further questions please hit the reply button.

    Hope this helps.

    Regards

    0 comments