# result as #error

Home Forums Discussion result as #error

Viewing 8 posts - 1 through 8 (of 8 total)
• Author
Posts
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

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.

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?

Participant

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

Gamma Syahrial
Guest

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

Participant

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

Participant

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