Visokio website     Downloads     Video tutorials     KnowledgeBase  
Formulae: Two conditions in an IF statement using AND? - Visokio Forums
Formulae: Two conditions in an IF statement using AND?
  • amitbdesai August 19, 2013 4:21PM
    If have two condition called [TotalCommission] and [TotalSales].
    I want to put two condtions on these values like [TotalCommission]>0 and [TotalSales]>0 in IF statement.
    How can I do this question becausI am placing "AND" between this two statement but this does not work.

    My current formula looks like:

    IF(([GrossTotalCommission]>0 AND [GrossTotalSales]>0),([GrossTotalCommission]/[GrossTotalSales]),(SUM([CJTotalCommission]+[PPJTotalCommission]+[IRTotalFee]+[AdditionalFeeVertive]+[AdditionalFeeDarren])/([CJOrders]+[IROrders]+[PPJOrders]))

    EWhat can I add or improve to this statement to get result?

    Any help appreciate. Thanks a lot in advance.
    Amit
  • 2 Comments
  • DBuzacott August 19, 2013 8:46PM
    Amit,

    The syntax for the AND statement is "AND(condition1, condition2)", not "condition1 AND condition2".

    So the formula should be:
    IF( AND([GrossTotalCommission]>0,[GrossTotalSales]>0),
    ...
    )

    Daniel
  • amitbdesai August 20, 2013 10:02AM
    Thanks a lot Daniel, i will check this and will ask you if something goes wrong by me.
    thanks a lot again for your help.

    Amit

Welcome!

It looks like you're new here. If you want to get involved, click one of these buttons!

Sign In Apply for Membership