mhemans Posted February 10, 2005 Share Posted February 10, 2005 I am looking to create a calculation with a result that is based on 2 different text fields. For example: field one contains "Blue" and field two contains "Red", I want to show a result of "purple". Any suggestions? Link to comment Share on other sites More sharing options...
Fitch Posted February 10, 2005 Share Posted February 10, 2005 Case( field one = "Blue" and field two = "Red", "purple", field one = "Yellow" and field two = "Blue", "green" ) Link to comment Share on other sites More sharing options...
mhemans Posted February 10, 2005 Author Share Posted February 10, 2005 Anything special to add 3 fields and one result? Link to comment Share on other sites More sharing options...
-Queue- Posted February 10, 2005 Share Posted February 10, 2005 What do you mean? Link to comment Share on other sites More sharing options...
mhemans Posted February 10, 2005 Author Share Posted February 10, 2005 for example: field 1 = blue, Field 2 = red, Field 3 = pink with a result of dark purple Link to comment Share on other sites More sharing options...
-Queue- Posted February 10, 2005 Share Posted February 10, 2005 Case( field one = "blue" and field two = "red" and field three = "pink", "dark purple" ) Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 6621 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now