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

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!

Categories

Ideas Parade

Tagged