+ Start a Discussion
Amanda JonesAmanda Jones 

IF/OR Statement Help

I'm stumped. I have written the following formula on a currency field:

IF(ISBLANK(TEXT(Assessment_Override__c)),(Amount*Assessment__c)+ CorrectCC_Fee__c,(Amount*VALUE(TEXT(Assessment_Override__c))+ CorrectCC_Fee__c))

It works great, except, I have a checkbox field that, when it equals true, I want this formula to return a value of zero. I just can't figure out how to write it. I think it should be an IF/OR statement, or maybe a CASE, but all of the examples I find aren't quite right.

The name of the checkbox field is  Do_Not_Assess__c.

Your superior brain power is much appreciated.
AmulAmul
please try this

IF(Do_Not_Assess__c==true,IF(
ISBLANK(TEXT(Assessment_Override__c)),
(Amount*Assessment__c)+ CorrectCC_Fee__c
,(Amount*VALUE(TEXT(Assessment_Override__c))+ CorrectCC_Fee__c),0)
 
Amanda JonesAmanda Jones
Hello Amul,

Here is the error message I received:

Error: Incorrect number of parameters for function 'IF()'. Expected 3, received 4
AmulAmul
try this one.

IF(Do_Not_Assess__c==true,(IF(
ISBLANK(TEXT(Assessment_Override__c)),
(Amount*Assessment__c)+ CorrectCC_Fee__c
,(Amount*VALUE(TEXT(Assessment_Override__c))+ CorrectCC_Fee__c)),0)