#VALUE in Nu Correlation Function

  • Hi All,
    I don't know why this code returns #VALUE. Can you please help me?
    Even I replaced the Do Until loop part with direct equation i.e. something like Nu_Hashmi = 5*Re but still having this #VALUE return from my function.

  • Re: #VALUE in Nu Correlation Function

    Quote from pike;794254

    Hello HumanEngineer,
    What are the functions tcL_T and my_pT ?

    They are functions by XSteam (returning water properties for input temperature and pressure values). In order to simplify the add-in function calling, I just copied the XSteam module from the add-in section to my excel modules so I can easily call XSteam functions. I just checked by simple custom functions to check if the tcL_T and my_pT are the cause for this error of #VALUE return from the main function as:

    Function pala(T)
    'pala = tcL_T(T)
    pala = my_pT(4, T)
    End Function

    They returns as they suppose to do.

  • Re: #VALUE in Nu Correlation Function

    For ease of following my code, you can use the value of 1 for

    my_pT(4, Tbulk) / my_pT(4, Tsurf_temp)

    and for tcL_T(Tbulk) the value of 0.64

  • Re: #VALUE in Nu Correlation Function


    As long as you do declare your variables ... and input positive values, your UDF seems to function fine ...

    see attached ...

    Hope this will help

  • Re: #VALUE in Nu Correlation Function

    Thanks a lot for your help and for making me learn the trick of 'Exit Function' instead of my habit with using of 'goto 10 (any number)'. I become happy for this exit function trick more than my problem get solved. :)

  • Re: #VALUE in Nu Correlation Function


    Glad you could fix your problem ...

    Thanks ... for your Thanks ...:smile:

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Smiley" icon, below, in the bottom right corner :)

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!