The Origin Forum
File Exchange
Try Origin for Free
The Origin Forum
Home | Profile | Register | Active Topics | Members | Search | FAQ | Send File to Tech support
 All Forums
 Origin Forum
 Origin Forum
 Multiply a cell for a number

Note: You must be registered in order to post a reply.
To register, click here. Registration is FREE!

Screensize:
UserName:
Password:
Anti-Spam Code:
Format Mode:
Format: BoldItalicizedUnderlineStrikethrough Align LeftCenteredAlign Right Horizontal Rule Insert HyperlinkUpload FileInsert Image Insert CodeInsert QuoteInsert List
   
Message:

* HTML is OFF
* Forum Code is ON
Smilies
Smile [:)] Big Smile [:D] Cool [8D] Blush [:I]
Tongue [:P] Evil [):] Wink [;)] Clown [:o)]
Black Eye [B)] Eight Ball [8] Frown [:(] Shy [8)]
Shocked [:0] Angry [:(!] Dead [xx(] Sleepy [|)]
Kisses [:X] Approve [^] Disapprove [V] Question [?]

 
Check here to subscribe to this topic.
   

T O P I C    R E V I E W
ispanico Posted - 03/25/2015 : 7:57:51 PM
Origin Ver. and Service Release (Select Help-->About Origin):
Operating System:

Hello,

this is my first time in this forum, and the first days I use OriginLab, so forgive me for this question:

having a number in a cell, can I multiply (or divide, or whatever math operation) for another number like the simple formula used in an Excel spreadsheet (for example, having the cell A1, I wanna multiply A1 for 10: in Excel I write = A1 * 10 , very simple)
I specify more clearly: I'm not asking how to multiply a column for another column. I mean a single cell, how can I multiply this for a number in a simple manner like in Excel, without open the menu "set the column values" ?
3   L A T E S T    R E P L I E S    (Newest First)
snowli Posted - 03/26/2015 : 10:08:23 AM
How about choose Worksheet: Worksheet Script... menu and set it as follows.


This dialog allows you to enter script and condition when the script should run.
In image above, I set it so whenever there is change in column A, multiply col(A)[1] cell by 10

You can click Do it and enter values in col(A)[1] cell to see the effect.

You can then choose File: Save Template as to save this workbook template for future use.

Thanks, Snow
ispanico Posted - 03/26/2015 : 05:04:46 AM
Ok, but in this way there's no automatic recalculation (like Excel) if I change the cell value.
jasonzhao Posted - 03/25/2015 : 10:05:24 PM
Hello,

Please click Shift+Alt+3 to open the Script Window, then enter the script below:

col(2)[1]=col(2)[1]*10;  //multiply the cell(r=1,c=2) by 10

Click Enter to execute.
You can refer to this page for further informations.

http://www.originlab.com/doc/LabTalk/ref/Col-func#Col.28colNameOrNum.29.5BrowNum.5D


Best regards!
Jason
OriginLab Technical Service

The Origin Forum © 2020 Originlab Corporation Go To Top Of Page
Snitz Forums 2000