Results 1 to 7 of 7

Thread: calculate the value of one cell by values of 2 other cells

Threaded View

  1. #6
    Fanatic Member ThomasJohnsen's Avatar
    Join Date
    Jul 2010
    Location
    Denmark
    Posts
    528

    Re: calculate the value of one cell by values of 2 other cells

    As .paul. suggested in this thread, the DataTable has a Compute method that can do some expression parsing. I haven't tested how extensive it is, but it might be a very simple solution to your problem (unless you feel like writing an expression parser - which isn't all that difficult to do; numerous examples available online).

    Tom


    #EDIT: I can't quite figure out which operator is used for exponention - suffice to say it isn't ^. Modulo is supported as c-notation %.
    Last edited by ThomasJohnsen; Apr 7th, 2013 at 10:14 AM.
    In truth, a mature man who uses hair-oil, unless medicinally , that man has probably got a quoggy spot in him somewhere. As a general rule, he can't amount to much in his totality. (Melville: Moby Dick)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width