Jump to content

Logical Function Calculations


This topic is 5635 days old. Please don't post here. Open a new topic instead.

Recommended Posts

I'm trying to create a calculation (logical function) using the case function. What i want to do is create a calculation that gets information from two fields then turns that information into another field.

So what i want is

Case (Field 1 = "A" and Field 2 = "B" ; 3)

What i don't understand how to do is create the AND part of the equation so that i can incorperate more than one field into the logical function.

Also is there a way to do the same way but with the > or < functions. Thanks a bunch.

Jonny

Link to comment
Share on other sites

Well, it would work if there was a DEFAULT value specified after the 'AND' statement is evaluated.

I STILL copy the different statements form the pull down list and then replace the individual terms from my database, even though I have them pretty well memorized. That would show you need another semicolon and a default value before the closing quote.

And, yes, there would be an error message pop up if this was what you had in the calculation.

Link to comment
Share on other sites

This topic is 5635 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 account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

  • Who Viewed the Topic

    1 member has viewed this topic:
    Johnn 
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.