result as #error

[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

[Sai Prasad]

#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]

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?

[Sai Prasad]

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

[Gamma Syahrial]

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

[Sai Prasad]

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

[Sai Prasad]

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

[Gamma Syahrial]

thank you, finally i can get rid all #error

[Author]

Posts