none
How do I avoid #Error results in Microsoft Project Formulas RRS feed

  • Question

  • Hi - Is there a way of detecting errors in Microsoft Project 2010 formulae resulting from effects other than dividing by zero (which obviously can be prevented)?  For example, when a formula refers to an Actual Start which has a value NA, #Error results.  I can't find a way of detecting the NA or the #Error in order to avoid unsightly results in the table.  Can anyone help?

    With thanks

    Skerpie

    Sunday, March 3, 2013 10:29 PM

Answers

  • The #Error just needs to be found through testing - although, often hitting F9 to refresh the calculations will resolve it.

    To test for NA, you need to test for ProjDateValue('NA'), i.e. "=IIF([Actual Start]=ProjDateValue('NA'),"Unstarted","Started")"


    Andrew Lavinsky [MVP] Blog: http://azlav.umtblog.com Twitter: @alavinsky

    Monday, March 4, 2013 1:55 AM
    Moderator
  • Hi,

    Iif([Baseline Duration]>0,((([Finish Variance]/[Baseline Duration])*10) & "%"),"")

    Greetings,

    Wednesday, July 3, 2013 7:14 AM
    Moderator

All replies

  • The #Error just needs to be found through testing - although, often hitting F9 to refresh the calculations will resolve it.

    To test for NA, you need to test for ProjDateValue('NA'), i.e. "=IIF([Actual Start]=ProjDateValue('NA'),"Unstarted","Started")"


    Andrew Lavinsky [MVP] Blog: http://azlav.umtblog.com Twitter: @alavinsky

    Monday, March 4, 2013 1:55 AM
    Moderator
  • Hi Andrew,

     On the same lines i am having a custom field to calculate SV% and i get the same #error for a few fields; how can i use the following formula not to get #error and to replacce #error with zero or blank

    (([Finish Variance]/[Baseline Duration])*10) & "%"

    Thanks

    mp

    Wednesday, July 3, 2013 6:10 AM
  • Hi,

    Iif([Baseline Duration]>0,((([Finish Variance]/[Baseline Duration])*10) & "%"),"")

    Greetings,

    Wednesday, July 3, 2013 7:14 AM
    Moderator
  • Thanks Jan.
    Wednesday, July 3, 2013 7:28 AM
  • The #Error just needs to be found through testing - although, often hitting F9 to refresh the calculations will resolve it.

    To test for NA, you need to test for ProjDateValue('NA'), i.e. "=IIF([Actual Start]=ProjDateValue('NA'),"Unstarted","Started")"


    Andrew Lavinsky [MVP] Blog: http://azlav.umtblog.com Twitter: @alavinsky

    Thank you for the "F9", that helped me right now. Cheers, Anton

    Wednesday, May 17, 2017 3:54 PM