Skip to Content
avatar image
Former Member

If then

Hi

I have  to created calculated column where the condition is below:

If field A is null, then compare  AMT1 = AMT2= AMT3 then say EQ  else NE

if field A is not null then compare AMT1 = AMT2= AMT3= AMT4.

How to write the formula ?

I tried by splitting in two columns as  test 1=  if(AMT1 = AMT2,"AMT1",'NE')

                                      test 2 =if(if(AMT3 = AMT4,"AMT3",'NE')

then CA= IF( Is NULL("A") = 1,if(test 1 = amt3,'E',IF( test 1 = test 2,'EQ','NE'). but getting error. Is it a good practice  to split up?

i tried like

IF( Is NULL("A") = 1,if(AMT1 = AMT2 and AMT3,'EQ',ifAMT1 = AMT2 and AMT3 and AMT4,'EQ','NE

both ways i am getting error.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Sep 28, 2015 at 05:28 PM

    Hi Ash,

    You can write in both ways, either split or as a single formula. For your logic, this should work.

    if(isnull("A"), if(("AMT1" = "AMT2") and ("AMT2" = "AMT3"), 'EQ', 'NE'),

    if(("AMT1" = "AMT2") and ("AMT2" = "AMT3") and ("AMT3" = "AMT4"), 'EQ', 'NE'))

    Regards,

    Chandra.

    Add comment
    10|10000 characters needed characters exceeded