IF(
ISPICKVAL( Locker_Color__c , "Custom Color" ), 2500, 0)
This has become a bit more complex now as this same value of Custom Color is being used for something else. New situation is:
If Locker color (picklist) = Custom Color, Custom Color Fee = $2500
If Locker Color (picklist) = Custom Color AND Custom Wrap (checkbox) = True, Custom Color Fee = $0
I had a formula that would set the Custom Color Fee to $0 if the Locker Color = Custom Color and the Custom Wrap = True, however, turns out in all other cases it is showing $2500 as a Custom Color Fee.
Formula used:
IF(
AND(
ISPICKVAL( Locker_Color__c , "Custom Color" ),
Custom_Wrap__c), 2500, 0)
How can I get a formula to return $0 on all other color options?
If Locker Color = anything but "Custom Color" and "Custom Wrap" is False, return $0 in Custom Color Fee. ?
Any help on this is much appreciated.
8 answers
How abou this one:
IF(
AND(
ISPICKVAL(Locker_Color__c, "Custom Color"),
Custom_Wrap__c
),
0,
IF(
ISPICKVAL(Locker_Color__c, "Custom Color"),
2500,
0
)
)
