Compound IF THEN ELSE

schergr · December 12, 2011 8:55AM

Whats the best approach for doing complex IF THEN ELSE logic such as

IF A = 1 and B= 2 then C=1
ELSE IF A=1 and B=3 then C = 2
ELSE IF A=1 and B=4, then C=3
ELSE C=4

????

schergr · December 12, 2011 9:07AM

Never mind. figured it out with the AND / OR operators.

chris · December 12, 2011 9:10AM

Hi,

You need to create a formula using the "IF" function.

The following page outlines all the functions in Omniscope. If you scroll the page down you should see the documentation on the "IF" function.

http://www.visokio.com/kb/functions-guide

In your example above create a new field called "C", change it to a formula field and enter the following formula:

IF(AND(A=1,B=2),1,AND(A=1,B=3),2,AND(A=1,B=4),3,4)

schergr · December 12, 2011 1:03PM

Yup. Got it. Thanks ;)

Welcome!

Categories

Ideas Parade