Skip to content
ProjectControls.com
Microsoft Project

Creating Formulas in custom field to avoid #ERROR

In the Open Standard
Mefa PlannerMember for 10 years 3 months
Created
2
3
0

Hai,

I need help to create this formula in custom field ([ACWP]/[Cost])*100 to avoid #ERROR becoz some of data in cost is value 0..pls assist me

Save Follow Follow forum Report
Reply New topic

2 replies

Oldest first
  1. 0
    Tom Boyle ·
    #1

    Does this

    Does this work?

    IIf([Cost]>0,([ACWP]/[Cost])*100,0)

    Report
  2. 0
    Mefa Planner ·
    #2

    TQ so much Tom Boyle..its

    TQ so much Tom Boyle..its work nicely.

    Report

Log in or join to reply

ProjectControls.com is free to join. Members can post questions, reply, vote and follow discussions.

Log inJoin free

Existing members: your original username and password still work. Forgot password?