# HOW TO CALCULATE PLANNED % COMPLETE? • ### Question

• Appreciate your time to look into the formula that i am using and assist to overcome error occur at milestone which caused by zero duration divide by zero.

1. Number 1
Val(ProjDurConv(Duration,pjDays))

2. Number2
IIf(ProjDateDiff(Start,[Status Date])/480>=Val(ProjDurConv([Baseline Duration],pjDays)),Val(ProjDurConv([Baseline Duration],pjDays)),IIf(DateDiff(“d”,[Baseline Start],[Status Date])=Val(ProjDurConv([Baseline Duration],pjDays)),Val(ProjDurConv([Baseline Duration],pjDays)),IIf(DateDiff(“d”,[Baseline Start],[Status Date])<=0,0,ProjDateDiff(Start,[Status Date])/480))

3. Number3.
Number2/Number1

4. Text2
Format(Number3,"0%")

Sunday, July 28, 2019 4:28 AM

### All replies

• Try the following:

IIf(Number1=0,0,Number2)

Tanzim Akhtar

Sunday, July 28, 2019 1:22 PM
• Try the following:

IIf(Number1=0,0,Number2)

Tanzim Akhtar

Hi, Tanzim,

Where this formula shall put into?

Friday, August 16, 2019 3:17 AM
• Hello BenLau,

In Number3 you should put the following formula:

`IIf(Number1=0,Number2/Number1)`
This will take care of the error in sha' Allaah.

Tanzim Akhtar

Sunday, August 18, 2019 5:39 AM
• Hello BenLau,

In Number3 you should put the following formula:

`IIf(Number1=0,Number2/Number1)`
This will take care of the error in sha' Allaah.

Tanzim Akhtar

Hi, Tanzim,

I tried the formula as per your recommendation.

Now the number 2, which named as "% planned" shown more than 100%.

Sunday, August 18, 2019 7:19 AM