| T O P I C R E V I E W |
| ridge1988 |
Posted - 03/01/2011 : 2:52:28 PM
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?
Thanks in advance! |
| 2 L A T E S T R E P L I E S (Newest First) |
| Catkiller |
Posted - 03/02/2011 : 06:45:26 AM
Just an addon-information:
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":
col(a)[2*i]
|
| Sam Fang |
Posted - 03/02/2011 : 05:09:03 AM
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.
Sam
OriginLab Technical Services |
|
|
