This topic contains 7 replies, has 2 voices, and was last updated by Gamma Syahrial 1 year, 6 months ago.
- 11/14/2017 at 11:55 pm #411209
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 201611/15/2017 at 12:08 am #411210
#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.11/15/2017 at 2:06 am #411211
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?11/15/2017 at 2:53 am #411212
Noticed you have used ; instead of , in the formula.11/15/2017 at 3:26 am #411213
yes i have, its because the setting in windows
example in predecessor instead , it only work when i used ;11/15/2017 at 3:36 am #411214
Please embed the screenshot of the error along with the values in Number3, Number16 and [Remaining Duration]11/15/2017 at 3:42 am #411215
This happens because of divide by zero. Use this formula instead IIf(Number16>0,(Number3/Number16)*480,[Remaining Duration])11/15/2017 at 5:41 am #411216
thank you, finally i can get rid all #error