 ShowAll Questionssorted byDate Posted Alfredo Silverio

# Avoid Divided by 0

I try not divided by 0

I have variable with the Yearky Results this is the code
IF((AND(ISBLANK(Q1_c__c),ISBLANK(Q2_c__c),ISBLANK(Q3_c__c),ISBLANK(Q4_c__c))), 0,

IF((Q1_c__c + Q2_c__c + Q3_c__c + Q4_c__c) = Goal_Number__c,Goal_Number__c,

(((Q1_c__c + Q2_c__c + Q3_c__c + Q4_c__c)/Goal_Number__c)/4)))

With 4 Quarents with results

Variable = Q1_c__c
IF(OR(ISBLANK(Q1_Value__c),ISBLANK(Q1_Goal__c)),0,Q1_Value__c / Q1_Goal__c)

By in this quarter variables in one year you can use one quarter only or two or 3 or used all. And add to this you go over of 5,000 caracters in each formula. How can i do this Best Answer chosen by Alfredo Silverio Abdul Khatri
Hi Alfredo,

I added a OR Check to see if all the values are 0s

```IF(
OR(AND(ISBLANK(Q1_c__c),ISBLANK(Q2_c__c),ISBLANK(Q3_c__c),ISBLANK(Q4_c__c)), AND(Q1_c__c=0,Q2_c__c=0,Q3_c__c=0,Q4_c__c=0)), 0,
IF(
(Q1_c__c + Q2_c__c + Q3_c__c + Q4_c__c) = Goal_Number__c, Goal_Number__c,
(((Q1_c__c + Q2_c__c + Q3_c__c + Q4_c__c)/Goal_Number__c)/4)
)
)``` Abdul Khatri
Hi Alfredo,

I added a OR Check to see if all the values are 0s

```IF(
OR(AND(ISBLANK(Q1_c__c),ISBLANK(Q2_c__c),ISBLANK(Q3_c__c),ISBLANK(Q4_c__c)), AND(Q1_c__c=0,Q2_c__c=0,Q3_c__c=0,Q4_c__c=0)), 0,
IF(
(Q1_c__c + Q2_c__c + Q3_c__c + Q4_c__c) = Goal_Number__c, Goal_Number__c,
(((Q1_c__c + Q2_c__c + Q3_c__c + Q4_c__c)/Goal_Number__c)/4)
)
)```

This was selected as the best answer Abdul Khatri
Hey Alfredo,

Did it work? Suraj Tripathi 47
Hi Alfredo ,

I guess if you put your condition then that time the OR condition value should be zero(0s).
and the above code will help you to understand in better way.

If you find your Solution then mark this as the best answer.

Thank you!

Regards,
Suraj Tripathi Alfredo Silverio
Sorry guys for my late responds.

Works good with that change. Thanks for the help