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
#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.
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?
Noticed you have used ; instead of , in the formula.
yes i have, its because the setting in windows
example in predecessor instead , it only work when i used ;
Please embed the screenshot of the error along with the values in Number3, Number16 and [Remaining Duration]
This happens because of divide by zero. Use this formula instead IIf(Number16>0,(Number3/Number16)*480,[Remaining Duration])
thank you, finally i can get rid all #error