PDA

View Full Version : function operations



scrib3
05-14-2013, 04:23 AM
hey guys

just a quick question, when given a column of values, i want to create a function that performs a specific operation for all of the cells, for e.g. add 1 to the value then log it. any tips? :)

SamT
05-14-2013, 08:37 AM
Log it where?

mikerickson
05-14-2013, 10:32 AM
A function takes inputs and returns values.

It sounds like the CSE formula =A1:A1000 +1 will do what you want, but the question is where would you like those results displayed.

AMontes
05-15-2013, 01:50 AM
It seems you're looking for paste special:
http://www.contextures.com/xlDataEntry04.html

snb
05-15-2013, 01:59 AM
Sub M_snb()
[A1:A4] = [index(A1:A4+1,)]
End Sub