Double column value in a spreadsheet

0

I need to double the value of a column (ex: C) into another (ex: F) for every row in a spreadsheet.
How can I achieve this?
This is probably simple, but I can't get my head around it.

Thank you.

Simon Arnold

Posted 2014-09-13T14:00:53.953

Reputation: 157

Answers

1

How about putting =2*C1 in F1 and copying the cell down the column.

LDC3

Posted 2014-09-13T14:00:53.953

Reputation: 2 062

1Or put =C1+C1 in F1 and copy to all the cells below, till you have values in column C. – Wishwas – 2014-09-13T16:00:01.660

1

Try this in your Google Spreadsheet (F1):

=ARRAYFORMULA(IF(ISBLANK(C:C),"",(C:C * 2)))

Jacob Jan Tuinstra

Posted 2014-09-13T14:00:53.953

Reputation: 353

Asked: 2014-09-13T14:00:53.953

Viewed: 116 times

Active: 2014-09-21T15:05:41.207