How to create a null value in word formulas

Question

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

Answer 1

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

Answer 2

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

Answer 3

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.