Hi Experts,

Almost 3 years have passed since I found nice features of MS Word to use Excel calculations in tables including logical functions. But seems they work only with numbers.
In the table when using IF function is it possible to have returned set of numbers joined with letter like below:
Something like:
=IF(A1=330,"39x33x15",IF(A1=250,"25x23x15",IF(A1=0 ,0,"40x40x25")))
It is obvious that above construction will return syntax error.
Is it possible to make it work somehow?

To see how to do this and a wide range of other calculations in Word, check out my Microsoft Word Field Maths Tutorial, in the 'Sticky' thread at the top of this forum:
https://www.msofficeforums.com/word/...-tutorial.html

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Bookmark that link!

Download and save the Field Maths tutorial. Extract it from the zip file and put it in your documents or in a location where you can find it again.

It is a valuable resource.

I try to review it on a regular basis because I forget this stuff.

I checked this tutorial and hmm...there are some points I don't understand.
Tried "Testing and Returning Text Strings with Logical Functions in Bookmarks", but
seems bookmark can't contain numbers, so I it could not be referred to bookmarks in IF construction.
Tried the below:
IF A1="330 ml" "33x26x20" "" IF A1="250 ml" "25x22x15" "" IF A1=0,0,"39x26x25" \* MERGEFORMAT \* MERGEFORMAT \* MERGEFORMAT \* MERGEFORMAT
But field return only "ml".
Sample attached.
What I'm doing wrong?

Attached Files

sample.docx (11.8 KB, 8 views)

Your field code constructions are nothing like what Word requires or what is described in the tutorial. You might start there. You certainly don't need any of those \* MERGEFORMAT switches.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

But, this switches were inserted automatically.
Can you give me a tip what concrete section in the tutorial should I address?
I tried some constructions described in "returning text Strings", but still can't make it working...

Word did not insert the \* MERGEFORMAT switches as a result of applying anything in the tutorial. What's the point of the SKIPIF field in cell B1?

Done properly, your IF field code would look like:
{IF{=A1}= 330 "33x26x20" {IF{=A1}= 250 "25x22x15" "39x26x25"}}
You could even use a field coded as:
{=A1-250 \# "'33x26x20'; '39x26x25';'25x22x15'"}

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

The second code worked fine. I simply opened formula dialogue:
Layout-->Formula, then pasted your code there and all worked.
I just can't figure out how to add checking:
if A1 is empty, then show nothing..


Also I tried The first one code, but I must be doing wrong again:
I go to Insert -> Click on Explore Quick Parts -> Field and choose IF field.
Then trying to paste your first code and nothing happens(.

I even trying to toggle field codes in B2 cell and edit directly, but still can't make them working.

Attached Files

sample.docx (12.0 KB, 6 views)

To Insert an IF Field:

1. Type "IF" without the quotation marks and select it.
2. Press Ctrl+F9
3. Insert your logical test, your truetext and falsetext

Any time you are having trouble with an IF field check:

1. What is my logical test?
2. What is my truetext?
3. What is my (optional) falsetext?
4. Note that if you nest fields, all braces must be inserted in pairs by Word, not typed.

Great! Thank you guys so much for your help and hints! Finally it works!
I even added check empty cell condition:
(Sample attached).

But I assume that all of this will take too much time for everyday routine.
So I'd rather go using insert formula with Macropod's second code:

Could the check of empty cell be added here as well?

Attached Files

sample.docx (12.2 KB, 6 views)

For that you could use a formula coded as:
{IF{=A1}= 0 "" {=A1-250 \# "'33x26x20'; '39x26x25';'25x22x15'"}}

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

I think I finally learned it. Thank you!