Formula for when fields are not completed

Question

Hey guys this formula works well however, How do i make it work when fields aren't completed E.g

Formula for when fields are not completed

I'm thinking ISblanks but I don't know where to start.

Conversions__c * IF( Conversions__c < Account__r.Benchmark_Conversions_1__c, 0, IF( Conversions__c < Account__r.Benchmark_Conversions_2__c, Account__r.Target_1_CPA__c , Account__r.Target_2_CPA__c))

+

IF( Conversions__c < Account__r.Benchmark_Conversions_1__c, Account__r.Flat_Amount__c, IF( Conversions__c < Account__r.Benchmark_Conversions_2__c, Account__r.Target_1_Flat__c , Account__r.Target_2_Flat__c ))

Thanks in advance.

Afolabi Onanuga · Answer

A good example will be if Target 1 CPA is field but not target 2

Formula for when fields are not completed

Data Management

関連学習

さらにヘルプを表示