How can I fix the following formula to not show #.Error! when denominator is 0?
field1__c/Field2__c
thank you for any help in advance.
답변 5개
Then this:
IF(
OR(
ISBLANK(Field2__c),
Field2__c = 0
), 1 ,
field1__c/ Field2__c
)
How can I fix the following formula to not show #.Error! when denominator is 0?
field1__c/Field2__c
thank you for any help in advance.
Then this:
IF(
OR(
ISBLANK(Field2__c),
Field2__c = 0
), 1 ,
field1__c/ Field2__c
)
