Forum Discussion

Copper Contributor

Apr 09, 2021

IIf formula in microsoft project custom field

I added the following custom field with the formula: [Remaining Work] / [Remaining Duration] Now I want to add an "if" condition, meaning if a task is 100% complete, that no value or the value "...

John-project

Silver Contributor

Apr 09, 2021

Dale_HowardMVP,
Ismet Kocaman has a book on Project formula creation. It's not free and I don't know the price but I believe it is similar to Rod Gill's book on Project VBA. The link for Ismet's book is:

http://www.ismetkocaman.com/Formulas/eBook.html

ismet_kocaman

Brass Contributor

May 06, 2021

Thank you John, for your support. I appreciate it very much.