Origin Ver. and Service Release (Select Help-->About Origin): origin pro 8.5 Operating System: windows 7
Hi, This is really basic but I can't work out whether or not origin can be used to perform basic calculations like you can on excel. For instance if you type '= 5 x 6' into a cell, as you would with excel, nothing happens. I tried hitting the 'function' button but this draws a graph, I just want to be able to make new columns with calculations in. For instance; I currently want to divide all the values in one column by 1000 and make a new column to plot to a graph, how would I go about doing this?
Select a column e.g Column C, right click on it and select Set Column Values from the short-cut menu. In the Set Values dialog, type e.g. Col(B)/1000. This will set Column C to Column(B)/1000.
to get access to individual cells in the "set values"-dialog, you can use the following notation:
col(a)[2]
which adresses the second row in col a by that you are easily able to perform more complex operations such as selecting every second value of a col by using the continous index "i":
performing basic calculations
Posted - 03/01/2011 : 2:52:28 PM
