You need to sign in to do that
Don't have an account?
Amanda 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.
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.
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)
Here is the error message I received:
Error: Incorrect number of parameters for function 'IF()'. Expected 3, received 4
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)