+ Start a Discussion
Erin Evarts 13Erin Evarts 13 

Exclude picklist type from formula when calculating commission

I am trying to exclude an Opportunity Type picklist value when calculating a commission.
My formula is:
IF (NOT(ISPICKVAL(Type, 'Flooring')))
   Total_Amount_Invoiced__c >= 5000.00,
   500.00,
    0.00)
If the Total Amount Invoiced >= 5000.00 for all Opportunity types EXCEPT 'Flooring', return 500.00, if not >=5000.00, return 0.00.


IF ( 
Total_Amount_Invoiced__c >= 5000.00, 
500.00, 
0.00) 
works but need to exclude 'Flooring' and I am stuck. 
 
Best Answer chosen by Erin Evarts 13
@anilbathula@@anilbathula@
Hi Erin,

There was a extra brace after flooring,Now removed that try this code :-
IF (AND(NOT(ISPICKVAL(Type, 'Flooring')),
   Total_Amount_Invoiced__c >= 5000.00),
   500.00,
    0.00)

Thanks
Anil.B

All Answers

@anilbathula@@anilbathula@
Hi Erin,

Try this formula:-

IF (AND(NOT(ISPICKVAL(Type, 'Flooring'))),
   Total_Amount_Invoiced__c >= 5000.00),
   500.00,
    0.00)

Thanks
Anil.B
Erin Evarts 13Erin Evarts 13
Hi Anil,

Thank you for responding so quickly .I received Error: Syntax error. Extra ','.
I don't see where to remove , from this:
IF (AND(NOT(ISPICKVAL(Type, 'Flooring'))),
   Total_Amount_Invoiced__c >= 5000.00),
   500.00,
    0.00)
@anilbathula@@anilbathula@
Hi Erin,

There was a extra brace after flooring,Now removed that try this code :-
IF (AND(NOT(ISPICKVAL(Type, 'Flooring')),
   Total_Amount_Invoiced__c >= 5000.00),
   500.00,
    0.00)

Thanks
Anil.B
This was selected as the best answer