Creating Formulas in custom field to avoid #ERROR

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

TQ so much Tom Boyle..its work nicely.

Tom Boyle
User offline. Last seen 2 hours 7 min ago. Offline
Joined: 28 Nov 2006
Posts: 153
Groups: None

Does this work?

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