Welcome to Planning Planet, checkout the Guild of Project Controls Knowledge CAR

Creating Formulas in custom field to avoid #ERROR

2 replies [Last post]
Mefa Planner
User offline. Last seen 23 weeks 1 day ago. Offline
Joined: 19 Jul 2016
Posts: 6

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

Replies

Mefa Planner
User offline. Last seen 23 weeks 1 day ago. Offline
Joined: 19 Jul 2016
Posts: 6

TQ so much Tom Boyle..its work nicely.

Tom Boyle
User offline. Last seen 6 hours 10 min ago. Offline
Joined: 28 Nov 2006
Posts: 112
Groups: GPC Qatar

Does this work?

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