result as #error

Home Forums Discussion Forum result as #error

Viewing 7 reply threads
  • Author
    Posts
    • #411209
      Gamma Syahrial
      Guest

      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
      Sai Prasad
      Participant

      #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
      Gamma Syahrial
      Guest

      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
      Sai Prasad
      Participant

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

    • #411213
      Gamma Syahrial
      Guest

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

    • #411214
      Sai Prasad
      Participant

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

    • #411215
      Sai Prasad
      Participant

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

    • #411216
      Gamma Syahrial
      Guest

      thank you, finally i can get rid all #error

Viewing 7 reply threads
  • You must be logged in to reply to this topic.