Home Forums Discussion result as #error

This topic contains 7 replies, has 2 voices, and was last updated by  Gamma Syahrial 3 weeks, 6 days ago.

Viewing 8 posts - 1 through 8 (of 8 total)
  • Author
    Posts
  • #411209 Reply

    Gamma Syahrial

    iam using formula “Actual Start+Actual Duration/480+Duration1/480-1” the problem is if i dont input value on actual start, actual duration, or duration1 it will show #error as result. is there a way to change %error with date value as “finish” column?

    i try using if command but keep get circular message error
    using Ms project 2016

    #411210 Reply
    Sai Prasad
    Sai Prasad
    Participant
    • Community Leader

    #Error is the result of invalid date returned formula. So, replace the formula of that column with IIf(IsDate([Actual Start]+[Actual Duration]/480+Duration1/480-1),[Actual Start]+[Actual Duration]/480+Duration1/480-1,[Finish]). This uses IsDate function to check if the formula returns valid date or not and accordingly uses the calculated value or the finish date. Hope this helps.

    #411211 Reply

    Gamma Syahrial

    thank you it work
    can i have another help?
    i kindly figure how the logic work but i have trouble with duration in days
    so my formula is IIf(Isnumeric((Number3/Number16)*480);(Number3/Number16)*480;[Remaining Duration])
    i already use isnumeric and isdate but it still show #error
    which fuction should i use to show remaining duration?

    #411212 Reply
    Sai Prasad
    Sai Prasad
    Participant
    • Community Leader

    Noticed you have used ; instead of , in the formula.

    #411213 Reply

    Gamma Syahrial

    yes i have, its because the setting in windows
    example in predecessor instead , it only work when i used ;

    #411214 Reply
    Sai Prasad
    Sai Prasad
    Participant
    • Community Leader

    Please embed the screenshot of the error along with the values in Number3, Number16 and [Remaining Duration]

    #411215 Reply
    Sai Prasad
    Sai Prasad
    Participant
    • Community Leader

    This happens because of divide by zero. Use this formula instead IIf(Number16>0,(Number3/Number16)*480,[Remaining Duration])

    #411216 Reply

    Gamma Syahrial

    thank you, finally i can get rid all #error

Viewing 8 posts - 1 through 8 (of 8 total)
Reply To: result as #error
Your information:




+ 63 = 64