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

    Code
    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

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


    and for tcL_T(Tbulk) the value of 0.64
    Regards.

  • 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


    Hello,


    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 "Thumbs Up" 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!