Math question: Based on excel

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • MarkusJNZ@gmail.com

    #1

    Math question: Based on excel

    Hi, I have to do some math processing based on some sums in an excel
    spreadsheet.

    I just need the VB.NET equivalent..

    One of the cells (Lets call it cell G3) contains a percentage e.g. 3.2%

    How can I do the math against the cell?

    for example

    sum = (150 - 30) / (1 +(G3))

    TIA
    MarkusJ

    =============== =============== ==
    Ignore below
    jhgklioplsjduje hhrejhjrejhekds dlkasdlerksdksd
    =============== =============== ==

  • William Foster

    #2
    Re: Math question: Based on excel

    Tia,

    You just need to call a variable rather than a cell, so in Excel you say
    G3, in VB you would say Percentage_Valu e;

    i.e.

    Dim Percentage_Valu e as Integer
    Dim Total_Value as Integer

    Total_Value = (150 - 30) / (1 + Percentage_Valu e)

    I hope this helps !

    Yours sincerely,

    William Foster

    *** Sent via Developersdex http://www.developersdex.com ***

    Comment

    • MarkusJNZ@gmail.com

      #3
      Re: Math question: Based on excel

      Thanks!

      William Foster wrote:
      Tia,
      >
      You just need to call a variable rather than a cell, so in Excel you say
      G3, in VB you would say Percentage_Valu e;
      >
      i.e.
      >
      Dim Percentage_Valu e as Integer
      Dim Total_Value as Integer
      >
      Total_Value = (150 - 30) / (1 + Percentage_Valu e)
      >
      I hope this helps !
      >
      Yours sincerely,
      >
      William Foster
      >
      *** Sent via Developersdex http://www.developersdex.com ***

      Comment

      Working...