IF statement... With two conditions

[#1]

I want to use a IF Statement which has two conditions to satisfy and on the basis of the two conditions, it should return True or False.

I am using the following expression--->

=IF(age>30 AND Sal>200, 1,0)

however this returning me a False value even if Both the conditions are met !

Can someone tell me where am i going wrong ?

[MayilVahanan]

Hi

Can you provide a sample file? Without see that scenario, we can't able to give solution. Expression looks ok

[jpapador]

Instead of using AND trying using a nested if:

If(Age > 30,

     If(Sal > 200, 1,0))

[john_duffy]

Hello.

The syntax of your if statement looks correct.  I believe if the conditions are met and you want the result to represent 'true', you should replace 1 with -1.

John.

[#5]

Thanks Jpapador !

It helped

so i want to aggregate the output of the IF condition on a Dimension, and Sum it based on the Dimension selected in the Dimension selection in charts

Something like this -->

=sum(Aggr(if(Age>30,

          if(Sal>200,'1','0')),EMPID]))

---------------------------------------

Where i want to aggregate on EMPID and

Sum based on a Dimension lets say X

Any Idea how to go about it ?