Thread: [Solved] Using COMPARE to compare more than two variables
View Single Post
 
Old 12-02-2011, 02:32 PM
Wyskers Wyskers is offline Windows 7 64bit Office 2007
Novice
  
Join Date: Nov 2011
Posts: 5
Wyskers is on a distinguished road
Default Using COMPARE to compare more than two variables
I have a rather lengthy document which has over 50 variables. I am trying to use COMPARE to get a true/false reading. My command is as follows:

{IF { =OR({ COMPARE Price = 2},{ COMPARE Price = 3 },{ COMPARE Terms = 2 },{COMPARE Terms = 3 },{COMPARE Terms = 4 },{ COMPARE Delay = "Y"})} = 1 "true" "false"

The words: Price, Terms, Delay are all responses to ASK prompts (bookmarks)

Is this even possible? Can I compare more than 2 fields?
Reply With Quote