I need help with a custom forumula

[tcv123]

I have to create a custom formula that does the following:

IF
100% work complete,

THEN
(Actual Work-Baseline Estimate)

IF NOT, THEN
display "Incomplete"

Can anyone help?

 

[Mike Glen]

Hi tcv123,

Welcome to this Microsoft Project newsgroup

I think you're working the wrong way round. As I see it, you want
incomplete tasks to show the amount of work left to do, otherwise show it as
Complete. If I'vd got you right, try: IIf([% Work Complete]<100,[Baseline
Work]-[Actual Work],"Complete")

FAQs, companion products and other useful Project information can be seen at
this web address: http://project.mvps.org/faqs.htm

Hope this helps - please let us know how you get on

Mike Glen
MS Project MVP
See http://tinyurl.com/2xbhc for my free Project Tutorials