Creating Formulas in custom field to avoid #ERROR

2 replies [Last post]
Mefa Planner
User offline. Last seen 40 weeks 4 days 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 40 weeks 4 days ago. Offline
Joined: 19 Jul 2016
Posts: 6

TQ so much Tom Boyle..its work nicely.

Tom Boyle
User offline. Last seen 1 day 5 hours ago. Offline
Joined: 28 Nov 2006
Posts: 142
Groups: GPC Qatar

Does this work?

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