Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win



Posted on 2006-12-01
Medium Priority
Last Modified: 2008-01-09
Simply put, why doesn't this produce a "bob". All I can manage is a "{"

{ IF { = AND ( { COMPARE "A" = "A" }, { COMPARE "B" = "B" } ) } = 1 "bob" "bob1" }
Question by:dlangman
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
  • 2
LVL 76

Expert Comment

ID: 18057913
I think it must be a bug. I get the same in Word 2000. I can test it in Word 2003 on Monday, unless that is the version that you are using anyway. Are you?

Author Comment

ID: 18069299
I am using office 2003.

Accepted Solution

Ken Turner earned 1200 total points
ID: 18100640
The expression works fine for me exactly as presented, and returns "bob".

I am using Word 2003 (11.8106.8107) SP2

How did you build it?  I simply did Ctrl-F9 to create { }'s where needed, and then typed/copied/pasted the other bits into them.

Nothing ever in the clear!

This technical paper will help you implement VMware’s VM encryption as well as implement Veeam encryption which together will achieve the nothing ever in the clear goal. If a bad guy steals VMs, backups or traffic they get nothing.

LVL 76

Expert Comment

ID: 18101299
Hi Ken, how are you doing?

Thanks for that prompt - I just tried it in 2003 and it works for me too.

So I tried it again on my (Word 2000) laptop system, and would you know, I can't make it go wrong again. Unfortunately I didn't save my previous efforts.

So dlangman, try typing the whole thing in again - it might just work. If it does, give Ken the points. His intervention will have saved the day.

Expert Comment

by:Ken Turner
ID: 18101371
Graham, I'm fine - good to hear from you.

Your suggestion re the points is very generous, thanks.

Happy Christmas to all our readers!

Author Comment

ID: 18102309
I just updated my office to the version KenTurner mentioned, typed it from scratch again and when I complete the merge I am returning this error message: Error! Unknown op code for conditional.
LVL 76

Assisted Solution

GrahamSkan earned 800 total points
ID: 18102378
I go that just now, but I had typed (leaving no space between the = and the 1):

} =1 "bob"

instead of

} = 1 "bob"

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
After seeing numerous questions for Dynamic Data Validation I notice that most have used Visual Basic to solve the problem. This suggestion is purely formula based and can be used in multiple rows.
The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…
The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …

650 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question